This is the connection string used to connect through ASP to the remote SQL database
> Set conn = Server.CreateObject("ADODB.Connection")
> Server};SERVER=ServerName;UID=USER;PWD=password;DA TABASE=databasename"
> conn.open DSNtemp
this seems to be correct....the problem is that I keep getting one of two errors
1.)Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
or invalid connection string with the same server error
If anyone has any suggestions....it would be greatly appreciated