Hi all, I'm trying to help a client work out an interim fix for a security issue. They need to move the administrative interface for some CF applications off of their public-facing website. The applications store some sensitive data that require there be no public interface available. The interim solution is to move the administrative interfaces onto a web-server inside their firewall, create a VPN from this box to the external public-facing web-server, and connect to the databases using the VPN tunnel. The databases in question are SQL Server or Access.
They've got the VPN functional (using virtual IP configuration), and have mapped a drive through to the directory where the Access DBs reside. Unfortunately, they're getting an error trying to create the DSN on the internal ws. The servers are Windows servers. Using either the drive-letter of the mapped path, or a UNC addressing scheme, the error received is: Connection verification failed for data source:[datasourcename] 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. They also tried using the Access Unicode driver, and get a slightly different error, but essentially the same: Connection verification failed for data source:[datasourcename] com.inzoom.adojni.ComException: Not a valid file name. The root cause was that: com.inzoom.adojni.ComException: Not a valid file name. in Microsoft JET Database Engine code=0 Type=1 They have checked the user the CF services are running under, have logged in as that user and verified that it has access to the share and the files therein. Also, CF can successfully create Access DSNs on the local server without problem. Any suggestions would be most appreciated. Cheers, Kris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
