ODBC driver question. 10.2B or 10.1C -- is there a differen

Posted by Admin on 26-Apr-2010 14:50

Hello,

We're using Corvu via terminal server to OE 10.1C04 database.  The ODBC driver from 10.2B is 64-bit, however it will only work with Windows Server 2008.  I have a sever using Windows 2003 Server and wanted to know if it would be better in some way to upgrade the Terminal server so I can use the 64-bit driver?

OR just use the 10.1C 32-bit driver.    I am looking for the best possible performance.

Thank you,

Joe G.

All Replies

Posted by jquerijero on 27-Apr-2010 13:37

Are you using an AppServer?

Posted by gus on 28-Apr-2010 08:40

Whether you should use a 32-bit ODBC driver or a 64-bit ODBC driver depends on the type of application you have that is going to use the driver and what type of system you are going to run it on.

The 32-bit ODBC driver is built to be a 32-bit library that contains instructions for a 32-bit operating system and a 32-bit processor.

The 64-bit ODBC driver is built to be a 64-bit library that contains instructions for a 64-bit processor.

If the application is a 32-bit executable, then you must use the 32-bit driver. This is because a 32-bit executable cannot load or use 64-bit libraries.

If the application is a 64-bit executable then you must use the 64-bit driver.

32-bit executables can be run on 32-bit Windows OR on 64-bit Windows.

64-bit executables can be run on 64-bit Windows on 64-bit processors, but NOT on 32-bit Windows.

There should not be any significant performance differences between the 32-bit and 64-bit ODBC drivers. But I have not done any comparison tests.

Lastly, ODBC is a client-side API. The driver running on a client machine communicates with a database server over a network connection. The database can be running on a 32-bit system or a 64-bit system -- independent of whether the client side is running on a 32-bit system or a 64-bit system.

HTH

Posted by jgenovese@gencotech.net on 05-May-2010 15:27

No app server this is gong to be SQL clients via terminal server on local network.

This thread is closed