Thanks for your help.

The ODBC source must be declared with C:\WINDOWS\SysWow64\odbcad32.exe and use 32 bits mode.



2014-11-20 9:56 GMT+01:00 S Krish <krishnamachari.sudhakar@gmail.com>:

Plausible Pharo 32 bit / 64 bit conflict..?

http://msdn.microsoft.com/en-us/library/ms712362%28v=vs.85%29.aspx

"If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver, for example, Driver do Microsoft Access (*.mdb), you will receive the following error message:"

On Thu, Nov 20, 2014 at 1:35 PM, olivier auverlot <olivier.auverlot@gmail.com> wrote:
Hi,

I try to use the ODBC framework presents in the configurations list and named "ODBC (TorstenBergmann.5)"

I want connect Pharo to a Postgresql server and I installed the latest version of the ODBC driver. The datasource is configured as system datasource. The connection test is ok. My computer uses Windows 7 64 bits.

In Pharo, I try to connect with the following code:

connection := ODBCConnection dsn: 'mysource' user: 'myuser' password: 'mypassword'.
connection close.

The connection fails and I get an error message: "The data source (DSN) has a specified architecture incompatibility between the driver and the application".

Someone have an idea about this problem ? Someone works with the ODBC solution ?

Best regards
Olivier��