[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

How to connect mysql database using Ttables

Anybody can help me? I'm new with this mysql and i want to know on how to connect mysql database to Ttables. Just an example source codes will do.

Thanks.
0
ryan_sabarre
Asked:
ryan_sabarre
  • 2
2 Solutions
 
ryan_sabarreAuthor Commented:
Thanks in advance.
0
 
calinutzCommented:
First option would be to build a DSN using the mysql drivers on the computer you intend to use the application on... and then with ADO Database component or BDE database component connect to the DSN (if you need to use only the TTable then it's BDE, but if not, and TADOTable suits you then use the ADO components.
Also you could use the DBExpress Components to connect to your database (some say it's better... I never tryed it).
Also there is an open source database component pack called Zeos (look it up on google) It is enhanced for connectinfg to open source databases like PostgreSQL and MySQL and others too.
So here's your answer
Regards
0
 
Mohammed NasmanSoftware DeveloperCommented:
Hi,

If you would to use TTable(BDE), then you can download the ODBC drivers and connect using it with the TTable

or you can download the Ole db driver from mysql and use the Ado components

you can use ZeosLib to connect

if you need a direct connect method, which i prefer more than Ado or BDE, here are few libraries

for free
AnyDac
http://www.da-soft.com/AnyDACHome.html

ZeosLib
http://sourceforge.net/projects/zeoslib/

or one of the best MyDac, but it's not free
http://www.crlab.com/mydac/

Regards,
Mohammed
0
 
ryan_sabarreAuthor Commented:
Sorry, but i need a sample source code for this. I don't want to use a third party components in my application.

Anyway, i already got the answer of my question. I'll still give you points for this.

Thanks.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now