Re: Access denied for user ODBC@

[shujing jia]

Hi,

Thanks a lot for your help. Actually I did the same way as you mentioned here, but still can not connect to the local MySQL database that I created. The following shows how I created the database, configue the MySQL ODBC, and establish connection through f90SQL from fortran code. Hope it will make more sense to you.

Step1 - create MySQL database

C:\mysql\bin>mysql -u root
mysql> create database testDB;
mysql> use testDB;
mysql> create table ...
mysql> insert into ...

Step2 - configue MySQL ODBC (v 3.51)

SystemDSN: mytestDB
Server: (use default)
User: root
Password: (none)
Database: testDB

Step3 - establish connection from fortran

username = 'root'
password = ''
call f90SQLConnect(ConnHndl, pcDSN, username, password, iRet)

The connection always failed with the return value -1 of iRet.

I also tried to ignore "username" and "password" by setting empty string and the connection failed too.


Shujing