Let's start with the basics: 1) What version of the UV/ODBC driver are you using to "push" the data from SQL Server into UV? 2) UV version and OS platform 3) Not really applicable in this particular issue, but: if on UNIX platform: what ODBC driver manager are using and the version? Have you re-linked UV with the ODBC driver manager? 4) have you ever had this work before? 5) have you successfully connected to UV from SQL server, if so - at what point does it fail?
David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, 21 October 2007 6:29 AM To: [email protected] Subject: [U2] Universe and Microsoft Data Transformation Services (SQL Server) Hi, I am trying use the Microsoft Data Transformation Services (SQL Server) to get some records from a Oracle table and put into a Universe file, but when I try to connect to Universe it shows to me two errors, after verify the log file I can identify them : UCI SQLSetConnectOption(NLS) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. UCI SQLSetConnectOption(LOC) returned -1 SQLSTATE : S1009 Native Error : 0 [IBM][SQL Client]An illegal option value was specified Facility: DBCAPERR Severity: ERROR Error ID: 43 Extern error: 0 Message: Invalid connection or statement option value. Somebody know how do I do do solve this problem? Somebody have used Data Transformation Services with Universe? ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
