LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: martinh1976

Hi - am using an acquisition node - DB Query - to connect to a local postgreSQL database but am receiving an error related to the ODBC driver.

The specified DSN contains an architecture mismatch between the Driver and Application

I know this has something to do with the 64bit version of the driver i am using but am not sure how to get around it - has anyone else come across this issue?

Thanks

Martin

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

I would first try the 32 bit driver.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Ivan

What version of LAE you using?
the database you connecting too is a postgreSQL 32 or 64bits?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: martinh1976

Originally posted by: Ivan
					

What version of LAE you using?

the database you connecting too is a postgreSQL 32 or 64bits?
			

Its the 64bit version

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Ivan

the problem could be (if you already checked to have the correct drivers) that you using the incorrect ODBC driver creator

A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):

The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.