{“ERROR [08004] [ODBC firebird driver]unavailable database”} ask

Question

1.00/5 (1 vote)

See more:

Have an odbc conenction, to connect to a WMS database (I believe they support odbc only) and on connection open gets the exception {"ERROR [08004] [ODBC Firebird Driver]unavailable database"}. The WMS Server & Client components are installed on the machine where my code also runs. Conenction string below

"DRIVER=Firebird/InterBase(r) driver; UID=SYSADMIN; PWD=MASTERKEY; DBNAME=C:\Sample\Db.FDB;"

I am clueless on how to proceed. Some of the already seen answers says, only one application can access the db at a time or so. In that case how I find who else trying to access this db and stop?

My application is a windows forms application and now the code runs in debug mode.

Thanks
Nishitha

What I have tried:

Tried on another machine in a different network, where WMS is installed correctly on a different machine in the network. There as well connection fails.

Posted 1-Feb-18 19:59pm

nairnishitha

Updated 8-Feb-18 1:25am

Add a Solution

2 solutions

Solution 1

You have to install Firebird: ODBC Driver[^]

Posted 2-Feb-18 9:07am

Maciej Los

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)

nairnishitha · Accepted Answer · 2018-02-08T01:25:00

Solution 2

Had to prefix dbpath with 'localhost:' and password was in lower case. That helped me to connect. But since I had to get schema info, which was limited in ODBC, moved to using FireBirdClient, that is Firebird Ado.Net provider.

Posted 8-Feb-18 1:25am

nairnishitha