Again - First try at connecting to DB on network

[Howard Perlman]

I've read all the posts about this problem, but still can't find an answer that
works.

It shouldn't be so hard. But, for the first time, I now want to connect
(ODBC) to a database (Access) on another server on our network. Before, the
databases were on the same machine as CF server.

First, I made a network drive of remote directory. it is now the T: drive.
Then I go into CF administrator and try to establish a data source, but when I
click the "Browser Server" button, all I see are the drive letters of my local
machine. No T: drive.

Then I try typing in both the network drive path (T:\database2003.mdb) and I
also tried the full path
(\\df1dgaatl\Groups\Safety\2005\Database\Database2 003.mdb) in the "Database
File" box. That gives and error trying to set up the connection.

Then, after reading, it sounds like the default user/passord cannnot be used,
so we set up a new user called "coldfusion" and password,and I put those, but
still an error. Below is the error gotten when I put in the whole path to the
database and used coldfusion as the "Coldfusion Username":

Does anyone have any ideas for me? This would be a great thing to get working.
Thanks



"Connection verification failed for data source: Safety
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC
Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet
database engine cannot open the file '(unknown)'. It is already opened
exclusively by another user, or you need permission to view its data."

[SafariTECH]

Access ODBC cannot be used anywhere but on the local server, and you cannot use
"temporary drives" as a possible work around, because the driver for Access
requires a permanent drive path.

Access actually isn't considered a good solution for any web application
unless it expects very little data traffic. You can get away with it to a
certain degree, but you would be better off if you can get a DBMS like MSSQL or
ORACLE