You're right Jerry, since September of last year UD 5.2 isn't supported anymore . But firstly the company is planning to go to Oracle so they convinced the auditors to accept that. Furthermore we are an Epicor site, and from what I heard they made a special deal with IBM to keep supporting 5.2 for their customers a bit longer. Well, if you can call that what Epicor provide support, that is. All I got from them was, 'it should work, but you better find yourself an SQL expert'.
I just thought it might be a cheap ETL solution to use SSIS to transfer data from UD to Oracle. Budget? As far as anything UD is concerned - zilch. They rather spend money on gadgets and Oracle consultants. Very frustrating, but what can you do? Mecki jpb-u2ug wrote: > Is 5.2 still supported? That may convince them that it is time to upgrade. I > can't seem to find an availability matrix on Rocket's site. > > Jerry Banker > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann > Sent: Wednesday, January 13, 2010 10:25 AM > To: U2 Users List > Subject: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS > > 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" <bi...@hkmetalcraft.com> >> An: "U2 Users List" <u2-users@listserver.u2ug.org> >> 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: 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 >> > > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users