I am trying to use XESame to convert the data in the database. Here is my configuration.
1) Windows 7 64-bit
2) Database Server is PostgreSQL 8.4
I open the Odbcad32.exe in the %systemdrive%\Windows\SysWoW64 folder;
I created a DSN name ReviewDB. When I click Test button in the ODBC setup window, the connection was succesful.
When I go back to XESame to create new connection.
I enter following information
URL = jdbc:odbc:ReviewDB
JDBC Driver = sun.jdbc.odbc.JdbcOdbcDriver
JDBC Driver Location = Blank (Do I need to specify driver here?)
When I click Test Connection I got this error
Sorry, but the test failed because the URL could not be found:
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.
I suspect that the PROM I have is running on 32-bit because it's installed in Program Files (x86) folder.
Do you have any suggestion on how to fix this problem?
Post edited by deenseth on