Subject | Re: [firebird-support] problem connecting to database on remote server |
---|---|
Author | Tony Christiansen |
Post date | 2019-07-03T14:41:17Z |
Hi Rustam
With that syntax even the connection to the C: drive fails (Server is Windows 10)
SQL> CONNECT \\ADE-VM\C:\T\CASHMANAGER.FDB user SYSDBA password masterkey;
Database: \\ADE-VM\C:\T\CASHMANAGER.FDB, User: SYSDBA
SQL> CONNECT ADE-VM:C:\T\CASHMANAGER.FDB user SYSDBA password masterkey;
Commit current transaction (y/n)?n
Rolling back work.
Statement failed, SQLSTATE = 08006
Unable to complete network request to host "ADE-VM".
-Failed to establish a connection.
SQL>
With that syntax even the connection to the C: drive fails (Server is Windows 10)
SQL> CONNECT \\ADE-VM\C:\T\CASHMANAGER.FDB user SYSDBA password masterkey;
Database: \\ADE-VM\C:\T\CASHMANAGER.FDB, User: SYSDBA
SQL> CONNECT ADE-VM:C:\T\CASHMANAGER.FDB user SYSDBA password masterkey;
Commit current transaction (y/n)?n
Rolling back work.
Statement failed, SQLSTATE = 08006
Unable to complete network request to host "ADE-VM".
-Failed to establish a connection.
SQL>
On 4/07/2019 12:25 am, Rustam
rustam-m@... [firebird-support] wrote:
Remote connection string must look like:
"ADE-VM:E:\T\CASHMANAGER.FDB"
3 липня 2019, 17:16:05, від "Tony Christiansen tony@... [firebird-support]" <firebird-support@yahoogroups.com>:
Hi all
I have firebird 3 installed on a server ADE-VM
I run isql from my machine and connect to a test database on C: without
error
But when I try to connect to a copy of the test database on E: it gives
the following error.
I do not know why the drive makes a difference. The firebird.conf file
has databaseaccess=full (default)
I can open both databases on the remote server itself.
Thanks for any assistance
Tony
SQL> CONNECT \\ADE-VM\C:\T\CASHMANAGER.FDB user SYSDBA password masterkey;
Database: \\ADE-VM\C:\T\CASHMANAGER.FDB, User: SYSDBA
SQL> CONNECT \\ADE-VM\E:\T\CASHMANAGER.FDB user SYSDBA password masterkey;
Commit current transaction (y/n)?n
Rolling back work.
Statement failed, SQLSTATE = 08006
Unable to complete network request to host "E".
-Failed to locate host machine.
-The specified name was not found in the hosts file or Domain Name Services.