There's a good resource at
https://www.connectionstrings.com/>Borislav
>
>This works, thanks...I'm gonna go crawl into a corner and figure out the differences between this and what I was doing
>
>
>>
>>
>>TEXT TO lcConnection NOSHOW PRETEXT 15
>> Driver={SQL Server};Database=DataWarehouseDB;Server=204.67.nn.nnn;UID=USERID;PWD=PASSOWRD;
>>ENDTEXT
>>lnHandler = SQLSTRINGCONNECT(lcConnection)
>>IF lnHandler < 0
>> AERROR(aaa)
>> MessageBox(aaa[1,2])
>>ELSE
>> MessageBox("Connection is successful")
>>ENDIF
>>SQLDISCONNECT(0)
>>
>>Just change IP address to the real one and of course SQL user and SQL Password
>>If this didn't work try to force protocol to be TCP/IP or Named Pipes
>>Just add to connection string:
>>;Network=dbnmpntw - for Named pipes
>>Network=dbmssocn; - for TCP/IP
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up