Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How do I upgrade Microsoft  ODBC Desktop drivers on Win2k Server

Posted on 2005-03-08
14
Medium Priority
?
1,804 Views
Last Modified: 2010-08-05
I recently converted an Access 2k database to Access 2k3.  After the conversion, my DSN that pointed to the newly converted database started giving an error message 'Disk or network error'.  The only change was that the database had been converted.  After looking at several client machines, I noticed that the driver file 'ODBCJT32.dll' was older on the server that had the issue.  According to Microsoft Support, I should be able to go to Windows Update and select driver updates, but I can't find the detail necessary to do this.

Any help would be much appreciated.

Thanks,
DB
0
Comment
Question by:LCH-IT
  • 6
  • 5
11 Comments
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 13487229
0
 

Author Comment

by:LCH-IT
ID: 13487264
This is a quote from the link above. "This release does not include Microsoft Jet, the Microsoft Jet OLE DB Provider or ODBC driver, the Desktop Database ODBC Drivers, or the Visual FoxPro ODBC Driver."

This doesn't do it, but thanks for your input.

0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 13487294
Jet SP8 should contain the desktop ODBC drivers:
http://support.microsoft.com/kb/239114
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:LCH-IT
ID: 13487370
If you notice in the link, the file 'ODBCJT32.dll' doesn't get updated with the Microsoft JET 4.0 installation.  This is the file that I would like to update.  You can see this in the file list.  Microsoft goes on to say that the update can be found in the ODBC Desktop Driver Pack, but I can't find this Pack.  Any help here?
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 13487392
What OS are you running?
0
 

Author Comment

by:LCH-IT
ID: 13487421
Windows 2000 server
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 13487493
It seems that an updated (or downgraded) version of the drivers were installed with A2K3. Have you updated it to SP1?
0
 

Author Comment

by:LCH-IT
ID: 13488135
It appears that I've been chasing a ghost.  This issue appears to have been caused by the fact that the connection to the database didn't get refreshed after the database conversion.  I appreciate your help and apologize for any confusion I may have caused.  I would like to upgrade the ODBC Desktop Drivers on the server to the latest and greatest version though.  Do you have any suggestions on this question?
0
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 2000 total points
ID: 13488173
AFAIK, with Office 2K2 and later, the drivers are included as part of the service packs and/or the Windows installation (they certainly are included as part of Win2K3 and XP SP2). Upgrading to the latest Office and OS service packs should do the trick, but there may also be some post-service pack hotfixes that update them as well.
0
 

Author Comment

by:LCH-IT
ID: 13488488
I didn't want to install Office2k3 on the server, but maybe I can use the installation to install the drivers.  I'll let you know if I'm successful.  

BTW, what does AFAIK stand for?
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 13489595
AFAIK = As Far As I Know :)
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

564 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