?
Solved

Missing generic ODBC drivers in Vista Business

Posted on 2007-08-07
14
Medium Priority
?
4,736 Views
Last Modified: 2009-08-18
The problem we have on the Vista PC is that we need to connect to SQL Server but the generic ODBC drivers for SQL are missing? All the other generic drivers are there (Access, Paradox etc), but the SQL drivers are missing.

Any idea how we can install these if they are missing (why woul that be?) or how we can tweak Vista to get them to appear so we can use them.

Thanks,

Trevor.
0
Comment
Question by:trevorb
  • 7
  • 7
14 Comments
 
LVL 7

Expert Comment

by:lacrewga
ID: 19645036
What version of SQL are you running? Do you have latest service packs installed?
0
 

Author Comment

by:trevorb
ID: 19645285
We are trying to connect to a remote SQL 2000 server. But that wouldn't effect local ODBC drivers being present on Vista would it? The SQL ODBC driver isn't listed at all when I use the ODBC configuration program - I need to add up a new System DSN. All the other drivers are there except the SQL driver.

Vista is completely up to date with service packs.

One strange thing, using the MS MDAC checker reports the SQL driver DLLs are present.
0
 
LVL 7

Expert Comment

by:lacrewga
ID: 19646201
If you look at the last entry under the drivers tab, you should see the driver there... Is it?

From Microsoft... No desktop changes are necessary to continue to access a remote SQL Server 2000 database. Windows Vista will ship with the standard drivers that support OLE DB or ODBC access. Applications accessing a SQL Server 2000 server using OLE DB or ODBC (either directly or via ADO Classic or managed OLE DB or ODBC providers), can use the MDAC OLE DB provider or ODBC driver that ships with Vista to access a remote SQL Server 2000 database.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:trevorb
ID: 19646331
Thanks for your continued help.....

Your comments are precisely what I thought also! I have used this on XP many times before and all the generic drivers have always been there by default. But not this time for some reason.

The last driver listed on the drivers tab is a Fox Pro driver. There is entry at all for anything remotely SQL like. I can list them all if you need to see them, but there is nothing unusual about the rest as far as I can see.

This is very odd indeed and I cannot get my head around why it isn't there.
0
 
LVL 7

Expert Comment

by:lacrewga
ID: 19646389
Has your version of Vista been Validated by MS? (Some features disabled untill...)
0
 
LVL 7

Expert Comment

by:lacrewga
ID: 19646530
... The version I have in ultimate is sqlsrv32.dll 6.00.6000.16386
0
 

Author Comment

by:trevorb
ID: 19646535
Hi lacrewga,

Yes, it is a completely validated copy of Vista, everything else runs just fine.

I should have said in my original, starting comment/question that I have tried to download and install the the latest MDAC package. But that hasn't made a difference. I have tried to download it a couple of times as (oddly) when it rund it doesn't appear to do anything. On the last occasion, I downloaded it, saved it and then extracted the contents to a directory. I then tried the setup.exe directly from there and, again, it doesn't appear to do anything. From there I then installed the sqlodbc.inf, sqlodbcm.inf, sqlodb.inf and sqlodbm.inf manually. Doing this, Vista looks like it is doing something and, after completing, even asks for a a reboot which would indicate something worked-ish. But on a reboot, nothing has changed in the ODBC configurator.

Thanks,

Trevor.
0
 

Author Comment

by:trevorb
ID: 19646576
Version on the Vista here with the problem is the same.....

6.0.6000.16386, date modified: 02/11/2006 10:46, size 508kb?
0
 

Author Comment

by:trevorb
ID: 19646655
Another strange thing..... just checked the ODBC keys in the registry and there is no mention of SQL. Every other driver is listed, but no SQL?

So..... if I had the values for the SQL entries for the ODBC part of the registry.... would it work then??
0
 
LVL 7

Accepted Solution

by:
lacrewga earned 1000 total points
ID: 19646911
Did you try to re-register the dll?
0
 

Author Comment

by:trevorb
ID: 19647124
I hadn't done so. So I tried...

Regsvr32 c:\windows\system32\sqlsrv32.dll

But this actually errors? Error message along the lines of "module loaded but entry point DLLregister not found, make sure it is a valid DLL or OCX and try again"

Does this mean it could be corrupt? I guess I could try another copy. May the one that comes with the MDAC download?

Apologies if I do not reply further this evening..... I have to pick my car up from the garage now.  So will respond to any further suggestions tomorrow.

Thanks for your thoughts and suggestions so far, appreciated.

Trevor.
0
 

Author Comment

by:trevorb
ID: 19652325
Hi lacrewga,

I think I have found a solution, although I cannot explain the problem.

I was cehcking the regsitry again this morning as thoroughly as I could. Under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI all the drivers were listed that should be generically available in Vista. Included in that list was SQL Server. Under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers all the drivers were also listed as 'installed' except SQL Server which was missing. I noted that the values names were precisely the same as the key names in the parent. So, just to try, I added the value 'SQL Server' and set it to installed.

Guess what? It worked!

I have no idea if that entry should have been there and if it should, then why it wasn't. But I have created the link to the SQL server that I need and everything is now running fine.

So I thank you for your help and will award the points for helping me to focus on where the problem might have been.

Thanks!

Trevor.
0
 
LVL 7

Expert Comment

by:lacrewga
ID: 19653007
Sometimes, 2 heads are better than one. I'm glad you got this resolved.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So who is this article for? If you are like most of the computer users out there, you probably only realize the meaning of 'System maintenance' after something goes wrong. This article is for you if you care about keeping your system working opti…
I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question