How detect connection or not to MySql?

[D.Fernandez]

Hello,
I try to detect de connection with this..
FWCONNECT oCn HOST "localhost" USER "dario" PASSWORD "123456" DB "casa2"
// But the error is shown after the If sentenece.
if oCn == nil
Msginfo("Sin conexión)"
endif

Gracias.

[vilian]

Hi,

Try this:

Code: Select all  Expand view

if oCn == nil
         Msginfo("Sin conexión)"
elseif oCn:nError <> 0
          Msginfo("Error: "+oCn:cError)
endif
 

[nageswaragunupudi]

In case the connection fails, the connection error number and description are displayed and oCn is returned with nil value.

[D.Fernandez]

Lamentablemente no funciona.
El error es
2003
Can't connect to Mysql server on 'localhost' (10061)

Gracias.

[nageswaragunupudi]

10061: Could not connect to "localhost" with the credentials.

Make sure MySQL server service is running on your PC.
Also try "127.0. 0.1" instead of "localhost"
Check your installation, user privileges, etc.
First, try with MySQL workbench to connect.