Try changing the windows search path to put the directory containing the psqlodbc drivers at the front to confirm if this is the case. This could happen if you had installed some other package containing one of the DLLs that psqlodbc relies on, or maybe even another version of psqlodbc. In fact I found this thread where someone else was having the same issue (although back in 2005). The most likely cause for this would be that the system is loading a wrong version of a DLL on which psqlodbc depends. For whatever reason, other versions kept throwing error.Īpparently, according to the Microsoft index of error codes, error 182 means ERROR_INVALID_ORDINAL, which with the help of this answer I believe means that the postgresql ODBC driver is loading another DLL and trying to call a function within it that does not exist. Uninstalled standalone psqlodbc installs, and installed Stackbuilder from postgresql package to download and install psqlodbc component.Īll of these have not not been any useful.įinal Update: I was able to fix this by using psqlodbc_09_03_0400. Added psqlodbc path to PATH env variable at the startģ. Installed older postgres & psdqlodbc versionĢ.
#Postgresql odbc driver windows 7 64 how to
any ideas on how to fix this will be helpful.?!ġ. Postgres + odbc + other installs were complete and without any errors. I then installed Visual C++ redistributable packager versions 20 later. UNICODE} Server=127.0.0.1 Port=5432 Database=postgres Specified driver could not be loaded due to system error 182: Test connection failed because of an error in initialized provider. When I add the odbc connection string and test connectivity with postgres login, it fails with the following error: I installed latest postgresql 9.6 & psqlodbc 0905, and there were no errors.
I am trying to set up a new postgres odbc connection for an application.
0 kommentar(er)
