[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Firebird ODBC mapped drive

Posted on 2010-01-05
4
Medium Priority
?
1,214 Views
Last Modified: 2013-12-09
I am trying to set up an ODBC connection to a Firebird 2.1 database on a mapped drive using IBPhoenix 2.0 on windows 7. upon entering all of the information, I recieve a message telling me that the open database action failed. I have entered all of the required information, name, database path, gds32.dll, username as SYSDBA and password as "masterkey" charset as WIN1251,

Using all of the same details on a connection to a local database, the connection is succesful.

Any help would be appreciated,

Many thanks,

Keith
0
Comment
Question by:kalees
  • 2
  • 2
4 Comments
 
LVL 19

Expert Comment

by:NickUpson
ID: 26185265
This will not work, by design firebird will NOT connect to database on a mapped drive

you should install firebird server on the PC hosting the drive and then connect to it via that server process
0
 

Author Comment

by:kalees
ID: 26203138
hi NickUpson, to my knowledge we have firrebird server on the host server, how would I go about connecting to that server process to enable a connection to Crystal reports 2008?

Keith
0
 
LVL 19

Accepted Solution

by:
NickUpson earned 2000 total points
ID: 26204957
your method using odbc is fine,

on the client PC create an odbs dsn where the path to the database is something like
"serverpc::c:/databases/db.fdb"
0
 

Author Comment

by:kalees
ID: 26207914
That has worked a treat, many thanks, well deserved points.

Keith
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What we learned in Webroot's webinar on multi-vector protection.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question