Difference between revisions of "Lazarus DB Faq/zh CN"

From Lazarus wiki
Jump to navigationJump to search
(Lazarus数据库FAQ)
 
Line 3: Line 3:
 
== 常规 ==
 
== 常规 ==
  
This FAQ will be directed to database programming with Lazarus.
+
这个FAQ将指导您用Lazarus编写数据库程序
 +
 
  
 
=== 哪里能找到更多的 FAQ? ===
 
=== 哪里能找到更多的 FAQ? ===
  
See the official website www.lazarus.freepascal.org. There is another FAQ as well. [[Lazarus Faq|Here]] you will find a page that once started as a copy of the FAQ from www.lazarus.freepascal.org .
+
请参看官方网站www.lazarus.freepascal.org.也有另一常见问题和答案.[[Lazarus Faq|Here]]你将发现a,页其从www.lazarus.freepascal.org一次开始阿斯一份常见问题和答案的.
  
 
=== 哪里能找到更多的数据库组件? ===
 
=== 哪里能找到更多的数据库组件? ===

Revision as of 19:02, 25 December 2008

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.也有另一常见问题和答案.Here你将发现a,页其从www.lazarus.freepascal.org一次开始阿斯一份常见问题和答案的.

哪里能找到更多的数据库组件?

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.

还有其它组件吗?

Yes. 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 (MySQL and Firebird)

IB / FB

我怎样从Linux连接到Windows服务器上呢?

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

哪一个版本的 mySQL被支持?

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 sourceforge:

http://pdo.sourceforge.net

Jan 30, 2007: PDO has added drivers for Firebird 1.5 and 2.0

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.