Hi,
With some playing around, I have found that OLEDB seems to be much more
stable that ODBC. For awhile, we were recieving random disappearances of
ODBC datasources, which required a reboot.
Anyway, the problem I'm having is that the results from OLEDB aren't
consistant with those in ODBC. Example: I have one query that returns a
series of results, and the query is dynamically generated. This works
*perfectly* under ODBC. Under OLEDB, it returns zero records.
I've tried even moving the query to a stored procedure and generating it
dynamically from there. No good. Regardless of what I've tried, simply
changing from ODBC to an OLEDB datasource effects the results returned.
Any ideas, thoughts, help?!?
Thanks,
Geoff B
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.