Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 After Sql Server 2000, Ordinal 31 odbc32.dll error

Author  Topic 

mrock
Starting Member

23 Posts

Posted - 2003-07-14 : 08:03:54
On a fresh Windows 2000 server, I installed Sql Server 2000 (standard edition). On reboot I got an "Ordinal 31 could not be located in dynamic link library odbc32.dll" error. Just trying to access the service manager invokes the same error, and it will not come up.
Suspecting that maybe the service pack would upgrade ODBC, I installed sp3a. That did not help. I downloaded MDAC 2.7 SP1 refresh and tried installing it. Still have the problem. My pc is at Windows 5.0 sp4. I have sent to ask SQLTeam, but have no response. Please send responses to mrock@kanawha.com.
Thanks

X002548
Not Just a Number

15586 Posts

Posted - 2003-07-14 : 12:43:06
I did a google on your error message and found:

http://nsupport.elronsoftware.com/support/imweb.nsf/1b4af9b5c0b55d9285256627005d535d/f43054fbe2b963e78525677c005e2588?OpenDocument

Not much else though...

did you try ms?



Brett

8-)
Go to Top of Page

mrock
Starting Member

23 Posts

Posted - 2003-07-14 : 13:14:12
Yes, I did check Google, and saw the 301, and did followup with the MDAC reinstall, but no help. I did not find anything at Microsoft on this. I just removed Sql Server 2000, rebooted, and did not receive the message. Reinstalled MDAC 2.7 SR1 REFESH, not problem on boot. Reinstalled Sql Server 2000, rebooted, and again the problem.

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-14 : 13:18:04
What is MDAC 2.7 REFRESH?

If reinstalling MDAC does not work, then you might have to rebuild the machine. Have you tried just replacing odbc32.dll? I've never done it with that file, but for other files it has worked.

Tara
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2003-07-14 : 13:18:14
What's the server o/s? Are you installing it on a server or a client?



Brett

8-)
Go to Top of Page

mrock
Starting Member

23 Posts

Posted - 2003-07-15 : 11:10:55
Windows 2000 server.

Go to Top of Page
   

- Advertisement -