I am working on an ancient system that still uses ASP and Access as their respective platforms for web and data. We operate across three different servers. Thing is, my web page is located on Server A and the database is located on Server C. I have created a DSN on Server C for the database, but am having trouble configuring the connection string to look for the DSN on that server. I keep getting the following error because it's looking for the DSN on Server A where it is not:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/ccl/stuorgs.asp, line 228
I'm sure that I'm just not configuring something properly. I'm used to having the database on the same server on which I am working. Help!
set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DATABASE=ccl; SERVER=xxx.xxx.xxx.xxx; DSN=ccl;UID=xxxx;Password=xxxx;"
set rs = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT ID, Name FROM table ORDER BY ID;"
rs.Open SQL, Conn