The answer to question
"How to read a .dbf file on 64 bit sql server?" states:
"The basic issue is that 64 bit processes cannot load 32 bit dlls. Many drivers only release in 32 bit mode. I am not sure if there is an intent to add 64 bit drivers in the future. There
is a way to work around this issue, but it is sort of roundabout. You can install SQL Express in 32 bit mode and double hop to the dbf file (or any other 32 bit only provider) through 64 bit SQLNCLI. The 32 bit express instance can OPENROWSET using
all the 32 bit drivers, and the 64 bit SQLNCLI provider can connect to the 32 bit express instance"
Is it valid also for non-Express Editions of MS SQL Server?
Can the same edition of MS SQL Server be installed both in 32-bit mode and in 64-bit mode
- for the same services of different instances?
- for different services of the same server setup?
View Complete Post