Re: [firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Oscar Darío Perdiguero d.perdigu...@yahoo.com.ar [firebird-support] 
//This is a google translation

Hello Eduardo, in my case what happened was that the path variable of 
the windows operating system was not updated to the folder where I had 
firebird and on the other hand, depending on the client, I should put 
gds32.dll in that folder and / or fbclient.dll too to make sure that any 
software could access them.

Regards

Dar?o

//Este es el texto original en espa?ol

Hola Eduardo, en mi caso lo que pasaba es que la variable path del 
sistema operativo windows no estaba actualizada a la carpeta donde yo 
ten?a firebird y por otro lado, dependiendo del cliente, deb?a poner 
gds32.dll en esa carpeta y/o fbclient.dll tambi?n para asegurarme que 
cualquier software pudiera accederlos.

Saludos

Dar?o

El 20/2/2018 a las 10:57, Eduardo guse...@gmail.com [firebird-support] 
escribi?:
>
> Hello:
>
> I use Firebird 2.1 and in some computers I cannot open a database file 
> which is in the local hard disk.
>
> For example, let's suppose I have the database C:\Test\MYDATABASE.FDB 
> and I try to open it with IB_SQL (from IBObjects).
>
> If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
> If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable database".
> If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable database".
>
> If I modify firebird.conf creating the alias 
> MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can open 
> the database.
>
> In almost every computer with any Windows version (XP, 7, 10, 2003, 
> 2008, 2012, 2016) I can open the database using every one of the four 
> methods, but in some computers the first three methods return 
> "unavailable database" and I can open the database only using an 
> alias. Now I am having the problem in a computer with Windows Server 
> 2008 R2 Standard with Service Pack 1, but I remember having this 
> problem in other computers from time to time.
>
> Any ideas of which may be the reason? ... and the solution?
>
> Thanks in advance. Regards
>
> Eduardo
>
>
> 
>  
>   Libre de virus. www.avast.com 
> 
>  
>
>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>

Re: [firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Marsupilami79 marsupilam...@gmx.de [firebird-support] 
Hello Eduardo,

you might want to check the setting DatabaseAccess in firebird.conf. If
it is set to None or Restrict for some reason the behaviour you describe
can happen.

Best regards,

Jan

Am 20.02.2018 um 14:57 schrieb Eduardo guse...@gmail.com [firebird-support]:
>  
>
> Hello:
>
> I use Firebird 2.1 and in some computers I cannot open a database file
> which is in the local hard disk.
>
> For example, let's suppose I have the database C:\Test\MYDATABASE.FDB
> and I try to open it with IB_SQL (from IBObjects).
>
> If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
> If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable database".
> If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable database".
>
> If I modify firebird.conf creating the alias
> MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can open
> the database.
>
> In almost every computer with any Windows version (XP, 7, 10, 2003,
> 2008, 2012, 2016) I can open the database using every one of the four
> methods, but in some computers the first three methods return
> "unavailable database" and I can open the database only using an
> alias. Now I am having the problem in a computer with Windows Server
> 2008 R2 Standard with Service Pack 1, but I remember having this
> problem in other computers from time to time.
>
> Any ideas of which may be the reason? ... and the solution?
>
> Thanks in advance. Regards
>
> Eduardo
>
>
> 
>   Libre de virus. www.avast.com
> 
>
>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>

Re: [firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
20.02.2018 0:31, Eduardo guse...@gmail.com [firebird-support] wrote:
> If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
> If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable database".
> If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable database".
> 
> If I modify firebird.conf creating the alias 
> MYDATABASE=C:\Test\MYDATABASE.FDB, then using 
> MYDATABASE I can open the database.

   Check that disk letter you used is really "C" and not just something that 
looks 
similar, like, for example, "С".


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 
Yes, I tried indicating the name or IP of the server but it didn't work. 
The only way to open the databases is using an alias.



 Mensaje original 
*Asunto: *Re: [firebird-support] Cannot open database file in local hard 
disk
*De: *Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] 
<firebird-support@yahoogroups.com>

*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 12:29

Hello,

Did you try some thing like this :

IBODatabase1.Path := your GDB or FDB filename with path...;

IF SERVER_<>'' then // NAME or IP of  the server
   IBODatabase1.Server:=SERVER_ else
IBODatabase1.Server:=PC_NAME; //localhost
if not IBODatabase1.Connected then
   IBODatabase1.Connect;

(using SYSDBA and masterkey.. or user)

Best Regards,
MLCVISTA


Le ‎mardi‎ ‎20‎ ‎février‎ ‎2018‎ ‎16‎:‎09‎:‎33‎ ‎CET, Eduardo 
guse...@gmail.com [firebird-support] 
<firebird-support@yahoogroups.com> a écrit :



Thanks for your suggestion.

The user have total control of the file and the folder. I can modify 
it and even delete it. I tried moving the file to other folders and I 
tried with many FDB files. If I copy the FDB to another computer with 
Firebird, then I can open it without any problem. So the problem seems 
to be related to the computer.


I use Firebird 2.1 since many years ago and it works well. That's why 
I didn´t change it already.



 Mensaje original ----
*Asunto: *[firebird-support] Cannot open database file in local hard disk
*De: *Rustam rusta...@ukr.net <mailto:rusta...@ukr.net> 
[firebird-support] <firebird-support@yahoogroups.com> 
<mailto:firebird-support@yahoogroups.com>
*A: *firebird-support@yahoogroups.com 
<mailto:firebird-support@yahoogroups.com>

*Fecha: *20/02/2018 11:09


1) Check user access rights on DB folder/file and account, under 
which Firebird server is running

2) Why you don't use latest 2.5.8 version of Firebird?




alt 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 
	Libre de virus. www.avast.com 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 



<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>





---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

[firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 

Hello:

I use Firebird 2.1 and in some computers I cannot open a database file 
which is in the local hard disk.


For example, let's suppose I have the database C:\Test\MYDATABASE.FDB 
and I try to open it with IB_SQL (from IBObjects).


If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable database".

If I modify firebird.conf creating the alias 
MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can open the 
database.


In almost every computer with any Windows version (XP, 7, 10, 2003, 
2008, 2012, 2016) I can open the database using every one of the four 
methods, but in some computers the first three methods return 
"unavailable database" and I can open the database only using an alias. 
Now I am having the problem in a computer with Windows Server 2008 R2 
Standard with Service Pack 1, but I remember having this problem in 
other computers from time to time.


Any ideas of which may be the reason? ... and the solution?

Thanks in advance. Regards

Eduardo



---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Helen Borrie hele...@iinet.net.au [firebird-support] 

>  I use Firebird 2.1 and in some computers I cannot open a  
> database file which is in the local hard disk.
>   
>  For example, let's suppose I have the database
> C:\Test\MYDATABASE.FDB and I try to open it with IB_SQL (from
> IBObjects).
>   
>  If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
>  If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable
>  database".
>  If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable  
>database".
>   
>  If I modify [firebird.conf] aliases.conf creating the alias
> MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can   open the 
> database.

This is the intended behaviour if you have DatabaseAccess = None
configured in firebird.conf.

HB

Re: [firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] 
 Hello,
Did you try some thing like this :
IBODatabase1.Path := your GDB or FDB filename with path...;
IF SERVER_<>'' then // NAME or IP of  the server
   IBODatabase1.Server:=SERVER_ else
            IBODatabase1.Server:=PC_NAME; //localhost  if not 
IBODatabase1.Connected then
   IBODatabase1.Connect;
(using SYSDBA and masterkey.. or user)
Best Regards,MLCVISTA

Le ‎mardi‎ ‎20‎ ‎février‎ ‎2018‎ ‎16‎:‎09‎:‎33‎ ‎CET, Eduardo 
guse...@gmail.com [firebird-support] <firebird-support@yahoogroups.com> a écrit 
:  
 
     
 

Thanks for your suggestion.
 
 The user have total control of the file and the folder. I can modify it and 
even delete it. I tried moving the file to other folders and I tried with many 
FDB files. If I copy the FDB to another computer with Firebird, then I can open 
it without any problem. So the problem seems to be related to the computer.
 
 I use Firebird 2.1 since many years ago and it works well. That's why I didn´t 
change it already.
 
 
  Mensaje original ----
 Asunto: [firebird-support] Cannot open database file in local hard disk
 De: Rustam rusta...@ukr.net [firebird-support] 
<firebird-support@yahoogroups.com>
 A: firebird-support@yahoogroups.com
 Fecha: 20/02/2018 11:09
  
    
1) Check user access rights on DB folder/file and account, under which Firebird 
server is running
 2) Why you don't use latest 2.5.8 version of Firebird?
 
  
 
 
 
|  | Libre de virus. www.avast.com  |

   #yiv3964543233 #yiv3964543233 -- #yiv3964543233ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3964543233 
#yiv3964543233ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3964543233 
#yiv3964543233ygrp-mkp #yiv3964543233hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3964543233 #yiv3964543233ygrp-mkp #yiv3964543233ads 
{margin-bottom:10px;}#yiv3964543233 #yiv3964543233ygrp-mkp .yiv3964543233ad 
{padding:0 0;}#yiv3964543233 #yiv3964543233ygrp-mkp .yiv3964543233ad p 
{margin:0;}#yiv3964543233 #yiv3964543233ygrp-mkp .yiv3964543233ad a 
{color:#ff;text-decoration:none;}#yiv3964543233 #yiv3964543233ygrp-sponsor 
#yiv3964543233ygrp-lc {font-family:Arial;}#yiv3964543233 
#yiv3964543233ygrp-sponsor #yiv3964543233ygrp-lc #yiv3964543233hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3964543233 
#yiv3964543233ygrp-sponsor #yiv3964543233ygrp-lc .yiv3964543233ad 
{margin-bottom:10px;padding:0 0;}#yiv3964543233 #yiv3964543233actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3964543233 
#yiv3964543233activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3964543233
 #yiv3964543233activity span {font-weight:700;}#yiv3964543233 
#yiv3964543233activity span:first-child 
{text-transform:uppercase;}#yiv3964543233 #yiv3964543233activity span a 
{color:#5085b6;text-decoration:none;}#yiv3964543233 #yiv3964543233activity span 
span {color:#ff7900;}#yiv3964543233 #yiv3964543233activity span 
.yiv3964543233underline {text-decoration:underline;}#yiv3964543233 
.yiv3964543233attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3964543233 .yiv3964543233attach div a 
{text-decoration:none;}#yiv3964543233 .yiv3964543233attach img 
{border:none;padding-right:5px;}#yiv3964543233 .yiv3964543233attach label 
{display:block;margin-bottom:5px;}#yiv3964543233 .yiv3964543233attach label a 
{text-decoration:none;}#yiv3964543233 blockquote {margin:0 0 0 
4px;}#yiv3964543233 .yiv3964543233bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3964543233 
.yiv3964543233bold a {text-decoration:none;}#yiv3964543233 dd.yiv3964543233last 
p a {font-family:Verdana;font-weight:700;}#yiv3964543233 dd.yiv3964543233last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3964543233 
dd.yiv3964543233last p span.yiv3964543233yshortcuts 
{margin-right:0;}#yiv3964543233 div.yiv3964543233attach-table div div a 
{text-decoration:none;}#yiv3964543233 div.yiv3964543233attach-table 
{width:400px;}#yiv3964543233 div.yiv3964543233file-title a, #yiv3964543233 
div.yiv3964543233file-title a:active, #yiv3964543233 
div.yiv3964543233file-title a:hover, #yiv3964543233 div.yiv3964543233file-title 
a:visited {text-decoration:none;}#yiv3964543233 div.yiv3964543233photo-title a, 
#yiv3964543233 div.yiv3964543233photo-title a:active, #yiv3964543233 
div.yiv3964543233photo-title a:hover, #yiv3964543233 
div.yiv3964543233photo-title a:visited {text-decoration:none;}#yiv3964543233 
div#yiv3964543233ygrp-mlmsg #yiv3964543233ygrp-msg p a 
span.yiv3964543233yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3964543233 
.yiv3964543233green {color:#628c2a;}#yiv3964543233 .yiv3964543233MsoNormal 
{margin:0 0 0 0;}#yiv3964543233 o {font-size:0;}#yiv3964543233 
#yiv3964543233photos div {float:left;width:72px;}#yiv3964543233 
#yiv3964543233photos div div {border:1px solid 
#

Re: [firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 

Thanks for your suggestion.

The user have total control of the file and the folder. I can modify it 
and even delete it. I tried moving the file to other folders and I tried 
with many FDB files. If I copy the FDB to another computer with 
Firebird, then I can open it without any problem. So the problem seems 
to be related to the computer.


I use Firebird 2.1 since many years ago and it works well. That's why I 
didn´t change it already.



 Mensaje original 
*Asunto: *[firebird-support] Cannot open database file in local hard disk
*De: *Rustam rusta...@ukr.net [firebird-support] 
<firebird-support@yahoogroups.com>

*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 11:09


1) Check user access rights on DB folder/file and account, under which 
Firebird server is running

2) Why you don't use latest 2.5.8 version of Firebird?






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

[firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Rustam rusta...@ukr.net [firebird-support] 
1) Check user access rights on DB folder/file and account, under which Firebird 
server is running
2) Why you don't use latest 2.5.8 version of Firebird?

[firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Eduardo guse...@gmail.com [firebird-support] 

Hello:

I use Firebird 2.1 and in some computers I cannot open a database file 
which is in the local hard disk.


For example, let's suppose I have the database C:\Test\MYDATABASE.FDB 
and I try to open it with IB_SQL (from IBObjects).


If I use C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use SERVERNAME:C:\Test\MYDATABASE.FDB I get "unavailable database".
If I use \\SERVERNAME\C:\Test\MYDATABASE.FDB I get "unavailable database".

If I modify firebird.conf creating the alias 
MYDATABASE=C:\Test\MYDATABASE.FDB, then using MYDATABASE I can open the 
database.


In almost every computer with any Windows version (XP, 7, 10, 2003, 
2008, 2012, 2016) I can open the database using every one of the four 
methods, but in some computers the first three methods return 
"unavailable database" and I can open the database only using an alias. 
Now I am having the problem in a computer with Windows Server 2008 R2 
Standard with Service Pack 1, but I remember having this problem in 
other computers from time to time.


Any ideas of which may be the reason? ... and the solution?

Thanks in advance. Regards

Eduardo



---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus