Okay, I have to be doing something wrong.. I can't get the username and password to work with CF and Access. In Coldfusion (application.cfm) I have.. <cfset application.dbUserName = "Admin"> <cfset application.dbPassword = "xxxxxx"> In the functions I have.. <cfquery name="NextBusinessID" datasource="bindex" password="#application.dbPassword#" username="#application.dbUserName#" > I get this error.. SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
If I remove the password from the DB and remove those from the function I dont get an error and the page loads fine. Maybe I'm setting the password wrong.. first off I dont see a username option.. I go into access (exclusive mode) and then choose the Tools menu and then Security and then Set Database Password. I'm assuming that Admin is the username because when I go into User and Group Permissions I see "Current User: Admin". Can you help me out.. what am I doing wrong? Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:196695 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
