MS-Acess

[webhead_1]

I have an access db running on an old websever and would like to create a
datasourse on the new webserver until I setup the access db into MS-SQL. every
time I try to create a datasourse I get the following error. I have a shared
path to the old webserver but I have no luck when creating a datasourse. Any
help would be greatly appreciated.

Connection verification failed for data source: iccstaff
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.

[dr_bozak]

my guess is that your path is incorrect.

look on the new web server to see which directory your db is in. obviously
this should not be a web accesible directory.
ie .. on mine its: D:/webdata/sitename/db/mydatabase.mdb

copy that path:
and put it in the administrator.
I think the field is called "database file"

make sure the ,mdb doesn't have an .ldb file in the same directory, as that
indicates its locked

CF will let you know immediately if it setup the db okay or not.


add the datasource.