This problem resembles my recent problem with ODBC between HP-Ux and MS-SQL. Tech Support at Rocket indicated that I would probably have to buy special (ODBC) drivers from companies that specialize in data integration because... ODBC is a Microsoft thing and this sort of connectivity is not bundled with most (maybe any) flavors of Unix.
Rocket agreed that using UniObjects would be an easier alternative. --Bill -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, January 13, 2010 7:39 AM To: U2 Users List Subject: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS Hi I am trying to use SSIS to load UniData tables to SQL Server 2008. I already have been using DTS with SQL Server 2000 successfully for a while and I set up everything (System DSN and UCI Editor) the same on the 2008 server. The connection test works fine, but when I try to go further I get this error message. > Cannot get string literals from the database connection > "Provider=Informix.UniOLEDB.1;Password=;Persist Security > Info=True;User ID=admin;Data > Source=LIVE_DATA;Location=LIVE_DATA;Mode=Read" We are running Unidata 5.2 on Solaris. And I am using UniDK for that release on both SQL Server boxes. I had tried using a later version of UniDK before, but that didn't seem to want to connect to the older version of UD at all. Any ideas? Thanks Mecki _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users