General information
Title:
TCP connection shows sql login screen
I am trying to connect to sql server using the following :-
lcConn = "DRIVER=SQL Server;"
lcConn = lcConn + "SERVER=123.456.7.9;"
lcConn = lcConn + "ADDRESS=123.456.7.9,1433;"
lcConn = lcConn + "NETWORK=DBMSSOCN;"
lcConn = lcConn + "DATABASE=fred;"
lcConn = lcConn + "UID=me;"
lcConn = lcConn + "PWD=123"
lnConnnection = sqlstringconnect(lcConn)
However I get the Sql Server Error 10061 "Sql Server does not exist or access denied". It then prompts me the sql server login screen (all the details are filled in) - all I do is click OK and it works fine.
Any ideas as to what I need to do so that the login screen doesn't appear ?
Many Thanks
Kal
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only