Re: Accessing remote MS Access DB thru IIS App

From: Tom Kaminski [MVP] ((A_at_T))
Date: 02/19/04


Date: Thu, 19 Feb 2004 12:04:19 -0500


"Grant" <anonymous@discussions.microsoft.com> wrote in message
news:002718C3-B9EE-4E81-AC49-7B845A3FE7CF@microsoft.com...
> 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.

This might be helpful. I can't offer more because you don't explain what
"nothing seem to work" exactly means.
http://www.aspfaq.com/show.asp?id=2168

-- 
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/


Relevant Pages

  • Accessing remote MS Access DB thru IIS App
    ... Is there any kind of workaround that would allow access to a remote MS Access database from a compiled (DLL) IIS Application? ...
    (microsoft.public.inetserver.asp.components)
  • Re: companyweb and remote web workplace
    ... Regarding to the Remote folder, there is no missing files or folders under ... Please enable IIS logging and help to collect the logs for analyze: ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Fao Ken Kolda
    ... This is the remote obj that is in an empty web project ... enable custom error messages, "Off" to disable. ... access must be disabled in IIS. ... which requests belong to a particular session. ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: Fragile
    ... Steven Cheng ... Microsoft Online Support ... we can control a remote IIS server on local machine through the ... | remote IIS server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How configure an IIS folder from remote to run web service or
    ... If you use installers for installing the webservice, then, a virtual folder ... configure the IIS Manually. ... remote, provided that this setting is written on some file accessible ...
    (microsoft.public.dotnet.framework.webservices)