Difference between revisions of "Lazarus DB Faq/ru"

From Free Pascal wiki
Jump to navigationJump to search
Line 14: Line 14:
 
Смотри [[Install Packages|сюда]] для помощи по установке пакетов.
 
Смотри [[Install Packages|сюда]] для помощи по установке пакетов.
  
=== Are there other components? ===
+
=== А есть другие компоненты? ===
  
Yes. The [http://zeoslib.sourceforge.net/index.php ZEOS components] have been ported to Lazarus as well.
+
Да. The [http://zeoslib.sourceforge.net/index.php ZEOS components] have been ported to Lazarus as well.
 
<br>You have to download ZEOSDBO_Rework from [http://sourceforge.net/cvs/?group_id=35994 ZEOS cvs].
 
<br>You have to download ZEOSDBO_Rework from [http://sourceforge.net/cvs/?group_id=35994 ZEOS cvs].
 
<br>See also this tutorial for [[Zeos_tutorial|Zeos]].
 
<br>See also this tutorial for [[Zeos_tutorial|Zeos]].

Revision as of 12:40, 5 December 2006

Deutsch (de) English (en) español (es) français (fr) italiano (it) 日本語 (ja) português (pt) русский (ru) slovenčina (sk) 中文(中国大陆)‎ (zh_CN)

Общее

Этот FAQ перенаправит вас на программирование баз данных с Lazarus.

Где я могу найти больше FAQ?

Смотри на официальном сайте www.lazarus.freepascal.org. Там есть еще один FAQ. Здесь вы найдете страницу, которая показана как копия FAQ с www.lazarus.freepascal.org.

Где я могу найти компоненты для баз данных?

В настоящее время компоненты SQLdb являются частью Lazarus, вам необходимо только установить его. Если вы посмотрите в каталог [$LazarusDir]/components, вы найдете каталог SQLdb. Установите sqldblaz.lpk и вы сможете подключаться к серверам MySQL, Interbase / Firebird и Postgres. Смотри сюда для помощи по установке пакетов.

А есть другие компоненты?

Да. The ZEOS components have been ported to Lazarus as well.
You have to download ZEOSDBO_Rework from ZEOS cvs.
See also this tutorial for Zeos.
Pascal Data Objects works equally with Delphi and FPC 2.0

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?

Currently MySQL 4.0, MySQL 4.1 and MySQL 5.0 are supported by de SQLdb components. Make sure you are using the correct connection component for your client library version. So if you have the client libraries installed for MySQL 4.1 then you have to use TMySQL41Connection component, even if the server is running version 4.0 or 5.0.

Pascal Data Objects

There is now an alternative. The functions introduced with MySQL 4.1 and 5.0 like prepared statements, binding, and stored procedures are supported by database API called Pascal Data Objects, which is inspired by PHP Data Objects. All the code and documentation necessary to use this new API is available on a Trac wiki:

https://trac.synsport.com:8000/index.php/pdo/wiki (username/password is guest/guest)

PostgreSQL

You can connect to PostgreSQL db by TPQConnection component. This component uses the PostgreSQL's libpq connection library[1], so you can easily connect almost every PostgreSQL db, but the component doesn't support the following connection options:

  • Port
  • ClientEncoding

Maybe there are other unsupported connection parameters.

--Jrmarino 11:28, 13 Mar 2006 (CET)