如何将数据库驱动程序安装到IDE中？ [英] How, and where to install a database driver into an IDE?

问题描述

我想安装一个Firebird数据库驱动程序，并在Delphi XE IDE中使用它。我希望数据库驱动程序在其他提供的数据库驱动程序（例如，Interbase，SQL - 从IDE中的数据资源管理器）的基础上可用。我已经获得了一个合适的驱动程序。

驱动程序包含一个Delphi项目，它编译为一个DLL;并修改两个.ini配置文件（dbxconnections.ini和dbxdrivers.ini）。我假设DLL是实际的驱动程序，我已经编译了这个项目没有问题。

我有这么远，这是我意识到我不知道安装新的数据库驱动程序涉及什么;将新数据库驱动程序安装到IDE中涉及到什么？也不需要安装元素。

所以我的问题是：
需要什么步骤才能将dbExpress数据库驱动程序安装到Borland XE Delphi专业IDE？

我不知道的一些具体要点包括 -

1. 我需要使用特定的注册程序才能完成注册？

/ li>

2. 安装的组件应该放在哪里？

所有四家供应商Embarcadero，Borland， UniOpen ，Firebird提供文档（大部分是非常全面的），但是我无法从中提取我需要做什么以及在哪里做。

我已经搜索了关于SO的多个问题，但是似乎从OP的基础开始，OP知道驱动程序安装涉及什么。

所有的产品（驱动程序除外）在多个位置生成多个文件，并不清楚哪些组件属于哪个位置。例如，我有两个配置文件的多个版本：

1. C：\Users\User\AppData .. ..


2. C：\Users\Public\Public Documents ...


3. C：\Program Files\Vendor .. ..


4. ....

此外，这些产品将文件安装到： p>

1. 注册表（多个键）;


2. C：\程序文件....; C：\程序文件（x86）....;


3. C：\Windows\System ....;


4. C：\Windows\System 32 .....


5. 可能更多。






环境：






• 机器：Lenovo Thinkpad W510


• 操作系统：Windows 7 Ultimate


• Delphi：Embarcadero®RAD Studio XE Version 15.0.3953.35171


• 数据库：W1-V2.5.0.26074 Firebird 2.5


• 数据库驱动程序：UniOpen Native DBX驱动程序






还安装：






• EmbarcadoBorland®Developer Studio 2006企业版10.0.2288.42451更新2（XP版本）


• Borland Delphi版本7 （XP版）






总结：





在Borland XE Delphi Professional IDE中安装dbExpress数据库驱动程序需要哪些步骤和位置？

解决方案

你错过了一个文件。 ：）





DataExplorer，从最好的我可以告诉，使用dbxdrivers.ini。我的安装XE具有该文件的单一副本，位于（Win7 64）C：\Users\Public\Documents\RAD Studio\8.0中。 DataExplorer中列出的连接类型来自该文件开头的已安装驱动程序列表，每个驱动程序都有一个或多个配置部分，该部分位于该列表之后。





配置部分列出的驱动程序文件必须存在于可访问的位置（像任何其他Windows DLL）由 LoadLibrary 。该链接中的文档解释了API函数搜索DLL的方式;基本上，IDE必须在PATH上找到它。





您的特定驱动程序的供应商或作者应该能够提供需要进入的信息dbxdrivers.ini文件。 （我不熟悉UniOpen，并且在这个特定的机器上没有FireBird）。IDE在启动过程中只读取该文件，所以在添加后，您需要（重新）启动IDE。 p>



这个在Embarcadero Delphi数据库中发布 - > DBExpress论坛可能有助于为Firebird数据库定义别名，并描述通过TSQLConnection组件进行连接。 （查找Ralph Horbury-Smith的帖子。）如果您没有开发人员网络ID，则需要在Embarcadero网站上注册;我提供的链接由于某些原因使用HTTPS。你也可以通过NNTP到他们的论坛;我没有使用新闻阅读器，所以我不知道地址是什么。在Embarcadero有一个此页面的连接信息链接。





还有一些信息可在Delphi XE文档Wiki页面上找到，可能也有帮助。





编辑：再找一个链接在您可能感兴趣的DBExpress论坛。它具有另一个FB DBExpress 驱动程序的链接以及该dbxdrivers.ini文件的特定信息司机。这是菲利普·弗洛雷斯（Phillip Flores）的帖子（约在页面上的第三个）。




I want to install a Firebird database driver, and to have it available within the Delphi XE IDE. I want the database driver to be usable on the same basis as other, supplied database drivers (eg Interbase, SQL - from within the Data Explorer in the IDE). I have obtained an appropriate driver.

The driver consists of a Delphi project, which compiles to a DLL; and modifications to two .ini configuration files (dbxconnections.ini and dbxdrivers.ini). I assume that the DLL is the actual driver, and I have compiled the project without problem.

I have got this far, and this is where I realised that I do not know what is involved in installing a new database driver; what is involved in installing a new database driver into an IDE; nor where the elements of the installation need to reside.

So my question is: What steps are needed to install a dbExpress database driver into the Borland XE Delphi Professional IDE?

Some of the specific points I don't know about include -

1. Does the driver need to be registered with all of Firebase, Delphi and Windows?
2. Do I need to employ a specific registration procedure to accomplish registration?
3. Are there any elements I am missing to accomplish my aim?
4. Where should the installed components be located?

All four vendors, Embarcadero, Borland, UniOpen, and Firebird provide documentation (most of which is very comprehensive) but I have been unable to extract from them what I need to do and where to do it.

I have searched multiple questions on SO, but all of seem to start from the basis that the OP knows what is involved in driver installation.

All the products (except the driver project) generate multiple files in multiple locations, and it is not clear what components belong where. For example, I have multiple versions of the two configuration files residing in:

1. C:\Users\User\AppData....
2. C:\Users\Public\Public Documents...
3. C:\Program Files\Vendor....
4. ....

In addition these products install files into:

1. the registry (multiple keys);
2. C:\Program Files....;
3. C:\Program Files (x86)....;
4. C:\Windows\System....;
5. C:\Windows\System 32.....
6. and probably more.

Environment:

• Machine: Lenovo Thinkpad W510
• OS: Windows 7 Ultimate
• Delphi: Embarcadero® RAD Studio XE Version 15.0.3953.35171
• Database: W1-V2.5.0.26074 Firebird 2.5
• Database Driver: UniOpen Native DBX Driver

Also Installed:

• Embarcado Borland® Developer Studio 2006 Enterprise Version 10.0.2288.42451 Update 2 (XP Version)
• Borland Delphi Version 7 (XP Version)

In summary:

What steps and locations are needed to install a dbExpress database driver into the Borland XE Delphi Professional IDE?

解决方案

You missed a file. :)

DataExplorer, from the best I can tell, uses dbxdrivers.ini. My installation of XE has a single copy of that particular file, located (Win7 64) in C:\Users\Public\Documents\RAD Studio\8.0. The connection types listed in DataExplorer come from the list of installed drivers at the beginning of that file, and each driver has one or more configuration sections which follow that list.

The driver files listed in the configuration section have to exist in a location findable (like any other Windows DLL) by LoadLibrary. The documentation in the link explains the way the API function searches for DLLs; basically though, the IDE has to find it somewhere on the PATH.

The vendor or author of your particular driver should be able to provide the info that needs to go in the dbxdrivers.ini file. (I'm not familiar with UniOpen personally, and don't have FireBird on this particular machine.) The IDE only reads that file during startup, so you'll need to (re)start the IDE after making the additions.

This post at the Embarcadero Delphi Database->DBExpress forum may help with defining aliases for your Firebird databases, and describes connecting via the TSQLConnection component. (Look for a post by Ralph Horbury-Smith.) If you don't have a Developer's Network ID, you'll need to register with the Embarcadero site; the link I provided uses HTTPS for some reason. You can also get to their forums via NNTP; I'm not using a newsreader, so I'm not sure what the address would be. There's a link to connection info on this page at Embarcadero.

There's also some information available on the Delphi XE documentation Wiki pages that might help as well.

EDIT: Found one more link at the DBExpress forums that might interest you. It has a link for another FB DBExpress driver and specific information for the dbxdrivers.ini file for that driver. It's the post by Phillip Flores (about the 3rd one down on the page).

这篇关于如何将数据库驱动程序安装到IDE中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！