Do you have a context? New UV version? Old process just stopped working? New version of software X or Y? New server? New everything and old query A or updated query B? Those error message aren't helpful without some context...
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Judy M Sent: Wednesday, 19 March 2014 3:38 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2 ODBC error U2 UviVerse verions is The version of UniVerse TIO run is 11.1.9. ODBC U2 version is 32 bit 6.140.01.7533 I am call the ODBC DSN from Cognos Data Manager V10.2.1. This is the last entry in the ODBC log.... anyone give me any pointer. databuild.exe" cfc-c40 ENTER SQLGetDiagRecW SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 0x0018CCC8 SQLSMALLINT 1 SQLWCHAR * 0x0032C4A8 SQLINTEGER * 0x0032C610 SQLWCHAR * 0x0018D9D0 SQLSMALLINT 512 SQLSMALLINT * 0x0032C61C databuild.exe" cfc-c40 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 0x0018CCC8 SQLSMALLINT 1 SQLWCHAR * 0x0032C4A8 [ 5] "S1003" SQLINTEGER * 0x0032C610 (0) SQLWCHAR * 0x0018D9D0 [ 55] "[Rocket U2][U2ODBC][0400864]SQL data type out of range." SQLSMALLINT 512 SQLSMALLINT * 0x0032C61C (55) databuild.exe" cfc-c40 ENTER SQLGetDiagRecW SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 0x0018CCC8 SQLSMALLINT 2 SQLWCHAR * 0x0032C4A8 SQLINTEGER * 0x0032C610 SQLWCHAR * 0x0018D9D0 SQLSMALLINT 512 SQLSMALLINT * 0x0032C61C databuild.exe" cfc-c40 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND) SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 0x0018CCC8 SQLSMALLINT 2 SQLWCHAR * 0x0032C4A8 SQLINTEGER * 0x0032C610 SQLWCHAR * 0x0018D9D0 SQLSMALLINT 512 -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/U2-ODBC-error-tp42865.html Sent from the U2 - Users mailing list archive at Nabble.com. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ************************************************************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users