you need to run coldfusion under a user that has access to the network resource your conencting to.
Russ -----Original Message----- From: Brian Coleman <[EMAIL PROTECTED]> To: CF-Talk <[email protected]> Date: Wed, 26 Apr 2006 10:28:02 -0400 Subject: using a datasource thru mapped drive > 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:238792 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
