Subject | Remote connections |
---|---|
Author | Brad Pepers |
Post date | 2001-02-27T23:35:41Z |
How do I connect to a remote Windows database from Linux using isql? I'm
hung up on the way to specify the remote database. The database exists on a
system I can ping called "windows" and the filename is C:\Quasar\Test1.gdb.
I've tried these commands:
isql -u sysdba -p masterkey windows:C:\Quasar\test1.gdb
isql -u sysdba -p masterkey windows:C:/Quasar/test1.gdb
isql -u sysdba -p masterkey windows:\Quasar\test1.gdb
isql -u sysdba -p masterkey windows:/Quasar/test1.gdb
When I have the C: in the path, I get this error:
Statement failed, SQLCODE = -902
Unable to complete network request to host "C".
-Failed to locate host machine.
When I don't have that I get errors like this:
Statement failed, SQLCODE = -902
I/O error for file "\Quasar\test1.gdb"
-Error while trying to open file
-No such file or directory
I've spent the last hour looking through the Interbase manuals and couldn't
find many examples that showed connections to remote systems and none that
had how to specify the path to a Windows database. If this is in the manuals
somewhere, I can't find it!
It works fine in reverse. I can connect from the Windows system to a
database on the linux system using just dragon:/tmp/test.gdb (where dragon is
the hostname of the Linux system).
I'm using the latest Firebird CS for Windows and Linux, Windows 98 for the
Windows system and Mandrake 7.2 for the Linux system. I figure there is some
trick to entering in a path to a Windows system without it trying to use it
as a node name but I don't know how to do it!
--
Brad Pepers
brad@...
hung up on the way to specify the remote database. The database exists on a
system I can ping called "windows" and the filename is C:\Quasar\Test1.gdb.
I've tried these commands:
isql -u sysdba -p masterkey windows:C:\Quasar\test1.gdb
isql -u sysdba -p masterkey windows:C:/Quasar/test1.gdb
isql -u sysdba -p masterkey windows:\Quasar\test1.gdb
isql -u sysdba -p masterkey windows:/Quasar/test1.gdb
When I have the C: in the path, I get this error:
Statement failed, SQLCODE = -902
Unable to complete network request to host "C".
-Failed to locate host machine.
When I don't have that I get errors like this:
Statement failed, SQLCODE = -902
I/O error for file "\Quasar\test1.gdb"
-Error while trying to open file
-No such file or directory
I've spent the last hour looking through the Interbase manuals and couldn't
find many examples that showed connections to remote systems and none that
had how to specify the path to a Windows database. If this is in the manuals
somewhere, I can't find it!
It works fine in reverse. I can connect from the Windows system to a
database on the linux system using just dragon:/tmp/test.gdb (where dragon is
the hostname of the Linux system).
I'm using the latest Firebird CS for Windows and Linux, Windows 98 for the
Windows system and Mandrake 7.2 for the Linux system. I figure there is some
trick to entering in a path to a Windows system without it trying to use it
as a node name but I don't know how to do it!
--
Brad Pepers
brad@...