The server is IEX and the driver is Simba. What I want to do is setup a linked server on my 64bit box to connect to their 32bit server. The thing is that if I set this up in a SSIS package and run the package in 32 bit mode it works (not using a linked server, but just connecting through odbc). I do not have the 64bit drivers for the server I am trying to connect to and have been told that they will not be developed. Been swamped here and haven't had time to even check the daily email from SQLServerCentral in a while.Īnyway, my problem is that I am trying to setup a linked server using a 32bit ODBC connection. Run64BitRuntime to true which select the 64 bit version of driver at run time due to both 32 bit and 64 bit version have the same id.Hey guys, long time no post. So in brief you have to select the 32 bit driver at run time and set the

Information about properties you can set on Integration Services projects, see Integration Services Considerations on 64-bit Computers and Integration Services in Business Intelligence Development Studio. If the Run64BitRuntime property is set to true, the runtime finds and uses the 64-bit provider if Run64BitRuntime is false, the runtime finds and uses the 32-bit provider. Run64BitRuntime property of the Integration Services project. To specify whether the Integration Services runtime uses an available 64-bit version of the provider, you set the

The 64-bit version of the provider can be run even if the package is run in Business Intelligence Development Studio.īoth versions of the provider have the same ID.

However, some commonly used objects in SSIS don't have 64-bit counterparts, and will therefore cause your packages to fail.Īt run time, the correct version is used, and it does not matter that you specified the 32-bit version of the provider at design time. Of 32-bit or 64-bit operation - but the default on a 64-bit installation is to use 64-bit mode (obviously). When you're designing your package, you're using 32-bit facilities - and have no choice in the BIDS, matter When you execute your package using DTExec, you have the option Business Intelligence Design Studio (BIDS) is a 32-bit application.

64 bit odbc driver for sql server