Microsoft KB Archive/134723

= PRB: Datasource Name Too Long Error as Establishing Connection =

Article ID: 134723

Article Last Modified on 10/15/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Data Access Components 2.5

-



This article was previously published under Q134723



SYMPTOMS
When attempting to establish a connection to a remote data source using a connection created with the Connection Designer, Visual FoxPro fails, and displays this error message:

Connectivity error: [Microsoft][ODBC DLL]Data Source Name Too Long



CAUSE
In the Connection Designer, the Connect String was chained together using commas instead of semi-colons.



RESOLUTION
The connection string specified in the connection designer must be changed to be chained together using semi-colons.



STATUS
This behavior is by design.



MORE INFORMATION
The following connection string, if entered in the Connection Designer, fails due to the presence of commas: DSN=vfpsql,USERID=sa,PASSWORD=sa,DATABASE=pubs The correct syntax is: DSN=vfpsql;USERID=sa;PASSWORD=sa;DATABASE=pubs

Additional query words: 3.00 VFoxWin ODBC

Keywords: kbprb KB134723

-

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

© Microsoft Corporation. All rights reserved.