How to know which client is better for ODBC Connection

[alec1982]

Hi guys, Can someone explain this to me please:

How to know which client is better for ODBC Connection. WIN 7 64 or 32..

I only know that 64 i faster than 32 and would like to get a good idea of the use of all of them and when to use which.

Thxs for all your help!

[Clever_Anjos]

You should try both and make your tests.

Performance can vary depending of manufacturer, version, etc

[alec1982]

Hi,

Thank you for the reply. When you say depends on the version and manufacturer what that mean?

Best,

Alec

[#4]

This.

Also on a developer's perspective, 64 bit would be preferred not necessarily because of "better" ODBC connection, but as a (technically) better environment generally. IMHO

[#5]

I think he simply means to test to see which one you prefer.

Also this article might help..

The Lifehacker Guide to 64-bit vs. 32-bit Operating Systems

[Anonymous]

Agreed. You should use a 64 bit environment. The biggest advantage is the higher amount of addressable memory. Also you should use OLE DB instead of ODBC if possible. OLE DB is newer, simpler and faster.

Regards.

[Clever_Anjos]

You didn´t tell us about which database you´re connection.

Maybe some 32bits version of a driver of MySQL (for example) could perform better than 64bits.

As a guideline, test using your enviroment