All ODBC drivers missing in Windows 2000 
Author Message
 All ODBC drivers missing in Windows 2000

When I go to Control Panel -> Data Sources (ODBC), the ODBC Data Source
Administrator opens. User, System, and File DSN pages are all blank. When I
click 'Add', it opens the 'Create New Data Source' window, but there are no
drivers listed! This makes it impossible to create a new DSN.

I have tried all of the following to resolve this, to no avail, and am
looking for pointers:
Install MDAC 2.5 SP3, reboot
Install MDAC 2.6 SP2 Refresh, reboot
Install MDAC 2.7 RTM Refresh, reboot
Install MDAC SDK 2.6, reboot
Install Jet 4.0 SP3 (English), reboot

I would really like to have all my ODBC drivers back without having to
reinstall each piece of software, if at all possible.



Sat, 02 Jul 2005 02:19:27 GMT
 All ODBC drivers missing in Windows 2000

Hi Joey

What OS are you on? If it's XP then that will limit what we can do and you
might want to consider opening a case with us.

If you bring up Regedit, and go to HKLM\Software\ODBC\ODBCINST.INI, do you
see the drivers listed or are they blank? Are you logged in as a Local
Admin? I've seen a few cases where something had munged the registry
permissions and the drivers were actually there, you just don't have
permissions.

Bring up Regedt32 and go to the same key as above, and pull down the
security menu and go to Permissions. Do you see Administrators and System
on the list? Do they each have Full control?

Did this ever work for you? If so, did you add or remove any programs about
the time that you started seeing the problem?

I hope this helps,

Russ Gray
Microsoft Developer Support

This posting is provided AS IS with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.



Sat, 02 Jul 2005 07:35:06 GMT
 All ODBC drivers missing in Windows 2000

Russ:
Thanks for the reply...

Sorry...I'm on Windows 2000. Thought the subject would be enough, but I
should've put it into the body as well.

When I go to the regedit sub-tree you mentioned in the first paragraph,
there are no sub-items. I am logged in as Administrator.

This all worked about 6 months ago, at which point I put this project on
hold to take care of some higher priority items. I can't even imagine all
the software that may have been un/installed in that period, so I imagine
you're about to tell me I'm hosed and have to reinstall Windows...



Quote:

> Hi Joey

> What OS are you on? If it's XP then that will limit what we can do and you
> might want to consider opening a case with us.

> If you bring up Regedit, and go to HKLM\Software\ODBC\ODBCINST.INI, do you
> see the drivers listed or are they blank? Are you logged in as a Local
> Admin? I've seen a few cases where something had munged the registry
> permissions and the drivers were actually there, you just don't have
> permissions.

> Bring up Regedt32 and go to the same key as above, and pull down the
> security menu and go to Permissions. Do you see Administrators and System
> on the list? Do they each have Full control?

> Did this ever work for you? If so, did you add or remove any programs
about
> the time that you started seeing the problem?

> I hope this helps,

> Russ Gray
> Microsoft Developer Support

> This posting is provided "AS IS" with no warranties, and confers no
rights.

> Are you secure? For information about the Microsoft Strategic Technology
> Protection Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.



Sat, 02 Jul 2005 08:13:32 GMT
 All ODBC drivers missing in Windows 2000

If it simplifies anything, the most critical piece is that I get MSSQL
drivers installed.

I'm not even sure if ODBC is the problem at this point, but when I try to
start 'SQL Server Agent'
using either the 'Service Manager' or the 'Services' control panel applet,
it fails to start and logs the
following in the event viewer (some info trimmed):

Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Service Control
Event ID: 103
Description:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).

I assumed this was because the MSSQL drivers aren't fully installed, and so
I wrestled with the SQL Server installation for the better part of a day as
well, but I figured I should start with the ODBC drivers first, and then
move on. Perhaps you can tell me if I'm even headed in the correct
direction?



Quote:

> Hi Joey

> What OS are you on? If it's XP then that will limit what we can do and you
> might want to consider opening a case with us.

> If you bring up Regedit, and go to HKLM\Software\ODBC\ODBCINST.INI, do you
> see the drivers listed or are they blank? Are you logged in as a Local
> Admin? I've seen a few cases where something had munged the registry
> permissions and the drivers were actually there, you just don't have
> permissions.

> Bring up Regedt32 and go to the same key as above, and pull down the
> security menu and go to Permissions. Do you see Administrators and System
> on the list? Do they each have Full control?

> Did this ever work for you? If so, did you add or remove any programs
about
> the time that you started seeing the problem?

> I hope this helps,

> Russ Gray
> Microsoft Developer Support

> This posting is provided "AS IS" with no warranties, and confers no
rights.

> Are you secure? For information about the Microsoft Strategic Technology
> Protection Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.



Sat, 02 Jul 2005 13:58:16 GMT
 All ODBC drivers missing in Windows 2000

Ah. I've seen One other case of this. We never did find out what did it,
but we speculate that the customer may have removed some program that very
kindly wiped the drivers as part of it's uninstall process.

You may need to reinstall the OS. Before you do that though, search your
C:\winnnt\system32 directory for sqlsrv32.dll If it's there, you at least
have the driver.  Then run odbcconf /F sqlclnt.rsp. that should set up the
SQLServer driver for you, if we're lucky.

If that doesn't work, you may have to start a case with us or reinstall the
OS, whichever you prefer.

I hope this helps,

Russ Gray
Microsoft Developer Support

This posting is provided AS IS with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.



Sun, 03 Jul 2005 09:17:39 GMT
 All ODBC drivers missing in Windows 2000
Russ:
  Thank you very much. odbcconf allowed me to at least get the SQL Server
drivers working correctly again, which was the main priority. I appreciate
your help.



Quote:

> Ah. I've seen One other case of this. We never did find out what did it,
> but we speculate that the customer may have removed some program that very
> kindly wiped the drivers as part of it's uninstall process.

> You may need to reinstall the OS. Before you do that though, search your
> C:\winnnt\system32 directory for sqlsrv32.dll If it's there, you at least
> have the driver.  Then run odbcconf /F sqlclnt.rsp. that should set up the
> SQLServer driver for you, if we're lucky.

> If that doesn't work, you may have to start a case with us or reinstall
the
> OS, whichever you prefer.

> I hope this helps,

> Russ Gray
> Microsoft Developer Support

> This posting is provided "AS IS" with no warranties, and confers no
rights.

> Are you secure? For information about the Microsoft Strategic Technology
> Protection Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.



Wed, 06 Jul 2005 03:45:35 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Windows 200 in a Restart Loop, All ODBC Drivers Missing

2. The D3 ODBC drivers for Windows are missing from picksys.com ftp

3. SQL Server 2000 ODBC Driver in Windows XP

4. SQL Server 2000 ODBC Driver for Windows XP

5. Oracle ODBC driver for Windows 2000

6. Problems loading Oracle ODBC driver on Windows 2000 or XP

7. ODBC driver for windows 2000

8. Informix ODBC driver for Windows 2000

9. ODBC driver & Windows 2000

10. Windows 2000 Paradox ODBC Drivers Problem

11. Windows 2000 Server ODBC driver installation problem

12. ODBC Text Driver and Windows 2000


 
Powered by phpBB® Forum Software