Does anyone know what the hell I'm doing wrong. Please help. I have Access 2002 if that helps any. Thanks in advance ----- Original Message ----- From: GM To: [email protected] Sent: Saturday, February 26, 2005 2:43 PM Subject: access w username and password..
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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196736 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
