Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

win2000 profissional and win2000 adv. server ODBC problem

Status
Not open for further replies.

marabozu

Programmer
Jan 3, 2001
36
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top