Access db connection to mapped drive

Question

We have an Access db on another Web server we are trying to
use for queries/select statements only on another Web server. We
create a mapped drive and enter the path to the mapped drive in the
connection string. The connection verifies and the Web pages
function correctly.

If CF is stopped/started, the path changes to the computer
name path instead of the mapped drive path and we obtain the error
messages below

Connection verification failed for data source: yoc
java.sql.SQLException: [Macromedia][SequeLink JDBC
Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]
'(unknown)' is not a valid path. Make sure that the path name is
spelled correctly and that you are connected to the server on which
the file resides.
The root cause was that: java.sql.SQLException:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] '(unknown)' is not a valid path. Make sure
that the path name is spelled correctly and that you are connected
to the server on which the file resides.

We are CF 7.01

Any suggestions?

Thanks for your help

Pam

AAOS

Newsgroup_User · Answer

The way I have usually done this type of thing:

Configure the ColdFusion service in the Windows Services Panel to be
running under a domain user that has permission to see the desired
network location, rather then the default 'localsystem' user that
usually has no network permissions.

I then use a UNC path to the desired database over the network. Such as
\\remoateAccessServer\directory\file.mdb rather then a mapped drive letter.

Mapped drives are tricky and hard to maintain.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded