Hi,
I wonder if you could be so kind to give me some help/advice
I am trying to connect to a database that is on a diffrent server than my iis server but on the same network.
My database connection string is as follows:
<%
strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\\scotland\rxdata\WAIT.MDB;UID=;PWD="
%>
In the above case my server I am connecting to is named as Scotland.
All users have full control on the directory and file on Scotland.
The error I recive when testing the connection is as follows:
Error Number -2147467259
Error discription [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xde8 Thread 0xf64 DBC 0x126ec94 Jet'.
URL /waiting_list.asp
The database can be seen and connected to when you make the asp pages with asprunner but the error only shows up when you run the finished application.
When you change the database path to a local database on the same server it works fine.
Any helps would be much appreciated.
Thank you
Bob
