Db2 driver for 64 bit

Hi everyone,

Running both Sql25k and cluster to 64.

Is there a DB2 provider for 64 bit? If not, are there problems if you take 32 bit provider there?

Thanks a lot for your time,

Hi Enric,

If you take 32 bit provider, you will have to run package using 32 bit DTExec otherwise, it will not find the connection on the 64 bit provider...

Hope that helps

|||Thanks for that.|||

It is possible to run package with Db2 driver for 32 bit with the agent using 64 bit Dtexec

I used Microsoft OLE DB pour DB2 driver, when you create the connection in the manager, I have used the .net Providers for OleDb\Microsoft OLE DB Providers for DB2. I have created an udb file using the data access tool of the driver. In All tab, in Named ConnectionString, I defined the path of the udb file. So, Integration Service doesn't use the ODBC but the informations of the udb file.

The advantage = you can run your package with the agent and the 64 bit Dtexec of SSIS

The inconvenient = you have an UDB file with all the information of you DB2 database (login password etc...). You can define access rights on this file, in order to only the agent account can read it.

|||

The Microsoft OLE DB Provider for DB2 is a COM component for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2005 Enterprise Edition and Developer Edition. SQL Server developers and administrators can use the provider with SQL Server Integration Services, SQL Server Analysis Services, Replication, and Distributed Query Processor. Run the self-extracting download package to create an installation folder. The single setup program will install the provider and tools on both x86 and x64 computers. Read the installation guide and Readme for more information.

^This found here: http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

sql