still having problem with connection of sql server

[sheena81]

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.CreateOb ject("ADODB.Con nection")
demoPath="DRIVE R={SQLServer};" & _
"SERVER=ip address of server;UID=user name;" & _
"PWD=password;D ATABASE=databas e"
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

[Motoma]

What errors do you get? What language is this?

[sheena81]

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

[Motoma]

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.