Since I didn't get an answer to this, I went ahead and created BCAs for each stored procedure in the set and templatized the function that calls the SPs. It...
Hello everyone, I'm having an odd problem with calling a stored procedure using a std::string parameter. If I use a std::string parameter, I can not get the...
Roger, Please take a look at the sql_iterator docs. Basically, for std::string we use SQLGetData/SQLPutData. ODBC has a rule that says any parameters...
Thank you for your reply, Corwin. When I try to have both parameters be: wstring par; wstring ret; I get the following error: Database error: Exception type:...
Top 10 Home Business Opportunities for 2007 Small business Home Business resources to help you start, manage and grow your home business. Business ideas,...
You just need a templated BCA something like template<class N> class BCA_N { static void VariantBCA(BoundIOs &boundIOs, variant_row &dataObj) { // make the...
Top 10 Home Business Opportunities for 2007 Small business Home Business resources to help you start, manage and grow your home business. Business ideas,...
Oh yeah, I think this is a client side cursor issue so try: - Switching over to client side cursors with row_iter.GetStmt().ClearStmtAttrs(); - Retrieving the...
Corwin, Thank you for the suggestion. Unfortunately, I'm still getting the function sequence error. Below is the code I have now and also the ODBC trace...
Hi All, Do you know there is any way to insert time fraction to database, i.e. HH:MM:SS.ffffff . Both TIMESTAMP_STRUCT binding and jtime_c binding seem not to...
If you have set the fraction, that should be it as far as ODBC is concerned, what I would check next is a) What type are you using for the field in your...
Hi Corwin, I am using MSSQL 8.0, the field in database is (datetime) and it supports fraction. I can insert the fraction by execute direct query: insert into...
Corwin, I've done some more experiments, but have still not been able to make the string return parameters work. I have done the following: - Went back to...
Corwin, Some more info... I set up a fresh project using another computer with VC++ 6.0 and connected to another SQL Server 2000. I downloaded and recompiled...
A Man Who Turned a $15,000 Stock Account INTO $3,296,000 AND WHAT I Learned From It I know a man who turned a $15,000 trading account into $3.3 Million. It...
Roger, Given your parameters your BCA should really be: struct bca_ { void operator()(dtl::BoundIOs &cols, variant_row& row) { cols[0] << row._int(); // ret ...
Hi Corwin, As far as I know, for SQL Server stored procedures, there aren't any output only parameters -- they're either input or input/output. You said: <<...
Find Free Hosting now - search many categories. Free 1GB Online Storage Plus Sharing, Backup, FTP Software Drag-drop, super fast like local! $0.00 Free Web...
Find Free Hosting now - search many categories. Free 1GB Online Storage Plus Sharing, Backup, FTP Software Drag-drop, super fast like local! $0.00 Free Web...
I have just started to try using DTL with ODBC on Windows (mainly XP) but I am running into a problem. One of the DB I was experimenting with has a field name...
Yes. DTL does not know about the reserved key names for various flavors of databases so it will not quote them. It would be simple to modify the DynamicDBView...
OK. I had time to take a look at this. 1. DTL is written so that it does not use SQLGetData on output parameters. This means that if you wish to retrieve...
100% Free Site Submission Submit your URL absolutely Free to 8000 + Free for all Link Pages. Absolutely Free Submission Service. GO GO:: http://lnk.in/4e2d or ...
Hi there! I have been having a really rough time getting the DTL working and there seems to be not much support outside of this forum. I can't figure out how...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
