Professional Web Applications Themes

Accessing remote MS Access DB thru IIS App - ASP Components

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 ...

  1. #1

    Default Accessing remote MS Access DB thru IIS App

    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
    Grant Guest

  2. #2

    Default Re: Accessing remote MS Access DB thru IIS App

    "Grant" <anonymousdiscussions.microsoft.com> wrote in message
    news:002718C3-B9EE-4E81-AC49-7B845A3FE7CFmicrosoft.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.
    [url]http://www.aspfaq.com/show.asp?id=2168[/url]

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



    Tom Kaminski [MVP] Guest

Similar Threads

  1. accessing remote xml problem
    By darkvinc in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: May 6th, 06:13 AM
  2. Replies: 31
    Last Post: June 25th, 11:29 PM
  3. Problem in accessing remote DB
    By Jaydeep in forum ASP
    Replies: 4
    Last Post: August 23rd, 10:51 AM
  4. Problem accessing remote DB
    By Jaydeep in forum ASP Components
    Replies: 0
    Last Post: August 22nd, 12:01 PM
  5. Setting up my XP pro to do remote accessing
    By Ankit Shah in forum Windows Networking
    Replies: 3
    Last Post: July 19th, 04:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139