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