still having problem with connection of sql server

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

re: still having problem with connection of sql server

What errors do you get? What language is this?

re: still having problem with connection of sql server

The language that im using is asp.The error is as below :

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.

/prodview.asp, line 7

Thanks

re: still having problem with connection of sql server

I have moved your post to the ASP forum because I feel that your issue is tide more closely to a problem with ASP rather than SQL Server.