Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-pascal / 2008-05

Connecting SQL components to a propriety SQL server

3 messages · 2 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

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?

I'm sorry if the question may be unclear, but I don't know enough about SQL to ask more specifically. Maybe during the progress of this thread I can up my understanding and ask better questions :)

Regards,
Andreas

Michael Van Canneyt
to Andreas Berger
Andreas Berger wrote 8 lines
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.

Andreas Berger
to Michael Van Canneyt
Show quoted text 16 lines
> 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