Odp: [firebird-support] ODBC Remote connection Support

2014-09-22 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
Hi, Error message tell you that you must install client library gds32.dll. Run Firebird installer on your laptop and in installation process check something like copy client library gds32.dll to system folder. Regards, Karol Bieniaszewski - Reply message - Od: "Marcos Herrera marcos.he

Re: [firebird-support] ODBC Remote connection Support

2014-09-22 Thread W O sistemas2000profesio...@gmail.com [firebird-support]
Hello Marcos I think you are from Colombia, so you can read and write Spanish. You can post all your doubts about Firebird, SQL or databases in a forum which URL is: firebird21.yoforeo.com Greetings. Walter. On Mon, Sep 22, 2014 at 10:38 AM, Marcos Herrera marcos.herr...@manar.com.co [firebi

[firebird-support] ODBC Remote connection Support

2014-09-22 Thread Marcos Herrera marcos.herr...@manar.com.co [firebird-support]
Hi Dear Firebird Support We have an ERP that use a Firebird Database, i need connect to this database via ODBC from my laptop, the database are located in the ERP Server, i configure the same ODBC in the server and Works fine, but not work fine from my laptop. The data connection are:

RE: [firebird-support] Re: MON$STATEMENTS question

2014-09-22 Thread Maya Opperman m...@omniaccounts.co.za [firebird-support]
>> Is that not going to be affecting performance in a bad way? >Nope. Thanks Dmitry! ++ Visit http://www.firebirdsql.org and click the Documentation

[firebird-support] Re: MON$STATEMENTS question

2014-09-22 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
22.09.2014 17:09, Maya Opperman wrote: > Is that not going to be affecting performance in a bad way? Nope. Dmitry ++ Visit http://www.firebirdsql.o

RE: [firebird-support] Re: MON$STATEMENTS question

2014-09-22 Thread Maya Opperman m...@omniaccounts.co.za [firebird-support]
>> I'm not sure if this is a problem or not, but I have quite a few >> entries like this with NULL transaction ID's in the MON$STATEMENTS table: >> >> Is this a sign that my code isn't cleaning something up properly, or >> is it perfectly normal? >> >> Any idea under what circumstances this will

Re: [firebird-support] Re: How to populate a new table column with a INTEGER sequence?

2014-09-22 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Wouldn’t leaving out the “temp trigger” and “foo” and simply doing: update sometable set id = gen_id(some_table_id_gen, 1); have the same result? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere,

[firebird-support] Re: How to populate a new table column with a INTEGER sequence?

2014-09-22 Thread duque.herna...@yahoo.com [firebird-support]
Hi to all, This is one approach (Maybe could be done one more efficient): /** * Firebird 2.5 */ -- 1.Create new fields ALTER TABLE some_table ADD id INTEGER DEFAULT 0 NOT NULL, ADD foo_dummy CHAR(1); -- 2.Create generador CREATE GENERATOR some_table_id_gen; -- 3.Crea