6.1. It is possible, but can be a little tricky to get things set up
correctly. The key is always making sure that the applications have the
rights needed to see and use the databases.
Since you are working with two Windows domains, one that controls the
production system, one in your IT department, I'm betting this is the
cause of the problems. If there is a common username and password that
you can use to access both systems, that is what you need to use. In my
particular case, we are mixing CF 6.1 on a Windows 2000 server with our
Novell systems that house the databases and .cfm files. It works
because the machine logs in as a particular user (I'll call it
webadmin), the web server -- Apache in this case -- and all of the CF
processes run as webadmin. The webadmin account, with the same
password, also exists on our Novell systems so that it can login
transparently and access the files stored there.
If you'd like more details, feel free to contact me.
Dan
Daniel Beach | [EMAIL PROTECTED]
Webmaster | Tel: 507.646.3289
St. Olaf College | http://www.stolaf.edu/
[EMAIL PROTECTED] wrote:
> Hi Daniel,
>
> Actually, the .mdb file is part of another application on a different
> server. I need some of the data for my application. Apparently .mdb files
> don't configure well (if at all) for remote access. I will add that
> the CF
> docs state that this implementation is possible.
>
> Oh well, looks like I'll just fake out the boss to prove the concept and
> then pull back the curtain to show that the (remote) database is actually
> local and we need to move this to our production system (Oracle which, at
> the moment is gathering dust ... but that is another story/problem
> altogether)
>
> Thanks,
> Mike
>
>
>
> Daniel Daugherty <[EMAIL PROTECTED]>
> 03/03/2004 11:41 AM
> Please respond to CF-Server
>
> To: CF-Server <[EMAIL PROTECTED]>
> cc:
> Subject: RE: MS Access Datasource
>
> Mike,
>
> What specific reason are you trying to move the DB to a different
> server? The only thing this will give you is the ability to use the hard
> drive of the other system. All of the processing will still be done by
> the
> web server. With the exception of disk access and network traffic. If
> you
> are trying to offload the Database work to a different machine. Then you
> need to use a different DB type. You can upsize the access DB to MSDE or
> SQL Server and then offload this work.
>
> Daniel D.
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
