You can use datasources on another machines. I'm pretty sure you can use the UNC path
in CF Adiministrator to specify a datasource somewhere on the network, on a network
drive available the machine that is running ColdFusion. If you go into ODBC Data
Sources in the control panel you can select an .mdb file on a network drive when
setting up the datasource. Once again, ColdFusion must be running as a user on the
machine with sufficient rights to access network shares for this to work.
- Andy
> -----Original Message-----
> From: Dave f [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 17, 2001 2:51 PM
> To: CF-Talk
> Subject: Re: Setting up Access Datasources
>
>
> Actually, I don't think that you can have CF verify Access db on a
> different machine. Doesn't CF admin only show local drives if you pick
> "Access database" ??? It was a long time ago in a distant galaxy,
> but I seem
> to remember having to switch to SQL or something
> D.
>
> ----- Original Message -----
> From: "Curtis C. Layton" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, April 17, 2001 11:10 AM
> Subject: Setting up Access Datasources
>
>
> > Here's an interesting question:
> >
> > We recently set up a server cluster that is configured in this fashion:
> >
> > Web1/Web2 Boxes: Win 2K Advanced Server SP1, CF Enterprise
> 4.5, MDAC 2.5
> > SQL Box: Win 2K Advanced Server SP1, SQL Server 7.0
> >
> > Now....I can get SQL Server databases to verify on both Web
> boxes with no
> problem. I've mapped a drive onto the Web boxes to add Access
> databases but
> I cannot get them to verify. Any help with be appreciated.
> >
> >
> > --------------------------------------------
> > Curtis C. Layton
> > Senior Web Applications Developer
> > Words In Progress Inc.
> > [EMAIL PROTECTED]
> >
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
