We have a small but critical application running off an Access DB. We are moving the application from an older server (soon to be retired), to a new server. The older server is Windows 2000, with ColdFusion 6.x. The Access DB is on a separate server on our network. When this applicaiton was built several years ago we created a Windows user for the ColdFusion service, then gave that user modify rights on the folder on the server that houses the db. This application has been up and running fine for several years. I am now trying to move it to the new server, Windows 2003, IIS 6, ColdFusion 7.x Enterprise. I cannot get the DSN to work. I have created a user for the ColdFusion Instance service, given it local admin rights on the box coldfusion sits on and provided it with modify rights to the folder on the other server where the DB resides. I have two questions: #1. Here is the error message I get in the Coldfusion Administrator when I try to verify the DSN. Does anyone have any ideas of where I am going wrong? (besides using Access, it's not my application I don't have much choice) Connection verification failed for data source: ISINV_DEV com.inzoom.adojni.ComException: Not a valid file name. The root cause was that: com.inzoom.adojni.ComException: Not a valid file name. in Microsoft JET Database Engine code=0 Type=1 #2. When creating a windows user account to be used with the ColdFusion service what rights does that user account need? I believe that ColdFusion uses the Local System account by default.
Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239171 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
