Hi!
No big difference, jus put into THIS.SERVERNAME IP address or URL server name. I don;t know, however: if you need to configure something additional for SQL Server to accept TCP/IP connection; which version of ODBC works with such syntax; or what else required to configure. I have default config for most software.
>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")
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.