Re: [firebird-support] Connecting to database on remote server

2019-07-08 Thread Tony Christiansen t...@adegroup.com.au [firebird-support]

Re: [firebird-support] Connecting to database on remote server

2019-07-08 Thread Helen Borrie hele...@tpg.com.au [firebird-support]
Tony Christiansen wrote: > I am running an app on my PC that connects to a database on my firebird > server FIREBIRDSERVER > The path is \\FIREBIRDSERVER\E:\DB.FDB > If my pc has an E: drive (ie I plug in a usb) I can connect to the database. > If my pc has no E: drive then I cannot connect to

AW: [firebird-support] Offtopic: Trigger before Insert: Firebird vs. MS SQL

2019-07-08 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello Dimitry, thanks for the fast response. This explains a lot of things. Niko -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com Gesendet: Montag, 8. Juli 2019 17:11 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] Offtopic: Trigger before Insert:

Re: [firebird-support] Offtopic: Trigger before Insert: Firebird vs. MS SQL

2019-07-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.07.2019 16:55, 'Nikolaus Kern' parzival1...@gmx.at [firebird-support] wrote: > Is it possible that this works totally different in MS SQL? Yes, it works totally different in MS SQL. Yes, only AFTER and INSTEAD OF triggers are available there. Besides, they are statement-level, not

[firebird-support] Offtopic: Trigger before Insert: Firebird vs. MS SQL

2019-07-08 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello all, I was looking into a very simple question on MS SQL (from a Firebird users point of view): Before INSERT I need to modify the incoming data: Example: INSERT INTO CUSTOMERS (NAME, AGE) value ('Test', 50); The trigger should simply decrease the age by 1 year. In Firebird it

[firebird-support] Connecting to database on remote server

2019-07-08 Thread Rustam rusta...@ukr.net [firebird-support]
Read here about connection strings: https://firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/qsg3-databases.html Run "Command prompt" and enter command: >ping FIREBIRDSERVER If 'ping' command failed - use an IP address instead: >ping xxx.xxx.xxx.xxx If succeeded - use IP

Re: [firebird-support] Connecting to database on remote server

2019-07-08 Thread Tony Christiansen t...@adegroup.com.au [firebird-support]

[firebird-support] Connecting to database on remote server

2019-07-08 Thread Tony Christiansen t...@adegroup.com.au [firebird-support]
Hi I am running an app on my PC that connects to a database on my firebird server FIREBIRDSERVER The path is \\FIREBIRDSERVER\E:\DB.FDB If my pc has an E: drive (ie I plug in a usb) I can connect to the database. If my pc has no E: drive then I cannot connect to the database and get the