Re: Database access on another server

Peter,

The only problem I see with that is I'm using the dsn on a web hosting
company and I have no means to do so. I don't have a URL or physical path to
the DB/DSN.

Jeff P.



----- Original Message -----
From: Peter Benoit <pbenoit(at)triton-network.com>
To: 'Jeff Pearson' <sales(at)webalchemy.on.ca>; HWG Languages
<hwg-languages(at)hwg.org>
Sent: Tuesday, February 13, 2001 9:43 AM
Subject: RE: Database access on another server


> Sure, just set the path to the DB in your ODBC admin.  Doesn't need to
> reside on the same box.  Then access it via your DSN.
>
> -----Original Message-----
> From: Jeff Pearson [mailto:sales(at)webalchemy.on.ca]
> Sent: Tuesday, February 13, 2001 9:04 AM
> To: HWG Languages
> Subject: Database access on another server
>
>
> Hello,
>
> Is it possible to access a MS Access database from another server? It may
> sound weird, but I have ASP (via Chilisoft) on one server (with no MS
Access
> DB)  where our main web site is but I want to read/write to a MS Access DB
> via ODBC/DSN located on another server we have set up as sort of an
> auxillary account until it runs out in a few months.
>
> I don't want users to see the URL changing back and forth between sites.
Is
> this even possible or will it be a coding nightmare/security issue? I have
> to connect via a connection string -
>
> new_account.ActiveConnection = "dsn=dsnname;uid=userid;pwd=password;"
>
>
> Thanks,
>
> Jeff P.
>
>

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA