And a couple of others: Are you posting to binary, text, or date columns? If you set up a table with purely varchar or nvarchar cols, can you post to that? I've seen similar errors when updating SQL Server directly (not using DTS) while trying to access binary or date/time columns where it could not interpret the type correctly.
Brian 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: u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/