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

2008-05-29 Thread 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.
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal


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

2008-05-29 Thread Andreas Berger



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.


Andreas

___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal