Could you please clarify if you had to use one of the settings Borislav suggested (to make your connection work)?
;Network=dbnmpntw - for Named pipes
Network=dbmssocn; - for TCP/IP
>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
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham