You don't need to install Access on the server - You just need to make sure

you have the same data access components installed. www.microsoft.com/data/



That said, if you are using a DSN, make sure that you have recreated the DSN

on the server. If you are using a DSN-less connection string (ODBC, or

OLEDB), then you need to make sure that the path to the database is still

correct in your connection string.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "William Boyd" <WBOYD@a...>

Subject: [asp_web_howto] asp access question





Need to know if you need to have Access installed on a

server if you're using asp to query an access db?  I'm

using an ODBC connection string in an active x dll.

It worked fine on my test system that has access installed

but when i moved it to my production server i get



Microsoft OLE DB Provider for ODBC Drivers error '80004005'



[Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find file '(unknown)'.



Any ideas.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I've also noticed that all you need to do is copy the Access database driver

to the windows system directory.



The filename is: odbcjt32.dll



You will be able to find it on any system running Access.



Roger





Subject: Re: asp access question

From: "Ken Schaefer" <ken@a...>

Date: Wed, 5 Dec 2001 16:11:04 +1100

X-Message-Number: 2



You don't need to install Access on the server - You just need to make sure

you have the same data access components installed. www.microsoft.com/data/



That said, if you are using a DSN, make sure that you have recreated the DSN

on the server. If you are using a DSN-less connection string (ODBC, or

OLEDB), then you need to make sure that the path to the database is still

correct in your connection string.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "William Boyd" <WBOYD@a...>

Subject: [asp_web_howto] asp access question





Need to know if you need to have Access installed on a

server if you're using asp to query an access db?  I'm

using an ODBC connection string in an active x dll.

It worked fine on my test system that has access installed

but when i moved it to my production server i get



Microsoft OLE DB Provider for ODBC Drivers error '80004005'



[Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find file '(unknown)'.



Any ideas.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~