Hi One of my clients is getting this error too. It is a simple query that just gets all rows from a single table and has an ORDER BY parameter. I have no idea why this query doesn't work but every other query I've run and more complex queries work.
I was just wondering if you found the cause or a fix for this error or if anyone else out there can give any assistance it would be greatly appreciated. Thanks Zoe Williams [EMAIL PROTECTED] > Hi, > > select * > from tblOwner.tblName > where Cast(colA As varchar(50)) = 'someValueFromVar' > > The above sql stmt executes fine with Command Line Processor, however, > > when it is called from an ODBC driver, I set up a data source using > IBM ODBC Driver, ver 8.01 dated 10/24/2002 on my Windows XP machine, > tested connection, fine, then, set up CFMX datasource, tested > successful, but for script execution, I got the following error, the > funny thing is other similar sql statement is just fine, how come? > > Thanks. > > [MERANT][SequeLink JDBC Driver]An internal error occurred. > > Details: > SQL select * from owner.tbl where EMPNO = '000140' > DATASOURCE DB2ODBC_testDS > VENDORERRORCODE 7369 > SQLSTATE HY000 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194682 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
