I am running ColdFusion server MX 6.0 on a Windows 2000server. In Administrator I am trying to connect to an MS Access datasource on a remote NT 4.0 server. I have tried to connect using ODBC sockets and MS Access and neither will work. I have the ColdFusion services all set to run with my administrator username and password (which should have all access to the remote server). The drive that the database sits on the remote server has security set to full control for domain admins and modify for domain users.
The error message in ColdFusion is as follows:
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info java.sql.SQLException: [MERANT][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
I copied the database to the local ColdFusion Server and I can connect fine to it using both ODBC sockets and MS Access with the Use Default Username checked and no Advanced settings.
I don’t understand why I can connect to the Access database if it sits on the local ColdFusion server, but I can’t connect to it when it is on the remote NT 4.0 server. Any ideas or suggestions would be appreciated.
Thanks.
The error message in ColdFusion is as follows:
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info java.sql.SQLException: [MERANT][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
I copied the database to the local ColdFusion Server and I can connect fine to it using both ODBC sockets and MS Access with the Use Default Username checked and no Advanced settings.
I don’t understand why I can connect to the Access database if it sits on the local ColdFusion server, but I can’t connect to it when it is on the remote NT 4.0 server. Any ideas or suggestions would be appreciated.
Thanks.