Subject Re: [firebird-support] Re: UNAVAILABLE DATABASE...
Author Sam Hunt
Svein Erling Tysvær wrote:

>--- In firebird-support@yahoogroups.com, Sam Hunt <shunt@n...> wrote:
>
>
>>Helen Borrie wrote:
>>
>>
>>
>>>At 12:37 AM 28/05/2005 +0000, you wrote:
>>>
>>>
>>>
>>>
>>>>I just installed SS 152 4731 on a server running XP and I get this
>>>>error when I run my D7/ADO app against the DBs. Every other
>>>>aspect of this install is exactly the same as the dev pc. (DS
>>>>names/definitions, etc.) The connection string is U:\MyDatabase.
>>>>fdb, where "U" is a mapped network drive pointing to a "D"
>>>>partition on my local drive.
>>>>
>>>>
>>>This is your problem. You can't connect to a mapped drive AT ALL.
>>>The connection string must be an absolute file path as seen locally
>>>by the server.
>>>
>>>
>>>
>>>>"U" is a partition on the new app pc. The ODBC manager test
>>>>connection worked fine on both machines using TCPIP.
>>>>
>>>>
>>>If "U:" is ***also*** a partition designation on the server (i.e.
>>>not a mapping to a partition that has a different name) then the
>>>correct TCP/IP string for remote connections will be:
>>>
>>>servername:U:\absolute\path\to\database\MyDatabase.fdb
>>>
>>>
>>>
>>>>I had this exact same problem on a laptop and a workstation here
>>>>at work, and solved it by rebooting the machines.
>>>>
>>>>
>>I think I provided TMI. The machine I am having trouble with uses a
>>partition drive U (not a mapped drive) for FB152 4731 and the app.
>>However, I still got the "UNAVAILABLE DATABASE" error. Like I
>>stated in my first post, I have experienced this error three times
>>b4 (not immediately after an install, but on machines that had
>>successfully run FB against this same app) and rebooting the pcs
>>solved the problem. Why, I do not know. These 3 problem pcs were
>>all running FB and the app from their own drv C.
>>Sam H.
>>
>>
>
>Could it be due to file system backup or virus scanning at the time
>you try to connect to the database (or worse, a restore taking place)?
>Just a wild guess, I've no reason for asking this.
>
>Set
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
Thx to all who responded.
Our team solved this problem and I will be posting a brief explanation
of our solution soon for all to use.
Thx again.
Sam H.