?
Solved

How do I upgrade Microsoft  ODBC Desktop drivers on Win2k Server

Posted on 2005-03-08
14
Medium Priority
?
1,751 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
14 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

801 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