ODBC error , important

Anon

May i know can i reinstall ODCB ?
becos when i create DSN for my database,
it show me error like this

\"
The setup rountine for Microsoft Access
driver ODBC driver could not be
loaded due to system error 1157.\"

then

\"
cound not load the setup or translator
library\"

this error is shown for other default
drive also for ex : foxpro , dbase, excel.

May i know the solution ??? thanks

Anon

Hi Mike,

I am getting the same odbc error like you have here and I'm wondering if yours ever got resolved. If yes, can you please tell me how?

Thanks. /Ike

Anon

I had solve this problem.

You copy the odbc file from other
pc and replace your existing odbc file.

Anon

I was searching for an answer to the same problem you've had (the 1157 error while trying to create a DSN) and read your message here, but I couldn't understand..
Which file I have to copy from other PC? You said it's the odbc file, but there are lots of files related to odbc. Could you please tell me the name (or the names) of the file (or files) I have to copy from other PC?
Please, reply to my e-mail: ricsilva@osite.com.br
Thanks!

Anon

I have been having the same problem with an install of a program. Did you ever find out which file to copy? Please let me know.

Susan

Anon

Susan, just copy all the odbc files(whatever
file with word "odbc" from another pc
and replace ur existing one. Besure u
make a copy of your existing odbc files,
once error in replacment , u still can roll
back to previous mode.

If i'm not mistaken, those file is located
in Window folder.

Hope this help.

Anon

Hi Everyone,

Try this solution. Hope it helps

Any wrong value in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI under the Setup key will cause this error.

Start Registry Editor (Regedt32.exe).

Locate the following key in the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI

Installation information for ODBC drivers is stored in this key. Make sure that all the required ODBC driver files are in the correct folder as described by the registry keys. For example, assume that you have the following information in your registry for the Microsoft Access ODBC driver:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb)

Driver = C:\WINNT\System\Odbcjt32.dll

Setup = C:\WINNT\System\Odbcjt32.dll

This will cause an error if the Odbcjt32.dll file is in the C:\WINNT\System32 folder. You can modify the registry key values to C:\WINNT\System32\odbcjt32.dll to solve this problem. Also verify that the Odbcinst.ini file has the correct entries in the same way.

Anon

I have the same problem. I have tried all the proposed solution. but my computer still received the same error message.

Anon

1157 appears to be the "catch-all" error for ODBC. In other words, if it comes across any unexpected error, it throws this bogus 1157 error.

I found in my situation that my ODBC driver was unable to find some underlying DLLs, because they were not in my PATH. Adding that directory to my PATH solved the problem. In my case, the Sybase ODBC drivers also rely on Sybase' DB-Lib or CT-Lib in order to operate. Not having these available in the PATH gave me the 1157.
--Brian

Anon

In my case the error occurred after loading Oracle Client and DB2 client software to my machine. Both software packages make a change to the path. I went to another employees PC and copied the path from their autoexec.bat file. I got rid of anything from the path that didn't apply to my PC. I also made sure the rest of the autoexec.bat file was in order using the other file as reference. Once again I did the job of our desktop services.