Thanks J, I didnt have the username and password in the CFadministrator but I added them. I used Admin and the password and got an OK. I hit the verify connections button just to make sure and it was OK. Any other ideas?
Subject: access w username and password.. From: "GM" <[EMAIL PROTECTED]> Date: Sun, 27 Feb 2005 16:23:49 -0600 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=38661&forumid=4#196736 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196761 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
