Knowledge Base

XL98: Cannot use File DSN to Connect to SQL Server via AppleTalk

Article ID: 184684

Article Last Modified on 1/28/2005

Microsoft Excel 98 for Macintosh

This article was previously published under Q184684

SYMPTOMS

When you configure a SQL Server data source, you may receive the following error message:

Connection failed:
SQLState: '08001'
MS SQL Server Error:-1
[Visigenic][ODBC MS SQL Server 6 Driver]Unable to connect to data source

Your only option is to click OK. After you click OK, you must click cancel in the Data Source dialog box.

NOTE: This problem may occur if you are using either the ODBC Data Source Administrator or the Create New Data Source dialog box to configure your data source.

CAUSE

This problem occurs if all of the following conditions are true:

You are creating a File Data Source Name (DSN). -and-
You are using the Visgenic MS SQL Server 1.1 ODBC driver that is included with Microsoft Excel 98 Macintosh Edition. -and-
You specify AppleTalk for Network Library in the Data Source dialog box.

WORKAROUND

To work around this problem, create a User DSN instead of a File DSN.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

For additional information, please see the following article in the Microsoft Knowledge Base:

180271 XL98: Using File and User Data Sources in Microsoft Query

Additional query words: XL98

Keywords: kbbug kbnetwork kbpending KB184684