New Ranks & Badges For The Community!
Notice something different? The ranks and associated badges have gone "Star Fleet". See what they all mean HERE
Highlighted
Absent Member.
Absent Member.
1167 views

NetExpress 3.1 x MYSQL

Jump to solution

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?

 

 

0 Likes
1 Solution

Accepted Solutions
Highlighted
Micro Focus Expert
Micro Focus Expert
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.

View solution in original post

2 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert
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.

View solution in original post

Highlighted
Absent Member.
Absent Member.
Using Firebird 2.5 works correctly.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.