CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Anyone else having connect problems with PHP?

Print topic Send  topic

Author Message
rgranger
Posted: 05/22/2002, 7:05 AM

The server side function connect in db_mysql.php is not receiving the password from Common.php. I can hard code my mysql password in the function header or if I change $Password to $password in the object $this->password it works. If I change the connect failed message to also display the password, this is what gets printed:
Warning: Access denied for user: 'root@986home.dodi.com' (Using password: YES) in /var/www/html/sites/delog/db_mysql.php on line 79
Database error: pconnect(10.20.0.10, root, Object) failed.
MySQL Error: ()
Session halted.
Mark
Posted: 05/28/2002, 12:31 AM

Except this is all being run locally.

My first page connects to the db just fine. (Search / Grid / Record)
I added a new page, to allow insertion of a new record into the db.
Now when I try to view the live page, I get similar messages to yours, but I haven't changed any project/connection settings.
My error says "Access Denied for 'user@ODBC@localhost' ...."

My local MySQL db has both login & password not set, so there's no values to pass.

I'm really puzzled !

Mark


Arjen Breur
Posted: 06/19/2002, 7:13 AM

I have the same problem. On most pages the connection does work, on a few it doen NOT.
I also tried hardcoding my password, but because some pages do work, this is not where the real problem is solved.

Please help!

Arjen Breur
Posted: 06/20/2002, 1:46 AM

Hey,

I fixed my problems (see above) by changing the names of the fields of the table of my database that presented the problems. I suspected that one of the field names was conflicting in the codecharge scripts. Probably something like "password" or "login". I changed them to "user_password" and "user_login". Seems to work.

greetz, Arjen.
Mark
Posted: 06/20/2002, 10:50 AM

that my offending form has a field called password on it.. I wonder ?!

Will let you know if this fixes it.

Regards,
Mark
EMG
Posted: 06/20/2002, 11:00 AM

I had same problem with a field called password. I changed it to txtPassword and everything worked fine !?!
Sneakers
Posted: 11/19/2002, 10:12 AM

I too had the same "access denied" problem. My database had a field named "User". It's too bad CodeCharge doesn't give you a message if you have conflicting variable names.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.