hi,
im still having problem with sql server connection. my server is not at the same place, it's at other country. the command that i have used is as below :
<%
Set demoConn = Server.CreateObject("ADODB.Connection")
demoPath="DRIVER={SQLServer};" & _
"SERVER=ip address of server;UID=username;" & _
"PWD=password;DATABASE=database"
demoConn.open demoPath
%>
is it the coding correct and is there any setup i have to be done from my end, to make the connection successful.
thanks