Thanks for clarifying.
>No, I didn't
>
>>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
