SQL CONNECT bug

Posted by Robert G Laurin on September 01, 2012 at 17:33:36:

I discovered the hard way that the Comet 32 SQL CONNECT does not like special characters in the password.

I tried to connect to a Linux server running MySQL and the connection was rejected every time. Oddly I could connect from the same computer using the same credential using SQLYOG. After creating a new MySQL user with a simple password, I was able to connect from Comet.

This was tested with Comet 2011.452 and Comet 2012.465

Also... GETLASTERROR control does not supply the Error number. Is there a way to retrieve both the mysql_errno() and the mysql_error()?

Can we pass commands directly to MySQL to retrieve the info ourselves?

Follow Ups:

• Re: SQL CONNECT bug Robert G Laurin 07:38:17 09/12/12 (3)
  • Re: SQL CONNECT bug Justin Guerber 17:29:10 09/12/12 (2)
    • Re: SQL CONNECT bug Robert G Laurin 06:02:57 09/13/12 (1)
      • Re: SQL CONNECT bug Justin Guerber 15:46:35 09/14/12 (0)

Post a Followup

Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.