By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

How do I make one of my installed ODBC drivers the DEFAULT driver?

P: n/a
MLH
I'm running XP. Is it required that a given ODBC driver be
selected or set somehow as a default driver? Look at this...

Here's the error: Error: ODBC call failed... [MicroSoft] [ODBC DLL]
Datasource not found and no default ODBC driver specified.

I think I can work my way around the Datasource, but the
default driver thing (#0) - dunno?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
MLH
Could it be that my c:\windows\odbc.ini needs a setting modified
in order that one of the installed ODBC drivers be selected as a
default driver? My problem is not with Access 97. That works. My
problem is connecting with Access 2.0. Here's my INI file...

[ODBC Data Sources]
MS Access 2.0 Databases=Access 2.0 for MS Office (*.mdb)
[MS Access 2.0 Databases]
Driver=C:\WINDOWS\SYSTEM\ODBCJT16.DLL
DefaultDir=C:\ACCESS
JetIniPath=MSACC20.INI
UID=Admin
[ODBC 32 bit Data Sources]
MS Access 97 Database=Microsoft Access Driver (*.mdb) (32 bit)
dBASE Files=Microsoft dBase Driver (*.dbf) (32 bit)
Excel Files=Microsoft Excel Driver (*.xls) (32 bit)
FoxPro Files=Microsoft FoxPro Driver (*.dbf) (32 bit)
Text Files=Microsoft Text Driver (*.txt; *.csv) (32 bit)
JADA=MySQL ODBC 3.51 Driver (32 bit)
[MS Access 97 Database]
Driver32=C:\WINDOWS\System32\odbcjt32.dll
[dBASE Files]
Driver32=C:\WINDOWS\System32\odbcjt32.dll
[Excel Files]
Driver32=C:\WINDOWS\System32\odbcjt32.dll
[FoxPro Files]
Driver32=C:\WINDOWS\System32\odbcjt32.dll
[Text Files]
Driver32=C:\WINDOWS\System32\odbcjt32.dll
[JADA]
Driver32=C:\WINDOWS\System32\myodbc3.dll
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.