Board index » delphi » Cannot connect to mysql using dbexpress

Wilson Woo

Delphi Developer
Fri, 10 Sep 2004 12:31:16 GMT

Cannot connect to mysql using dbexpress

Hi,

I have problem connecting to mysql using dbexpress. Below is my current
setting:

Driver Name             MYSQL
BlobSize                -1
Database                testdb
ErrorResourceFile
HostName                testhost
LocaleCode              0000
Password                password
User_Name               user

I do not have problem connecting to mysql using a program called
mysqlfront.exe (client-side program).
But do have error using dbexpress:

        Failure to Connect: DBX Error: Invalid Username/Password

And should I set the port to 3306 too?

Thanks.

Wilson

 
Wilson Wo

Delphi Developer
Fri, 10 Sep 2004 17:18:43 GMT

Re:Cannot connect to mysql using dbexpress


and my development environment is:
- win98se english version
- delphi 6 prof sp2
- mysql 3.23.36
- i got libmysql.dll too
Quote
Wilson Woo wrote:

> Hi,

> I have problem connecting to mysql using dbexpress. Below is my current
> setting:

> Driver Name             MYSQL
> BlobSize                -1
> Database                testdb
> ErrorResourceFile
> HostName                testhost
> LocaleCode              0000
> Password                password
> User_Name               user

> I do not have problem connecting to mysql using a program called
> mysqlfront.exe (client-side program).
> But do have error using dbexpress:

>         Failure to Connect: DBX Error: Invalid Username/Password

> And should I set the port to 3306 too?

> Thanks.

> Wilson

Wilson Wo

Delphi Developer
Fri, 10 Sep 2004 17:51:00 GMT

Re:Cannot connect to mysql using dbexpress


and i heard that dbexpress cannot work with mysql 3.23.xx but 3.22.xx.
is it true?
Quote
Wilson Woo wrote:

> and my development environment is:
> - win98se english version
> - delphi 6 prof sp2
> - mysql 3.23.36
> - i got libmysql.dll too

> Wilson Woo wrote:

> > Hi,

> > I have problem connecting to mysql using dbexpress. Below is my current
> > setting:

> > Driver Name             MYSQL
> > BlobSize                -1
> > Database                testdb
> > ErrorResourceFile
> > HostName                testhost
> > LocaleCode              0000
> > Password                password
> > User_Name               user

> > I do not have problem connecting to mysql using a program called
> > mysqlfront.exe (client-side program).
> > But do have error using dbexpress:

> >         Failure to Connect: DBX Error: Invalid Username/Password

> > And should I set the port to 3306 too?

> > Thanks.

> > Wilson

Henk Veroude

Delphi Developer
Fri, 10 Sep 2004 20:01:55 GMT

Re:Cannot connect to mysql using dbexpress


Hi Wilson,

I run here against Mysql 3.23.47 server and 3.23.44 client. No problems of
that kind. Are you sure that the server is up...? The invalid username is
often generated when it cannot attatch to the server at all or ofcourse if
the username etc is wrong. I just replied to let you know that it can be
done.

Greetings,
Henk

"Wilson Woo" <wilso...@hk.super.net> a crit dans le message de news:
3C9EF304.7DB8F...@hk.super.net...

Quote
> and i heard that dbexpress cannot work with mysql 3.23.xx but 3.22.xx.
> is it true?

> Wilson Woo wrote:

> > and my development environment is:
> > - win98se english version
> > - delphi 6 prof sp2
> > - mysql 3.23.36
> > - i got libmysql.dll too

> > Wilson Woo wrote:

> > > Hi,

> > > I have problem connecting to mysql using dbexpress. Below is my
current
> > > setting:

> > > Driver Name             MYSQL
> > > BlobSize                -1
> > > Database                testdb
> > > ErrorResourceFile
> > > HostName                testhost
> > > LocaleCode              0000
> > > Password                password
> > > User_Name               user

> > > I do not have problem connecting to mysql using a program called
> > > mysqlfront.exe (client-side program).
> > > But do have error using dbexpress:

> > >         Failure to Connect: DBX Error: Invalid Username/Password

> > > And should I set the port to 3306 too?

> > > Thanks.

> > > Wilson

Kees de Koote

Delphi Developer
Fri, 10 Sep 2004 20:16:07 GMT

Re:Cannot connect to mysql using dbexpress


Quote
Wilson Woo wrote:
> Hi,

> I have problem connecting to mysql using dbexpress. Below is my current
> setting:

> Driver Name                MYSQL
> BlobSize           -1
> Database           testdb
> ErrorResourceFile
> HostName           testhost
> LocaleCode         0000
> Password           password
> User_Name          user

> I do not have problem connecting to mysql using a program called
> mysqlfront.exe (client-side program).
> But do have error using dbexpress:

>    Failure to Connect: DBX Error: Invalid Username/Password

> And should I set the port to 3306 too?

> Thanks.

> Wilson

I'm having the same problem. I created a database on my local machine.
Connecting was no problem. After I moved the db to my server I got the
same error message as you get.
I am able to connect to the database with MySQL manager, so username and
password are correct.

Kees de Kooter

Kees de Koote

Delphi Developer
Fri, 10 Sep 2004 21:25:24 GMT

Re:Cannot connect to mysql using dbexpress


Quote
Wilson Woo wrote:
> Hi,

> I have problem connecting to mysql using dbexpress. Below is my current
> setting:

> Driver Name                MYSQL
> BlobSize           -1
> Database           testdb
> ErrorResourceFile
> HostName           testhost
> LocaleCode         0000
> Password           password
> User_Name          user

> I do not have problem connecting to mysql using a program called
> mysqlfront.exe (client-side program).
> But do have error using dbexpress:

>    Failure to Connect: DBX Error: Invalid Username/Password

> And should I set the port to 3306 too?

> Thanks.

> Wilson

Set the libraryname to dbexpmysql.dll. It seems that you need this one
to connect to 3.23.
Anyway, it works for me now.

hth,
Kees de Kooter

Wilson Wo

Delphi Developer
Sat, 11 Sep 2004 09:35:22 GMT

Re:Cannot connect to mysql using dbexpress


Hi Henk,

The server is up and the username and password are ok too, because I
have another program to connect to mysql server (mysqlfront.exe).

By assigning LibraryName to dbexpmysql.dll instead of dbexpmys.dll, the
error

        Failure to Connect: DBX Error: Invalid Username/Password

does not appear anymore.

Cheers,
Wilson

Quote
Henk Verouden wrote:

> Hi Wilson,

> I run here against Mysql 3.23.47 server and 3.23.44 client. No problems of
> that kind. Are you sure that the server is up...? The invalid username is
> often generated when it cannot attatch to the server at all or ofcourse if
> the username etc is wrong. I just replied to let you know that it can be
> done.

> Greetings,
> Henk

> "Wilson Woo" <wilso...@hk.super.net> a crit dans le message de news:
> 3C9EF304.7DB8F...@hk.super.net...
> > and i heard that dbexpress cannot work with mysql 3.23.xx but 3.22.xx.
> > is it true?

> > Wilson Woo wrote:

> > > and my development environment is:
> > > - win98se english version
> > > - delphi 6 prof sp2
> > > - mysql 3.23.36
> > > - i got libmysql.dll too

> > > Wilson Woo wrote:

> > > > Hi,

> > > > I have problem connecting to mysql using dbexpress. Below is my
> current
> > > > setting:

> > > > Driver Name             MYSQL
> > > > BlobSize                -1
> > > > Database                testdb
> > > > ErrorResourceFile
> > > > HostName                testhost
> > > > LocaleCode              0000
> > > > Password                password
> > > > User_Name               user

> > > > I do not have problem connecting to mysql using a program called
> > > > mysqlfront.exe (client-side program).
> > > > But do have error using dbexpress:

> > > >         Failure to Connect: DBX Error: Invalid Username/Password

> > > > And should I set the port to 3306 too?

> > > > Thanks.

> > > > Wilson

Wilson Wo

Delphi Developer
Sat, 11 Sep 2004 09:38:21 GMT

Re:Cannot connect to mysql using dbexpress


Hi Kees,

The connection is ok now. But I still have to check if other components
work fine.

Thank you very much.

Cheers,
Wilson

Quote
Kees de Kooter wrote:

> Wilson Woo wrote:

> > Hi,

> > I have problem connecting to mysql using dbexpress. Below is my current
> > setting:

> > Driver Name           MYSQL
> > BlobSize              -1
> > Database              testdb
> > ErrorResourceFile
> > HostName              testhost
> > LocaleCode            0000
> > Password              password
> > User_Name             user

> > I do not have problem connecting to mysql using a program called
> > mysqlfront.exe (client-side program).
> > But do have error using dbexpress:

> >       Failure to Connect: DBX Error: Invalid Username/Password

> > And should I set the port to 3306 too?

> > Thanks.

> > Wilson

> Set the libraryname to dbexpmysql.dll. It seems that you need this one
> to connect to 3.23.
> Anyway, it works for me now.

> hth,
> Kees de Kooter

Other Threads

1. Connecting to mySQL database using dbExpress - problems :-(

2. PROBLEMS: Connecting to MySQL database using dbexpress

3. Connect to non-standard MySQL port using dbExpress

4. why dbexpress cannot find remote MySQL server

5. dbexpress+mysql: Cannot read more than 10 fields

6. Connect to MySQL with dbExpress

7. HELP: Can't connect to MySQL with DBExpress in Delphi 6

8. new to Dbexpress,Mysql - connect to ...

9. dbExpress/MySql connect problem

10. dbExpress WILL NOT connect to a remote mysql (linux) server