I am trying to read an access database that is in a shared folder on our network. When I try to set up a DSN I get this error
Connection verification failed for data source: Elms
[]java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]Required user name is missing.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]Required user name is missing.
If I use the default database username I get the following
Connection verification failed for data source: Elms
[]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.
The database is not opened by another user? My windows username has access to that share, I tried having coldfusion log on as me to do the task but that didn't work either.
The database also does not have a user name or password.
What I am I doing wrong?
Mike
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
