Skip to main content

NetExpress 3.1 x MYSQL

  • February 17, 2017
  • 2 replies
  • 0 views
D

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?

 

 

    2 replies

    Chris Glazier
    Forum|alt.badge.img+2

    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.
    D

    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.

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement