ADO, dbExpress...some questions

[Jonah86]

I'm trying to get away from using BDE, as I've heard it's not long for this world. First off, which is the better choice between ADO and dbExpress? I've used ADO before, in VB, and can get it to work in Delphi pretty well so far. My fellow programmer seems to have taken a liking to dbExpress...though he hasn't used it yet.

A problem I'm having with dbExpress is: I have an SQLConnection object, a dataset object and datasource. Trying to set up the connection I select MySQL as the driver and it set vendorlib to LIBMYSQL.DLL, and when I try to set the connection to active it says it can't load the .dll. I moved the .dll to the system32 directory hoping it would find it there...I put the full path to the .dll in the property box...nothing works. What am I doing wrong?

And also, if there are any good places that have a ground up walk through of dbExpress, or even a quick getting started type thing, that would be great. Or if anyone here has some helpful insights on the subject that would be great as well.

And one more...if you know a lot about a lot of things...please go read my other poast, on using Rave to display a whole table...I'm getting really depressed about that one Thanks!

 

[towerbase]

You could try the FAQ's for a very brief introduction to dbExpress.

Andrew
Hampshire, UK

 

[Jonah86]

Yeah, I looked over them but I can' really do anything until I get the problem I'm having sorted out. I can't make the SQL connection work as long as it refuses to "Load LIBMYSQL.dll". Thanks though, those FAQs are nicely done.

 

[towerbase]

I have LIBMYSQL.DLL in c:\windows\system32 and it works for me.

I am using Delphi 7 Pro, Windows XP Home Edition and MySQL version 4.0.14

There was a posting in this forum some time ago about the location of LIBMYSQL.DLL and the problem you are experiencing, but I can't seem to find it.



Andrew
Hampshire, UK

 

[Jonah86]

Do I have to have MySQL installed on the machine I'm using, or is it being installed on the server ok? I could be using the wrong LIBMYSQL.dll file if that's the case, because the file I got was from MySQL Control Center, but I don't actually have MySQL installed on this machine. If this is the case, will I have to have it installed on any machines I want to put a my programs on?

 

[towerbase]

I have no experience of running MySQL in an networked environment. But my understanding is that you don't need MySQL on the local machine if you have it installed on a server.

Andrew
Hampshire, UK

 

[cheikh1]

if i understood your question,
you have a MySql database and a delphi application
and you want to us IBEXPRESS Components.
if that IBEXPRESS used only for interbase databases.

 

[Jonah86]

No no, I want to use DBExpress, not interbase. Thanks though.