Thanks Bill, I don't think it is an ODBC problem since SSIS connection managers unlike DTS don't use ODBC. They use OLEDB and connect even without the IBM U2 ODBC driver installed. I maybe have to add that both SQL Server 2000 and 2008 run under Windows 2003, so I don't think this is an OS issue either.
If anybody has any suggestions how to use UniObjects with SSIS I would give that a try immediately. Easiest would of course be to upgrade to UD 7.2 but unfortunately I haven't been able to convince management to approve that. Mecki -------- Original-Nachricht -------- > Datum: Wed, 13 Jan 2010 10:36:27 -0500 > Von: "Brutzman, Bill" <[email protected]> > An: "U2 Users List" <[email protected]> > Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS > > 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: [email protected] > [mailto:[email protected]] 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 > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
