Forum Discussion
comnot
Feb 03, 2022Copper Contributor
ODBC Data Source ARM64 version could not create System DSNs
Hi, when I was trying to install PostgreSQL ODBC driver x64 version, I got a warning saying the driver could not be loaded due to system error code 193. My winver is Win11 Version 21H2 (OS Bu...
comnot
Feb 03, 2022Copper Contributor
I have successfully copied x64 version to C:\Windows\system32 and it runs showing architecture X64. BUT, the postSQL ODBC x64 installer still fails.
I even tried to copy x86 vertion, it also failed but with different error code.
To summarise:
1. arm64 version: psqlodbc Setup show ODBC error 13: The setup routines for the PostgreSQL ANSI(x64) ODBC driver could not be loaded due to system error code 193. Verify that the file PostgreSQL ANSI(x64) exists and that you can access it.
2. x64 version or x86 version: ODBC error 0: verify that the file PostgreSQL ANSI(x64) exits and that you can access it.
The files that I replaced under C:\Windows\System32 folder are
* odbc32.dll
* odbcad32.exe
* odbcbcp.dll
* odbcconf.dll
* odbcconf.exe
* odbcconf.rsp
*** odbccp32.dll
* odbccr32.dll
* odbccu32.dll
* odbcint.dll
* odbctrac.dll
*** odbccp32.dll is the one that will give different error message when installing psqlodbc-setup (version 13.02.0000) if it alone was replaced. The problem could be narrowed down to this.
I even tried to copy x86 vertion, it also failed but with different error code.
To summarise:
1. arm64 version: psqlodbc Setup show ODBC error 13: The setup routines for the PostgreSQL ANSI(x64) ODBC driver could not be loaded due to system error code 193. Verify that the file PostgreSQL ANSI(x64) exists and that you can access it.
2. x64 version or x86 version: ODBC error 0: verify that the file PostgreSQL ANSI(x64) exits and that you can access it.
The files that I replaced under C:\Windows\System32 folder are
* odbc32.dll
* odbcad32.exe
* odbcbcp.dll
* odbcconf.dll
* odbcconf.exe
* odbcconf.rsp
*** odbccp32.dll
* odbccr32.dll
* odbccu32.dll
* odbcint.dll
* odbctrac.dll
*** odbccp32.dll is the one that will give different error message when installing psqlodbc-setup (version 13.02.0000) if it alone was replaced. The problem could be narrowed down to this.
- leandrovalencioJul 04, 2022Copper Contributor
Hi comnot have you manage to solve this problem? I have the same issue on same environment. Thanks.