Skip to main content

Dear friends,

I installed MYSQL on Server 2003, created the tables.

I configured the ODBC driver:

 

In the cobol program when I run:

Sql exec

   Connected to "GescomMYSQL"

End-exec

I receive the following error message:

00019703 Access denied for user 'ODBC' @ 'localhost' (using password: NO)

What could be wrong?

 

 

Dear friends,

I installed MYSQL on Server 2003, created the tables.

I configured the ODBC driver:

 

In the cobol program when I run:

Sql exec

   Connected to "GescomMYSQL"

End-exec

I receive the following error message:

00019703 Access denied for user 'ODBC' @ 'localhost' (using password: NO)

What could be wrong?

 

 

Net Express 3.1 is an extremely old product version and has never been tested against MySQL.
Your syntax for the connect statement is wrong but I am assuming that is just a typo in the post.

It should be:

exec sql connect to 'GescomMYSQL' end-exec

Is the bitism of the driver correct? Is this a 32-bit system?

you might also try a different format like:
EXEC SQL
CONNECT 'username.password' USING 'GescomMYSQL'
END-EXEC

Also try starting NX as Administrator although this should not be required.

Dear friends,

I installed MYSQL on Server 2003, created the tables.

I configured the ODBC driver:

 

In the cobol program when I run:

Sql exec

   Connected to "GescomMYSQL"

End-exec

I receive the following error message:

00019703 Access denied for user 'ODBC' @ 'localhost' (using password: NO)

What could be wrong?

 

 

Using Firebird 2.5 works correctly.
Terms & ConditionsAccessibility statement