[fpc-pascal] Connecting SQL components to a propriety SQL server

[Michael Van Canneyt]

On Thu, 29 May 2008, Andreas Berger wrote:

> I have a friend that has a product which is composed of an embedded system
> spread around Brazil and communicating with a central PC. I am convincing him
> to migrate some of his PC tools to Pascal in order to ease my help for him.
> The question I have is this:  He has his own small SQL server on some of these
> embedded cards and I would need to establish a connection via the database
> components in Free Pascal to his SQL. I know nothing about SQL, only that Free
> Pascal has interfaces to various SQL servers. How hard would it be to make an
> interface to his SQL servers?

It depends very much. Does he have an API to access this SQL server ?
If so, it's just a matter of using this API to create an TSQLConnection.

If the connection happens on a low level, then it will be a bit harder.

Without more information, it's hard to give advice.

Michael.