>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!

Xiaoming:

You can create a DSN using the Microsoft DSN Wizard (from Control Panel) then copy the generated string to the clipboard to use in your program, like this:

nHandle = SQLConnect("{your DSN here}")
cConnection = SQLGetProp(nHandle,"ConnectString")
_cliptext=cConnection

See detailed instructions (and more) at:
http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect