PRB: Datasource Name Too Long Error as Establishing Connection (134723)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0
  • 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
Modification Type:MajorLast Reviewed:10/15/2003
Keywords:kbprb KB134723
©2003 Microsoft Corporation. All rights reserved.