[fpc-pascal] Connecting SQL components to a propriety SQL server
Andreas at TheBergerClan.org
Thu May 29 19:58:43 CEST 2008
>> 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.
By API do you mean an interpreter of the SQL commands, then yes. The
connection is made either via Internet/TCP or Modem/PPP.
More information about the fpc-pascal