Difference between revisions of "Lazarus DB Faq/de"

From Lazarus wiki
Jump to navigationJump to search
Line 34: Line 34:
  
 
If you use the SQLdb components you will need the client libraries for mySQL 4.0. With this libraries you can connect to mySQL 3.2x and 4.x servers.
 
If you use the SQLdb components you will need the client libraries for mySQL 4.0. With this libraries you can connect to mySQL 3.2x and 4.x servers.
 +
 +
== MS SQL ==

Revision as of 18:54, 24 August 2005

Allgemein

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.

Are there other components?

Yes. The ZEOS components have been ported to Lazarus as well. You have to download ZEOSDBO_Rework from ZEOS cvs.

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

Which version of mySQL is supported?

If you use the SQLdb components you will need the client libraries for mySQL 4.0. With this libraries you can connect to mySQL 3.2x and 4.x servers.

MS SQL