Showing posts with label ibm. Show all posts
Showing posts with label ibm. Show all posts

Sunday, March 11, 2012

Connecting to IBM DB2 USING SSIS

We need to connect to an DB2 server using ODBC provider, so we tried with the folowing:

Driver={IBM DB2 ODBC DRIVER};database=FirstDB; hostname=IP address; port=50000;protocol=TCPIP;

But when we try to connect using the above connection string we get teh following error:

"Test Connection failed because of an error in initializing provider. ERROR [IM004][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

we are not getting wat is the problem. we are able to connect to this DB2 database from the same DB2 server but we are not able to connect to the server from a remote machine.

Thanks in advance.

What source did you use?

If you set up an ODBC entry in Windows, you can use a DataReader Source to go against that ODBC entry.

|||

Do you mean Provider, we used Odbc Data Provider

When we try create an ODBC entry it is throwing the same error.

|||

Murugan S wrote:

Do you mean Provider, we used Odbc Data Provider

When we try create an ODBC entry it is throwing the same error.

Then this doesn't sound like an SSIS problem. Perhaps the driver isn't installed correctly or is corrupt. Have you tried reinstalling the DB2 client?

|||

I have been trying different connection methods for some time trying to make SSIS "play nicely" with DB2 and unfortunately have not found a solution yet.

If someone out there has had success in doing so it would be very much appreciated if you could share the methodology and specific components you used to successfully retrieve data.

We're still using DTS on 2000 to export our IBM related data to SQL.

TR

|||

What type of connection are you using in DTS?

|||

in DTS I'm simply using an "Other Connection" and specifying the DSN that is connecting using the IBM Client Access Driver.

tr

Connecting to IBM DB2 USING SSIS

We need to connect to an DB2 server using ODBC provider, so we tried with the folowing:

Driver={IBM DB2 ODBC DRIVER};database=FirstDB; hostname=IP address; port=50000;protocol=TCPIP;

But when we try to connect using the above connection string we get teh following error:

"Test Connection failed because of an error in initializing provider. ERROR [IM004][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

we are not getting wat is the problem. we are able to connect to this DB2 database from the same DB2 server but we are not able to connect to the server from a remote machine.

Thanks in advance.

What source did you use?

If you set up an ODBC entry in Windows, you can use a DataReader Source to go against that ODBC entry.

|||

Do you mean Provider, we used Odbc Data Provider

When we try create an ODBC entry it is throwing the same error.

|||

Murugan S wrote:

Do you mean Provider, we used Odbc Data Provider

When we try create an ODBC entry it is throwing the same error.

Then this doesn't sound like an SSIS problem. Perhaps the driver isn't installed correctly or is corrupt. Have you tried reinstalling the DB2 client?

|||

I have been trying different connection methods for some time trying to make SSIS "play nicely" with DB2 and unfortunately have not found a solution yet.

If someone out there has had success in doing so it would be very much appreciated if you could share the methodology and specific components you used to successfully retrieve data.

We're still using DTS on 2000 to export our IBM related data to SQL.

TR

|||

What type of connection are you using in DTS?

|||

in DTS I'm simply using an "Other Connection" and specifying the DSN that is connecting using the IBM Client Access Driver.

tr

Connecting to IBM DB2

We need to connect to an DB2 server using ODBC provider, so we tried witht he folowing:

Driver={IBM DB2 ODBC DRIVER};database=FirstDB; hostname=IP address; port=50000;protocol=TCPIP;

But when we try to connect using the above connection string we get teh following error:

"Test Connection failed because of an error in initializing provider. ERROR [IM004][Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

we are not getting wat is the problem. we are able to connect to this DB2 database from the same DB2 server but we are not able to connect to the server from a remote machine.

Thanks in advance.

Make sure you have the same driver installed on your remote machine as you have installed on the server. It may be possible that you have an out of date DB2 driver on your remote machine if nothing else is different.

Hope that helps,

John

Saturday, February 25, 2012

CONNECTING SQL 2005 TO SYSTEM DNS ODBC?

Hi

I have a server with SQL 2005 and I have second server with spesial database program on it from IBM and I have installed a spesial ODBC DRIVER from IBM so I can make a connection in system dns.

On my server 1 where I have the sql 2005 I have made a connection in system dns.

HOW CAN I TELL SQL 2005 TO CONNECT TO MY CONNECTION AND GET DATA FROM DER?

It's DSN rather than DNS.

Please check this page for connection string using DSN: http://www.connectionstrings.com/?carrier=dsn

Friday, February 24, 2012

CONNECTING SQL 2005 TO SYSTEM DNS ODBC?

Hi

I have a server with SQL 2005 and I have second server with spesial database program on it from IBM and I have installed a spesial ODBC DRIVER from IBM so I can make a connection in system dns.

On my server 1 where I have the sql 2005 I have made a connection in system dns.

HOW CAN I TELL SQL 2005 TO CONNECT TO MY CONNECTION AND GET DATA FROM DER?

It's DSN rather than DNS.

Please check this page for connection string using DSN: http://www.connectionstrings.com/?carrier=dsn