ADO vs CC

[huntjr]

This really has me puzzled...

I have the following SQL statement:

SELECT DateAdded, Folder, Filename, FolderID FROM MasterKey WHERE MasterKey=6301;

I am using ADO and the following connection string:

Provider=MSDASQL.1;Extended Properties="DRIVER={MySQL ODBC 3.51 Driver};DESC=;DATABASE=IE26Conv;SERVER=PHILH;UID=root;PASSWORD=;PORT=3306;OPTION=131072;STMT=;"

(Yes I know I'm going through OLE DB for ODBC instead of the native OLE DB provider).

Using ADO, the above very simple SELECT statement returns zero records, but if I open an SQL window in CC (on Windows XP) and execute the exact statement above, it returns the one record it is supposed to.

The rest of the application, with its SELECTs, INSERTs, DELETEs, UPDATEs works. Any ideas???


Phil Hunt
philh@dqc.com

 

[sleipnir214]

The only thing I can think of off-hand is a data type conversion problem of some kind.

What type of column is MasterKey in your table?



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[huntjr]

sleipnir214,

MasterKey is of data type int. Funny thing is, I dropped the database and recreated it, and it now seems to work??? Bizarre...

Thanks for your input. I still can't explain what happened...


Phil Hunt
philh@dqc.com