|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
using isql to database on remote Linux server
is it possible to connect to database on remote Linux server from isql on Windows, can someone give some sample command:
isql -user ... or >SQL connect 'servername:/... thanks in advance |
|
#2
|
||||
|
||||
|
The usual way:
Code:
>isql SQL> CONNECT “hostname:/one/two/employee.fdb” user ‘sysdba’ password ‘masterkey’; You can also specify all parameters in one line: isql -u sysdba -p masterkey “hostname:/one/two/employee.fdb” If you are tired of typing the whole path you can set up an alias: Open a file named “aliases.conf” and add an alias for each of your databases, every alias consists of a line like: employee = /one/two/employee.fdb So the connection string above will evolve into: SQL> CONNECT “hostname:employee” user ‘sysdba’ password ‘masterkey’;
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
|
#3
|
|||
|
|||
|
thnaks, it works, indeed.
![]() |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > using isql to database on remote Linux server |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|