Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB-Aware

Lost Password?

Thread Tools Display Modes
Old 06-10-2009, 02:34 PM
terataki terataki is offline
Junior Member
Join Date: Dec 2008
Posts: 3
Default Delphi 2005 and MySQL

I'm trying to connect my application with a mysql server, but there are few issues. I do the following:

1) I add a TSQLConnection. I choose "MySQLConnection" as "ConnectionName", I insert in "Params" the database info, I change "Connected" to True, it asks for my password, I type it and everything is good.

2) I add a TSQLDataSet. I connect TSQLDataSet with TSQLConnection and I type my query in "CommandText".

3) I add a TDataSource. I choose in "TSQLDataSet" (step 2) as "DataSource" the TDataSource that I just created.

If I click "Active" at TSQLDataSet, then if the table doesn't exist, I see an error message that the table doesn't exist. If it exists, I see the following error:

Access violation at address 12499334 in module 'dbexpmysql.dll'. Read of address 00000002.
What could be wrong?
Reply With Quote
Old 08-20-2009, 11:17 AM
digitiger digitiger is offline
Senior Member
Join Date: Jan 2001
Posts: 716

first of all ensure that you have correct version of the dll file, if you are not sure then check the version of MySQl installed and get the dll file for same from its website.

Secondly, copy dbexpmysql.dll and libmySQL.dll into Project folder and try again. It should work.

Hope it helps.
Reply With Quote
Old 08-21-2009, 11:58 PM
terataki terataki is offline
Junior Member
Join Date: Dec 2008
Posts: 3

C:\>mysql --version
mysql Ver 14.12 Distrib 5.0.22, for Win32 (ia32)

How can I see if I have the correct version of the .dll file? Where can I find the correct version of the .dll file for delphi? Didn't support for delphi has stopped?
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT. The time now is 08:26 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.