MySql connect problem

Jim Johnston

Delphi Developer

Sun, 30 May 2004 11:46:15 GMT

dbExpress/MySql connect problem

Trying to learn dbExpress with MySql. Have the mySql server running on
localhost.

Set up the TSqlConnection component fine, set the active to True. It
asks for the username/password and shows active connection. Now I'm
trying to get a TSqlQuery component to work, and when I try to set
active to true, it gives me the error "Access Violation at address
04568744 in module 'DBEXPMYS.dll'. Read of address 706F6570". Any idea
what this is and what I'm doing wrong?

Also, does anyone have some sample code I could see on how to do a MYSQL
connection using a console app (non-component)?

Thanks in advance...

Jim Johnston
Center Field Software

Dave Nottag

Delphi Developer

Sun, 30 May 2004 18:16:55 GMT

Re:dbExpress/MySql connect problem

Quote

"Jim Johnston" wrote:
> Trying to learn dbExpress with MySql. Have the mySql server running
on
> localhost.

> Set up the TSqlConnection component fine, set the active to True. It
> asks for the username/password and shows active connection. Now I'm
> trying to get a TSqlQuery component to work, and when I try to set
> active to true, it gives me the error "Access Violation at address
> 04568744 in module 'DBEXPMYS.dll'. Read of address 706F6570". Any
idea
> what this is and what I'm doing wrong?

Make sure the hostname in the dbExpress settings is identical to what
the hostname used by MySQL is.

--
Dave Nottage

Jez Thompso

Delphi Developer

Sun, 30 May 2004 20:35:22 GMT

Re:dbExpress/MySql connect problem

if the mysql server is 3.23.x you will need the update pack 1 and file
dbexpmysql.dll

Quote

"Dave Nottage" <d...@removethis.b3.com.au> wrote in message

news:3c172f0a_1@dnews...

Quote

> "Jim Johnston" wrote:
> > Trying to learn dbExpress with MySql. Have the mySql server running
> on
> > localhost.

> > Set up the TSqlConnection component fine, set the active to True. It
> > asks for the username/password and shows active connection. Now I'm
> > trying to get a TSqlQuery component to work, and when I try to set
> > active to true, it gives me the error "Access Violation at address
> > 04568744 in module 'DBEXPMYS.dll'. Read of address 706F6570". Any
> idea
> > what this is and what I'm doing wrong?

> Make sure the hostname in the dbExpress settings is identical to what
> the hostname used by MySQL is.

> --
> Dave Nottage

Jim Johnsto

Delphi Developer

Sun, 30 May 2004 20:59:06 GMT

Re:dbExpress/MySql connect problem

Quote

Jez Thompson wrote:
> if the mysql server is 3.23.x you will need the update pack 1 and file
> dbexpmysql.dll

Running version 3.23.34a, and have downloaded and applied update pack 1. Any
other ideas?

Jim

Other Threads

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

2. PROBLEMS: Connecting to MySQL database using dbexpress

3. dbexpress and problem to connect to a remote MySQL engine

4. Connect to MySQL with dbExpress

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

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

7. Connect to non-standard MySQL port using dbExpress

8. Cannot connect to mysql using dbexpress

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

10. DbExpress + MySql / ADO + MySql