Hi,
I have IIS5 running on win2000 professional and a ASP page that connects to a MS Access database. The connection code is:
Set imdb = Server.CreateObject ("ADODB.Connection"
imdb.Open "imdbConn"
and I use ODBC to create a DNS named imdbConn. The ASP page works well in win2000 pro. However, if I copy the ASP files and the databse to win2000 Adv. server and, create a DNS with the same name, I can not have access to the database and it gives me the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
then I make a new connection usind ODBC and it gives the next error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Does anyone knows what seams to be the problem?
thanks
M. Neto
I have IIS5 running on win2000 professional and a ASP page that connects to a MS Access database. The connection code is:
Set imdb = Server.CreateObject ("ADODB.Connection"
imdb.Open "imdbConn"
and I use ODBC to create a DNS named imdbConn. The ASP page works well in win2000 pro. However, if I copy the ASP files and the databse to win2000 Adv. server and, create a DNS with the same name, I can not have access to the database and it gives me the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
then I make a new connection usind ODBC and it gives the next error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Does anyone knows what seams to be the problem?
thanks
M. Neto