windows application setup project with firebird database

Question

0.00/5 (No votes)

See more:

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.

Posted 13-Jul-12 6:47am

SubrahmanyamGurram

Add a Solution

Comments

[no name] 13-Jul-12 12:54pm

Don't you think that when asking for help for something that "some error" is not at all helpful? How are we to know what "some error" means? Don't you think that it's kind of important information?

SubrahmanyamGurram 13-Jul-12 13:08pm

Sorry , Wes Aday,I am unable to check what is error but its not able to connect to database. In my application I had taken username and password, passed to the connection object. But Unable to open the connection this is my problem. this problem is raising when I Install my application in a new system.

Zoltán Zörgő 13-Jul-12 15:07pm

First of all, do you deploy the FB engine also? Or only the client? In the later case are you deploying all necessary files? How your connection string looks like? And what exactly is the exception you get?

SubrahmanyamGurram 14-Jul-12 3:01am

Hi, Thanks for the reply again, i had installed FB Server in the client system, and In my connection string passing values like connectionString="Database=D:\fsi\fms\fms.fdb; Pooling=true; MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0; and username, password and role. and I am checking the connection is opened or not by passing the username, password and role from the UI form.In this case the connection was not opened.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Accepted Answer · 2012-07-13T21:32:00

Solution 1

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...

Posted 13-Jul-12 21:32pm

Zoltán Zörgő

Updated 14-Jul-12 7:38am

v2

Comments

SubrahmanyamGurram 14-Jul-12 3:35am

i will make these chenges into my application and i will give my feed back
thanks Zoltan

Zoltán Zörgő 16-Jul-12 2:14am

Any progress?

SubrahmanyamGurram 16-Jul-12 2:26am

No yaar, getting struck there. i am unable find the what is an exception raised?

SubrahmanyamGurram 16-Jul-12 3:42am

Hi Zoltan, can you please help me, which firebird database can i use for my application so that clients must do not install the database means server installation process.

Zoltán Zörgő 16-Jul-12 9:42am

In the case when users do not connect to any remote server, only use a database on the client machine, you can use the embedded version

SubrahmanyamGurram 16-Jul-12 9:45am

Hi Zoltan , can you please check this one.
http://www.codeproject.com/Questions/422367/Getting-Error-when-installing-my-application-Statu

SubrahmanyamGurram 16-Jul-12 10:20am

Hi Zoltan , can you please check this one.

FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Unable to complete network request to host "localhost". ---> Unable to complete network request to host "localhost".
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create()
at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut()
at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
at FMS.FMSContainer.FMSContainer_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

I got this error when I install my application in a new system.

Zoltán Zörgő 16-Jul-12 13:59pm

Ok. Please answer following questions with yes or no:
- have you installed a full-blown FB on together with your application?
If yes:
- have you checked that the service is running and listening on the port 3050?
- have you checked with a client app like flamerobin, that you can access the server and database?

SubrahmanyamGurram 17-Jul-12 2:02am

- have you installed a full-blown FB on together with your application?
Yes

If yes:
- have you checked that the service is running and listening on the port 3050?
No

- have you checked with a client app like flamerobin, that you can access the server and database?
No

Zoltán Zörgő 17-Jul-12 4:01am

Than check these first, and let's see the results.

SubrahmanyamGurram 19-Jul-12 6:29am

thanks zoltan, for helping me. the task had completed. ;)