Issue:
Need to setup a ODBC connection on new Windows 2008 server. However, SQL server is the only option. No 32bit drivers for ODBC, Text, etc. exist anymore.
Workarounds:
As of this writing ( 1/10, about 2 years after release on 2/27/08 ), the other ODBC drivers are still not available for the 64bit ODBC panel and don't seem to be coming any time soon.
You can:
1. Buy and migrate to SQL server (if you don't have one) and spend more time re-developing your existing applications for SQL back-end.
Or, since I don't necessary want to do that...
2. Other business partners who have other competing back-end systems have 64 bit versions of their drivers (e.g. Oracle, IBM DB2, SAP, and other companies who sell a generic ODBC driver).
3. Use the 32 Bit ODBC administrator panel which still exists but is COMPLETELY SEPARATE. It's located at %systemroot%\sysWOW64\odbcad32.exe.
However, ONLY 32 bit programs on server can use this 32 bit ODBC -- the 64 bit programs can only use the 64 bit ODBC.
4. Some other developers have created wrapper programs which allow you to use a 64 bit program, using the wrapper, access/use the 32 bit ODBC program. I found several when searching because of hitting this problem. They allow a 64 bit program call this program on the server as a data source and then, it in turn, asks the 32 bit ODBC for the connection.
previous page
|