Windows应用程序安装项目与Firebird数据库 [英] windows application setup project with firebird database

问题描述

大家好，

我已经开发了一个带有Firebird数据库的小型Windows应用程序.并且我已经创建了设置和部署项目，以将我的应用程序安装到其他系统中.
当我在系统中安装安装文件时，它可以正常工作，但是当我在其他系统中安装时，它却无法工作，则在连接数据库时出现了一些错误.
所以，请朋友给我一些解决这个问题的方法
Winforms应用程序c#.net和数据库Firebird 2.5.

Hi All,

I had developed a small windows application with firebird database. and I had created the setup and deployment project to install my application in other systems.
When I installed the setup file in my system its working fine but when I installed in others system its not working getting some error in connecting to the database.
so, friends please send me some solution to this problem
winforms applcation c#.net And Database Firebird 2.5.

推荐答案

据我了解，您希望客户端和服务器位于同一台计算机上.在这种情况下:
1)在客户端上部署功能完善的FB并没有多大意义.有一个嵌入式(ServerType = 1)的FB版本(请阅读这有点过时了文章以获取概述).
2)您如何准确地执行FB部署?您确定服务已启动吗?您是否已检查客户端，例如可以使用 FlameRobin 使用相同的参数进行连接?
3)由于反斜杠是转义字符，因此请确保使用正确的c#字符串文字:connectionString=@"...或加倍退格.
4)使用ServerType = 0时，您必须在连接字符串中指定服务器名称(在您的情况下为localhost).请参阅:数据源属性，网址为: http://connectionstrings.com/firebird#p57 .仅对于嵌入式服务器可以省略.
5)确保运行成熟或嵌入式服务器的用户具有对该文件的读/写访问权限.
如果我有误解，并且客户端和服务器位于不同的计算机上，则根本不需要部署原始FB软件包(

As I understood, you want the client and the server on the same machine. In this case:
1) Deploying a full-blown FB on a client makes not much sense. There is an embedded (ServerType=1) edition of FB (read this little bit outdated article to get an overview).
2) How exactly do you perform the FB deployment? Are you sure, that the service is started? Have you checked on the client that you can connect with the same parameters using FlameRobin for example?
3) As backslash is an escape character, be sure to use proper c# string literal: connectionString=@"... or double the backspaces.
4) With ServerType=0 you have to specify the server name in the connection string (localhost in your case). See: DataSource property here: http://connectionstrings.com/firebird#p57. This can be omitted only with embedded server.
5) Be sure that the user running the full-blown or embedded server has r/w access to the file.
If I have misunderstood, and client and server are on different machines, than you do not need to deploy the original FB package at all (http://www.firebirdsql.org/en/firebird-net-provider-faq/#6[^]), but all other considerations still stand.

+1) If none of this helps, the exact text of the exception would be also helpfull...

这篇关于Windows应用程序安装项目与Firebird数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！