I have a problem with setting up a datasource in CF Admin using a mapped drive. The files I want to use are on another server...if I copy them to the web server, use ODBC to point to them, then connect that way, it works fine.
If I use a mapped drive and use ODBC to point to the mapped drive, then try to set up the datasource to use the mapped drive, it doesn't work. Even if I map a drive to the webserver itself, it still gives the error. The type of files are DB2, but I've tried an Access database, too. The error it gives in cfadmin is Connection verification failed for data source: gchstest java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC dBase 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 dBase 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. Thanks, Brian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238775 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
