Thanks Andy, I just fixed this, literally. As I started typing my test page popped up with the results I needed.
I needed to change the user for the "ColdFusion MX ODBC Server" Service. I also changed the user for the "ColdFusion MX Application Server" and "ColdFusion MX ODBC Agent" services as well for consistency. Once I did that, I was able to access the FoxPro database, but it is slow across the WAN. I have to test the connection on a web server on the same subnet as the FoxPro data server. I'll let the group know how it turned out. Thanks again. Russel Madere Webmaster 504.832.9835 SunShine Pages by EATEL www.sunshinepages.com -----Original Message----- From: Andrew Tyrone [mailto:[EMAIL PROTECTED] Sent: Monday, November 21, 2005 3:26 PM To: CF-Talk Subject: RE: Using FoxPro in ColdFusion [snip] It sounds like you used the Administrator account on the machine, which by default, if I remember correctly, has no network access rights. For testing, you can create a user, make them a member of Domain Admins, and run the service(s) under this account. I haven't used the full version of JRUN for probably 8 years, so I can't tell you what services need what permissions. --Andy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224956 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
