>Using a DSN Less connection how can I connect to the SQL SERVER 7.0 database using TCP/IP. I'm writing the program using Microsoft Visual Foxpro 6.0.
>
>This is how I'm connectiong now:
>glnHandle = SQLSTRINGCONNECT("driver={SQL Server};server="+THIS.SERVERNAME+";uid="+alltrim(THIS.USERNAME)+";pwd="+alltrim(THIS.USERPASS)+";database="+THIS.DATABASE+";AutoTranslate=no;Regional=no;QuotedId=no;AnsiNPW=no")
You can tell ODBC to use TCP/IP Net-Library by adding
"Network=dbmssocn;"
to the connection string.
--sb--