BorlandTalk.com

Jan Ferguson · Guest

I have never used MySQL before as a DBMS but currently have a client
who needs to convert a DBIsam database to MySQL (The reason is a change
of web hosting, the application being a Windows app which access data
via the internet. The current provider does not support DBIsam,
NexusDB, Advantage, etc. as the previous one did - only MySQL and MS
SQL. The client wants to standardize with MySQL since many web hosting
providers include MySQL...besides the fact that it's open source.) The
conversion will be no problem but I have some questions on the
connectivity.

I am using D7/MySQL 4.0.22 and I found the only way to connect to the
database is with dbExpress (packaged with D7). The connection is no
problem (using SQLConnection and SQLTable)...the test table I created
is seen, etc. I am using a regular Delphi datasource component and none
of the data-aware components respond to it (i.e., the navigator remains
disabled, grids show the fields but don't allow entry, etc.)

Can someone advise what they use to connect to MySQL databases? If I am
using the right components can you advise why the data-aware components
don't seem to be responding.

Thanks in advance.

--
Regards,
Jan Ferguson

Bill Todd · Guest

Before you do anything else you need to read the sections in the
Developer's Guide about dbExpress. The dbExpress dataset components are
all unidirectional and cannot be used directly with data aware
controls. You should not use the SQLTable component for any reason. The
right configuration is:

SQLConnection->SQLDataSet->DataSetProvider->ClientDataSet->DataSource->D
ata aware controls.

There are also some articles on using dbExpress on BDN. If you have
been working with DBISAM
http://bdn.borland.com/article/0,1410,29106,00.html may be helpful.

Note also that there are other alternatives for connecting to MySQL
including ADO and the MySQL ODBC driver.

--
Bill (TeamB)
TeamB cannot answer questions received via email

Jan Ferguson · Guest

Thanks Bill. I looked at ADO and couldn't figure out how to connect to
MySQL. I thought about MySQL ODBC after I sent the message. It's been a
L-O-N-G week and the brain is starting to shut down... <g>

Lots of experience with DBIsam and Advantage. I'll look at the references
you suggested. Thanks again...

"Bill Todd" <no (AT) no (DOT) com> wrote

Suvra B · Guest

We are useing PHP my admin and Control centre.

But best way is to ask your hostings support.

John Kuiper · Guest

I'm using MySQLDac to connect Mysqlservers.
It's working perfectly and has the same components as the standard BDE.
But use MySQLQuery instead of MySQLTable. MySQLTable reads the entire
table when not using a filter. MySQLTable only works on a live-request
to the database. When updating records from MySQLquery use MySQLUpdate.
I made a new component above the MySQLupdate, because (thats my opinion)
it is not work properly.

Regards,
John Kuiper

Jan Ferguson wrote: