RE: [U2] Universe and Microsoft Data Transformation Services (SQL Server)

2007-10-23 Thread Brian Leach
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

RE: [U2] Universe and Microsoft Data Transformation Services (SQL Server)

2007-10-22 Thread Hona, David S
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-lin

RE: [U2] Universe and Microsoft Data Transformation Services (SQL Server)

2007-10-22 Thread Janet Bond
Hello Marcos, Please contact me I can connect you with our developers to review this process. Thanks Janet Bond FusionWare Corporation Sales Operation Manager 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sa

RE: [U2] Universe and Microsoft Data Transformation Services (SQL Server)

2007-10-21 Thread Tony G
There's an answer, but if I told you what it was we'd all spend the next week bickering about my motivation for providing solutions. Email if interested. Tony Gravagno Nebula Research and Development TG@ removethisNebula-RnD.com -Original Message- I am trying use the Microsoft Data Trans

Re: [U2] Universe and Microsoft Data Transformation Services (SQL Server)

2007-10-20 Thread Ray Wurlod
Not really enough to go on. Can you perform an ODBC trace and see what the SQLSetConnectOptions() calls were attempting to do, and with what argument values? Then compare these against the legal argument values in the UniVerse documentation (the easiest is HELP BCI SQLSetConnectOptions command