Re: Access Database through ODBC Connection Across DMZ/Domains

From: Frank Hickman (fhickman_nosp_at_m_noblesoft.com)
Date: 03/24/04

  • Next message: Nancy Shen: "Re: ODBC Test" 
    Date: Wed, 24 Mar 2004 10:05:57 -0500

    Access databases are file based. The only way to share an Access database
    between users is to put it in a shared folder where the users that need it
    can get to it with read/write permissions.

    HTH 

    -- 
============
Frank Hickman
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.
"Aaron" <anonymous@discussions.microsoft.com> wrote in message
news:A9A29B3F-2592-4010-9335-D73EB27F47DE@microsoft.com...
> I already posted here on this topic once before, but received no reply.  I
guess I will try simplifying the question in case there's someone with an
answer out there:
>
> Is it possible to establish an ODBC connection across a DMZ/domains to an
Access database (both on Win 2003 servers)? I see in SQL Server, you need to
open appropriate ports, but I have not fund anything on Access databases.
>
> The original question is below:
> ------------------------------------------
> We have a pretty simple Cold Fusion application that accesses several
small Access databases via ODBC. We are moving over to a new Web Server (on
Windows Server 2003).  We wish to put the Access databases on a different
server. (also Windows 2003). To access the new server, the Web Server would
have to cross a DMZ (and obviously, switch domains). We are having problems
accessing the ODBC database on the other machine.  I believe this is because
of access privileges.
>
> Is there somewhere in the ODBC configuration where we can set up what user
ID and password to use when accessing the ODBC driver? Cold Fusion itself
have some settings for ODBC, but it doesn't look like it accounts for
database machines on another domain. I think the solution would be if we can
set the Access ODBC driver to use a specific password and ID .  I tried the
"Default Authorization" setting within the Access ODBC settings, but we
still get the authorization failure.
>
> Any ideas as to what I need to do, or possibly doing wrong?
>
> Thanks in advance.
>
>
  • Next message: Nancy Shen: "Re: ODBC Test"

    Relevant Pages

    • IIS, ODBC, MDAC incompatibility?
      ... We have some simple ASP web sites on an IIS5 server that connect to MS ... Some of the sites use ODBC; ... I've been asked why ODBC worked fine with Access databases when on the IIS5 ...
      (microsoft.public.data.odbc)
    • IIS, ODBC, MDAC incompatibility?
      ... We have some simple ASP web sites on an IIS5 server that connect to MS ... Some of the sites use ODBC; ... I've been asked why ODBC worked fine with Access databases when on the IIS5 ...
      (microsoft.public.data.oledb)
    • Can I link two .mdb file trought odbc driver ?
      ... You do not need ODBC to link two access databases (or ... mdb's are linked throuh their tables and the linked table ... manager..You should not attempt to run a query in mdb#2 ...
      (microsoft.public.access.tablesdbdesign)
    • Access databases other than through ODBC?
      ... I'm looking for a way to access databases (i.e., Oracle or MySQL) from ... The obvious and current solution is to do this through ODBC. ... - I would like to distribute an Excel file (along with the proper db ...
      (microsoft.public.excel)
    • VPN or RWW/Sharepoint or ? - unclear on the concept
      ... Files such as Frontpage 2003 sites, Access databases ... (ODBC) ... server shares. ...
      (microsoft.public.windows.server.sbs)