>Dear VFP expert:
> Currently i want to use SQLSTRINGCONNECT() to make a connection to SQL server 2000, what connection string i can use? May you give a sample connection string which i can refer to. Thanks!

lcDb = "pubs"
lcConnStr = "DRIVER=SQL Server;" + ;
			"SERVER=Sql1;" + ;
			"Network=DBMSSOCN;" + ;
			"DATABASE=" + lcDb 
lnConn = SqlStringConnect(lcConnStr)
IF lnConn < 0
	? _ProcessOdbcError()
	RETURN .F.
ENDIF

To get connection string, use ODBC Manager to create FILE DSN with options you want, open it in any text editor and copy it's contents into connection string.