Not sure if I completely understand. But:
We connect to a remote MySQL database(remote as in, in another building and different network). Have you tried to set up an ODBC connection thru Administravtive Tools/Data Sources(ODBC)? We set up a System DSN in there using an account that has the necessary permissions on the MySQL box. This DSN will then show up in the ColdFusion Admin when you select ODBC Socket as your driver. This has also worked with making connections with .xls files and others. Just had to make sure the server making the ODBC socket had the necessary drivers. -----Original Message----- From: Brian Coleman [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 26, 2006 8:33 AM To: CF-Talk Subject: Re: using a datasource thru mapped drive "you need to run coldfusion under a user that has access to the network resource your conencting to." If you mean the CF services, I am running them with a user that has access. I'm actually running them with a user that probably has over kill permissions as far as the network goes, just to try to get it to work. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238796 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
