Hi Sergey

Thank you for replying.

No I can connect to sql server EM, QA without any problems. I can also connect using the server name as follows:

lcConn = "DRIVER=sql server;"
lcConn = lcConn + "SERVER=servername;"
lcConn = lcConn + "Database=databasename;"
lcConn = lcConn + "Uid=kal;"
lcConn = lcConn + "Pwd=123"

The problem I have is with using the ip address:

lcConn = "DRIVER=SQL Server;"
lcConn = lcConn + "SERVER=ip address;"
lcConn = lcConn + "ADDRESS=ip address,1433;"
lcConn = lcConn + "NETWORK=DBMSSOCN;"
lcConn = lcConn + "DATABASE=databasename;"
lcConn = lcConn + "UID=kal;"
lcConn = lcConn + "PWD=123"

The second one comes up with the error dialog box, I click ok, then it shows me the sql server dialog box with the details filled in and I click ok and it connects.

Not really sure what else to try. Are there any other parameters I need to pass to sql server ?

Many Thanks

Kal