Subject | Re: [firebird-support] Re: ConnString for VFP works on and off (Connection handle is invalid.) |
---|---|
Author | Gabor Boros |
Post date | 2009-07-20T15:49:27Z |
Hi,
Try connect on the server with local connection.
If the connection working try connect with SERVERNAME:ALIASNAME or
IPADDRESS:ALIASNAME.
I never used " for the aliases.
In example:
TEST_ALIAS = C:\Program Files\My App\DB\DATABASE.FDB
Gabor
Bhavbhuti Nathwani írta:
Try connect on the server with local connection.
If the connection working try connect with SERVERNAME:ALIASNAME or
IPADDRESS:ALIASNAME.
I never used " for the aliases.
In example:
TEST_ALIAS = C:\Program Files\My App\DB\DATABASE.FDB
Gabor
Bhavbhuti Nathwani írta:
> Hi Gabor
>
> Thanks for your response. I have this as the simple test case in aliases.conf:
> C17_18181 = "D:\C17\DATA\VSO3.FDB"
>
> Yet I cannot connect from the client to this alias. I have removed (including the folder) and reinstalled FireBird on both the server and client one by one yet no joy.
>
> Firewall: I have made no changes to the firewall and I have been able to connect very regularly and consistently to the server from the client when I had been using ODBC. Since I converted to using Connection Strings the same configurations started to fall apart. Now that I have switched back to ODBC I have not been able to regain connections as before
>
> And this loss of connection using Connect Strings happened not only in the development computer but on user-site too.
>
> Kind regards.
> Bhavbhuti