Hello all,
This is the error I'm receiving:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
It's a Win2000 Server machine running SQL server, attempting to be accessed by my asp app via a dsn. I'm not at the location of the server.
And here's what happened: This morning I needed to make a change to the database so I called someone at the location of the server and walked him through the changes (it was just changing maybe 2 values in a table). Before the changes everyone was able to access the database without problem, however after the changes everyone was receiving the above error.
I had this user go back to the server and see if SQL Server was running, it was, he was able to look at the tables through Enterprise Manager. I had him go to the 'ODBC Data Source Administrator' to test the dsn and it came back successful. So, the SQL server was running and the dsn was connecting fine. However the error persists.
Any suggestions?
Thank you,
Earme
This is the error I'm receiving:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
It's a Win2000 Server machine running SQL server, attempting to be accessed by my asp app via a dsn. I'm not at the location of the server.
And here's what happened: This morning I needed to make a change to the database so I called someone at the location of the server and walked him through the changes (it was just changing maybe 2 values in a table). Before the changes everyone was able to access the database without problem, however after the changes everyone was receiving the above error.
I had this user go back to the server and see if SQL Server was running, it was, he was able to look at the tables through Enterprise Manager. I had him go to the 'ODBC Data Source Administrator' to test the dsn and it came back successful. So, the SQL server was running and the dsn was connecting fine. However the error persists.
Any suggestions?
Thank you,
Earme