A bit more information, if you would please... How do you have the DSN set up in CF Server? Does in already contain the username/password? When you created it, did you get an OK or an error?
If the username/password arent IN the CF administrator, maybe try adding them, create the datasource, and see if it connects. At that point, at least you'll know that CF can connect. Laterz, J On Sat, 26 Feb 2005 14:43:06 -0600, GM <[EMAIL PROTECTED]> wrote: > 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! > 54 > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:196738 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
