Brilliant, thanks. When I was looking at the ODBC setup screen, I didn't relize I could use a UNC format to point to the data. I just now tried using the create a shortcut to a web folder or ftp site link when setting up the ODBC and saw it allowed a straight UNC path.
This appears to have worked. "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." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238803 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
