ACC: SQL Data Sources Dialog Box Lists No Servers

ID: Q95013


The information in this article applies to:


SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you are trying to attach, import from, or export to a Microsoft SQL Server table, the SQL Data Sources dialog box is displayed, but no data sources (SQL Server computers) are listed.


CAUSE

The following are the most likely causes:


RESOLUTION

Verify that you have a single copy of the ODBC.INI file on your computer, located in your Windows directory. Also, make sure there is an [ODBC Data Sources] section in your ODBC.INI file containing correct entries for the SQL Server computers you want to use.


MORE INFORMATION

To correct the problem, rename your ODBC.INI file and use the ODBC Administration application to complete the following tasks:

The contents of your new ODBC.INI file should resemble the following example:


   [ODBC Data Sources]
   MYSERVER=SQL Server
   YOURSRVR=SQL Server

   [MYSERVER]
   Driver=C:\WINDOWS\SYSTEM\SQLSRVR.DLL
   Description=SQL Server on server MYSERVER
   OemToAnsi=No
   Network=dbnmp3
   Address=\\MYSERVER\PIPE\SQL\QUERY

   [YOURSRVR]
   Driver=C:\WINDOWS\SYSTEM\SQLSRVR.DLL
   Description=SQL Server on server YOURSRVR
   OemToAnsi=No
   Network=dbnmp3
   Address=\\YOURSRVR\PIPE\SQL\QUERY 

Additional query words: odbc


Keywords          : kbusage OdbcOthr 
Version           : 1.0 1.1 2.0
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: March 13, 1999