Microsoft KB Archive/184684

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

Article ID: 184684

Article Last Modified on 1/28/2005

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.