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
Previous
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