Re: access w username and password..
That doesn't really matter. So long as you're using the right username/password combination, it'll work fine even if you have access credentials in both places. Sometimes it's a matter of going into CFADMIN, getting it all set up so it works, then stripping the creds out of CFADMIN and using them in your datasource. I usually use the DSN to hold the credentials, though, just because I'm too lazy to add them to every... single... query... But, there's no rule... do it how is most comfortable and makes the most sense. Laterz, J On Mon, 28 Feb 2005 19:03:44 -0400, Larry White <[EMAIL PROTECTED]> wrote: > If you're setting the username and password in CF Admin, > then why are you doing it in cfquery? The datasource should > use the one set up in CF Admin. > > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| 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:197262 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
Re: access w username and password..
If you're setting the username and password in CF Admin, then why are you doing it in cfquery? The datasource should use the one set up in CF Admin. ~| 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:196893 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
Re: access w username and password..
Yeah... that's a good idea change your < and > in and to <: and > temporarily, and wrap the whole thing in a cfoutput. That'll show you the text of exactly what's being sent to the datasource as is and in place. The thing is, if CF Admin gave you an OK, you know the file is accessible, that you've got the right username and password, and that the JDBC access driver is working... so also make sure you DSN matches! I've done that... wasted 3 hours fixing a "problem" only to find out that it's a typo in the DSN. UGH. Good luck, keep us posted. J On Mon, 28 Feb 2005 14:24:02 +, Thomas Chiverton <[EMAIL PROTECTED]> wrote: > On Monday 28 Feb 2005 14:06 pm, GM wrote: > > Any other ideas? > > Dump the app vars just before the call. > Maybe they aren't being set. > > -- > Tom Chiverton > Advanced ColdFusion Programmer > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| 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:196779 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
Re: access w username and password..
On Monday 28 Feb 2005 14:06 pm, GM wrote: > Any other ideas? Dump the app vars just before the call. Maybe they aren't being set. -- Tom Chiverton Advanced ColdFusion Programmer ~| 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:196768 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
Re: access w username and password..
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? ~| 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:196764 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
Re: access w username and password..
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.. > > > In the functions I have.. > 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
Re: access w username and password..
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: cf-talk@houseoffusion.com 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.. In the functions I have.. 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
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.. In the functions I have.. 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