Knowledge Base

PRB: Datasource Name Too Long Error as Establishing Connection

Article ID: 134723

Article Last Modified on 10/15/2003

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