Accessing remote MS Access DB thru IIS App

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Grant (anonymous_at_discussions.microsoft.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 08:16:08 -0800

Hi,

I have a VB 6 IIS Application running as a compiled DLL under IIS 5.0 on Win2K. It uses the ADO 2.5 library to give users OLEDB and ODBC access from a browser, to various types of databases - mostly remote from the IIS server itself.

I've run into a problem that's referenced in an MSDN article "Debugging your IIS Application" ... "Do not use an Access database on a remote computer in your project. While this will work in debug mode, it will not work when the application is compiled."

Is there any kind of workaround that would allow access to a remote MS Access database from a compiled (DLL) IIS Application?

I've tried various means of access - setting up the remote Access database as an ODBC database; using mapped drive letters; using the machine-based name (\\remotemachine\databases\mydb.mdb) - but nothing seem to work on the compiled DLL even though all of these methods work in the development environment, as well as in the VB6 "Standard EXE" version of my software.

Any help would be appreciated.

Thanks,
    Grant

Relevant Pages

  • Re: Accessing remote MS Access DB thru IIS App
    ... It uses the ADO 2.5 library to give users OLEDB and ODBC access from ... your IIS Application" ... ... "Do not use an Access database on a remote ... Access database from a compiled IIS Application? ...
    (microsoft.public.inetserver.asp.components)
  • Re: Help connecting to Access DB from web service
    ... The Access database is located on a different server than ... While developing / debugging the web service is hosted on my development ... When deployed it is being host with IIS. ... What are the differences between the 'ASP.NET Development Server' and IIS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help connecting to Access DB from web service
    ... so there is no compelling reason not to use it. ... The Access database is located on a different server than ... While developing / debugging the web service is hosted on my development ... When deployed it is being host with IIS. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: How to get an Access database on the web from my own computer
    ... located in IIS, you always see that it is started in VS2005 development ... internal developmente server to run it..... ... I'm also curious at why don't you put access database file in web ... Microsoft Online Support ...
    (microsoft.public.dotnet.framework.aspnet)
  • runtime error 3265 : Item cannot be found in the collection corresponding to the requested name or
    ... remote Access Database by ADO and ADOX. ... Dim oCat As ADOX.Catalog ... Dim oTab As ADOX.Table ...
    (microsoft.public.vb.database.ado)