Reading DB2 database in SSIS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Reading DB2 database in SSIS

Author

Topic

LordViper
Starting Member

4 Posts

Posted - 2011-09-06 : 09:49:20

Hi,
I am trying to setup an ODBC connection to a DB2 file using
Visual Studio 2005. I have 2 environments running different versions
of DB2. I have managed to connect successfully to DB2 version 8.
When trying to connect to DB2 version 10, I get the following error:

Test connection failed because of an error in initializing provider. SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "connect

If you have any ideas on how to get this connection to work,
it will be highly appreciated.

Thanks and regards,
LV

mfemenel
Professor Frink

1421 Posts

Posted - 2011-09-06 : 15:21:40

What version of the DB2 driver are you using. You might need the more recent version to connect to 10.

Mike
"oh, that monkey is going to pay"

LordViper
Starting Member

4 Posts

Posted - 2011-09-07 : 09:21:53

I am currently using the IBM DB2 ODBC Driver, version 7...

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-09-07 : 09:43:00

You might want to try the Microsoft OLEDB provider: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24793

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-07 : 21:31:47

What platform is DB2 running on?

LordViper
Starting Member

4 Posts

Posted - 2011-09-08 : 03:43:15

Hi,

DB2 is running on our mainframe, z/OS 1.11.

Regards,
LV

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-08 : 07:16:26

might also look at this

LordViper
Starting Member

4 Posts

Posted - 2011-09-08 : 08:34:04

Hi guys,

I am trying to update the IBM DB2 ODBC Driver from Version 7 to Version 9.

How do you go about doing this, as it needs to be installed manually.

I've tried following the intructions on IBM's site, but the driver just does not appear in my ODBC Data Source Administrator Driver's list.

Regards,
LV

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources