如何以及在哪里将数据库驱动程序安装到IDE中？第二部分 [英] How, and where to install a database driver into an IDE? Part II

问题描述

此查询的背景是这个问题。

我已经安装了此驱动程序（用于Firebird），并将其放置在IDE使用的路径（system32）内。 XE Data Explorer可以识别驱动程序，并且可以使用Data Explorer创建连接。尝试通过此连接查看表或任何其他数据库元素会导致该问题中所述的错误。据我所见，@ Alejandro Jourdan 尚未解决此问题，我找不到解决方案在任何支持Firebird或Delphi XE的支持网站上。

I have installed this driver for Firebird and placed it within the path (system32) used by the IDE. The XE Data Explorer recognises the driver, and it is possible to create a connection using the Data Explorer. Trying to view tables or any other database element through this connection results in the error described in this question. As far as I can see @Alejandro Jourdan has not obtained a solution to this problem, and I can find no solution on any of the support sites for Firebird or for Delphi XE.

第二个问题是当我使用此连接创建TSQLConnection时出现的。该连接在一定程度上可以生成数据库的登录提示，但是当它尝试打开连接时，我收到错误消息：'文件不是有效的数据库'该错误消息在一定范围内是可复制的。数据资源管理器，它给出以下错误：

The second problem comes when I create a TSQLConnection using this connection. The connection works to the extent that it generates the login prompt to the database, but when it tries to open the connection I get the error message: 'file is not a valid database' This error message is (sort of) reproducible from within the Data Explorer which gives the following error:

文件[数据库路径]的 CreateFile（open）操作期间I / O错误尝试打开文件时出错。访问被拒绝。

I/O error during "CreateFile(open)" operation for file [database path] Error while trying to open file. Access is denied..

该数据库有效，可以从Firebird命令行实用程序和数据库浏览器中打开。

The database is valid and can be opened from the Firebird command line utility, and from a Data Base browser.

环境：

Machine: Lenovo Thinkpad W510
OS: Windows 7 Ultimate 64bit
Delphi: Embarcadero® RAD Studio XE Professional Version 15.0.3953.35171
Database: W1-V2.5.0.26074 Firebird 2.5 (64 bit)

也已安装：

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

编辑：

在下面查看我自己的答案。此编辑已删除了广泛的细节，这些细节根据该答案被证明是不必要的，同时保留了问题的核心以及其中包含的链接。

See my own answer below. This edit has removed extensive detail that proves to be unnecessary in the light of that answer, while retaining the core of the question, and the links contained within it.

推荐答案

我（在第一部分中）遇到的基本问题是：

The basic question I had (in part I) was:

我要安装Firebird数据库
驱动程序，并使其在Delphi XE IDE中可用。我希望
数据库驱动程序可以在
的基础上与其他提供的数据库
驱动程序一起使用（例如，Interbase，SQL-来自IDE中数据浏览器中的
）。
我已经找到了合适的驱动程序。

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.

经过大量调查后，我发现无法实现集成我试图实现的Delphi IDE。这是因为数据资源管理器是.NET应用程序，并且具有可用的DBExpress驱动程序（此处和< a href = http://www.devart.com/dbx/ rel = nofollow>此处）与.NET不兼容。我了解可以通过在IDE中以及在要开发的应用程序中进行编程来适当设置参数来使用驱动程序。

After considerable investigation I have found that it is not possible to achieve the integration into the Delphi IDE that I was trying to achieve. This is because the Data Explorer is a .NET application and the available DBExpress drivers (here and here) are just not compatible with .NET. I understand that I can use the drivers by setting up the parameters appropriately, in both the IDE and by programming in the application I am developing.

我起草了这个答案，以帮助其他人避开这个特别的小巷。我也正在编辑第二部分的问题，以删除很多细节，根据这个答案，事实证明这是不必要的。

I have drafted this answer to assist others to avoid this particular blind alley. I am also editing the part II question in order to remove a lot of the detail, that proves to be unnecessary in the light of this answer.

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