Lazarus DB Faq

From Lazarus wiki
Jump to navigationJump to search

General

This FAQ will be directed to database programming with Lazarus.

Where can I find more FAQ?

See the official website www.lazarus.freepascal.org. There is another FAQ as well. Here you will find a copy of the FAQ from www.freepascal.org .

Where can I find database components?

At the moment the SQLdb components are part of the Lazarus package, you only need to install them. If you look in the [$LazarusDir]/components you will see a subdirectory SQLdb. Install the sqldblaz.lpk and you will be able to connect to MySQL, Interbase / Firebird and Postgres servers. Look here for help on installing packages.

IB / FB

How do I connect from Linux to a Windows server

Entering the correct path to a database on a Windows server from a Linux client is not very clear. Say you have installed firebird in F:\Program Files\firebird\. The employee.fdb example database will then be installed in the directory F:\Program Files\firebird\examples\ . The IP-adress of your computer is 192.168.2.100. Then entering the following databasename

192.168.2.100:F:\Program Files\firebird\examples\employee.fdb

in your IBConnection will connect to the required database. Note that you don't have to enter a value for the hostname property!

MySQL

MS SQL