is this on your dev machine? if so you need to either set the tables username and password or be sure to set them as blank
like <cfset un = ""> <cfset pw = ""> what its doing is throwing an error because the username and passord is incorrect. If your queries are set up "access style" then you need to add the username and password attributes <cfquery name="qgetUser" datasource="#dsn#"> thus becomes <cfquery name="qgetUser" datasource="#dsn#" username="#un#" password="#pw#"> ---------------------------------------- From: "Rick Faircloth" <[EMAIL PROTECTED]> Sent: Monday, February 21, 2005 10:05 PM To: CF-Talk <[email protected]> Subject: RE: OT: Live Chat Service Funny you should mention MySQL db connections...I just installed MySQL 4.1 on a server with CF 4.5.2 for the first time and can't get CF hooked up with MySQL. CF keeps erroring and saying: ODBC Error Code = HYT00 () [MySQL][ODBC 3.51 Driver] Access Denied for User 'ODBC'@'localhost' (using password NO) I'm trying to figure out where the "[EMAIL PROTECTED]" is coming into play. I'm not logging into the new MySQL Administrator that way, and I've given the account I do use to login to MySQL all rights. I noticed that when I entered registered the database with the ODBC Administrator in the Control Panel (Windows 2000 Server) that it said that ODBC was the default user in the options, but I used my own username... The database shows up in CF Administrator under ODBC, but it won't connect... I've tried changing the account that CF is running under to the same Username and Password that I use to connect to MySQL and used the same Username and Password to register the database in the Administrator...I'm missing something...(perhaps the brains to do this! :o) Somewhere I've got things set up wrong...any ideas? Rick -----Original Message----- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, February 21, 2005 8:54 PM To: CF-Talk Subject: RE: OT: Live Chat Service i'd spend the 100 bucks for phplive, it really is nice. and no you don't need to know php just know the mysql db connections, its pretty painless, and if i can do it.................. ---------------------------------------- From: "Rick Faircloth" Sent: Monday, February 21, 2005 8:50 PM To: CF-Talk Subject: RE: OT: Live Chat Service CraftySyntax looks interesting...I'm a little wary of it, however. I don't know anything about php...is that a problem with using it? I see that phplivesupport is also php...do I have to understand php to deploy and use it? I see that it can be modified, but do I need to? Rick -----Original Message----- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Monday, February 21, 2005 5:45 PM To: CF-Talk Subject: Re: OT: Live Chat Service Here's another one: http://www.craftysyntax.com/ HTH! -Jordan dave wrote: >phplive (choke) is the best i have used > http://www.phplivesupport.com/ > >---------------------------------------- >From: "Eric Hoffman" >Sent: Monday, February 21, 2005 11:00 AM >To: CF-Talk >Subject: OT: Live Chat Service > >Blah monday to everyone... > >Do any of you have experience with a live chat service and can recommend one? Paid is fine, figuring free doesn't exist. I know of Live Person, but looking for others as well and experiences. Hopefully this question helps several folks out there. > >Thanks. > >Eric > > > -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:195858 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
