Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread SQL 2008 R2 Linked Server to DBISAM using ODBC on a 64 bit Windows 2008 Server Standard
Wed, Sep 28 2011 2:53 PMPermanent Link

TomC

Could someone help me setup a SQL linked server to a DBISAM database?

I have SQL 2000R2 installed on a Windows 2008 Server Standard 64 bit system.

I attempted unsuccessfully to setup up a SQL linked server with the following steps.

1.  I installed DBISAM ODBC version 4.21 on the Windows 2000 Server.

2.  I opened the ODBC Data Source Administrator under Administrative Tools to add a system data source but the DBISAM ODBC driver wasn't on the list.

3.  I ran odbcad32.exe located in C:\Windows\SysWoW64 which allowed me to add the DBISAM data source.

4.  Once the data source was configured, I tried to create a linked server in SQL pointing to the system data source I created in the previous step but when I accepted the configuration the system failed with "... datasource name not found and drive not specified..."

5.  I edited the registry to also have the data source show up in the Administrative Tools -> ODBC Data Source Administrator but I received the same error when setting up the linked server.

I am not sure if the DBISAM ODBC driver is not supported in the 64 bit OS or my setup is incorrect.  Any help would be greatly appreciated.
Thu, Sep 29 2011 8:29 AMPermanent Link

Raul

Team Elevate Team Elevate

TomC,

I don't think what you want to do is possible at this time  - the DBISAM ODBC is 32bit only at this time. You can install it on 64bit OS but only access it with 32bit apps (not 64bit apps like your sql server- note that this is Windows design feature and not specific to DBISAM - separation of 32 and 64bit).

Delphi XE2 is the 1st version of the 64 bit compiler so Elevate is working on updating DBISAM and EDB to XE2, including 64bit. Hopefully there will be a 64bit ODBC driver in October - you should contact Elevate support direct to get a confirmation.

Other possible options (less desirable):
- install SQL Server 32bit side-by-side on the same system as it will have access to DBISAM 32bit and then you just need to link the 2 SQL servers
- try to find and use a ODBC-to-ODBC bridge (i know there are some out there but none free AFAIK)

Raul
Fri, Sep 30 2011 6:45 AMPermanent Link

TomC

Thanks for the information. We suspected it might not be possible until a 64 bit ODBC driver is available.

We've decided to switch to a 32 bit copy of SQL 2008 for now instead of the 64 bit copy.


Tom
Image