Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2
What is the unit of TempCacheLimit?
Thanks in advance
Just found this article https://www.arbinada.com/en/node/1425
Firebird: bulk insert and bulk export
Submitted by Serguei_Tarassov on Fri, 02/08/2013 - 16:50
Firebird doesn't support INSERT BULK command or bcp.exe utility. But the
external tables can be a good replacement. Simple example is
I am looking for the fastest way to run a bulk insert.
I believe one way would be using isql.exe , I need to plan a solution to
upload into a single table around 500 million records. Does anyone have
experience with bulk updates via isql? Would it be X times faster than using a
normal
Thank you for your help. It was very helpful!
On Sunday, May 13, 2018, 12:50:26 AM CDT, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
Javier wrote:
>
> Ok, but how do I restore the statistics? Using "update" statements?
You do not
Thank you botch Norbert and Dimitry for your help
problem was with fill method
the method is to use move index [1] of string and casting or StrLCopy
or simplest possible this one which does not require any casting:
StrPLCopy(outMessage.ss, s, High(outMessage.ss))
regards,
Karol Bieniaszewski
Hello.
I am using the Firebird 2.5 Embedded Edition with the Firebird ADO.NET
provider version 5.5 or 5.7. I am not sure which, since it has been so long
since I set up the references for my project and the assembly being used is not
taken from the actual provider library that has all the
> This break logic in our application.
Agree - I don't supply role on connection in my apps at all, but to allow user
to view attachments I must do this. Also, I need a possibility to grant
privileges to regular user for managing server users (like SYSDBA) - as i know
this is possible, but
Hi,
thank you. I see that in FB3 this is the only way :(This break logic in our
application. Regular user ca not have privileges to change db structure but
with RDB$Admin role he can :(I see that this is implemented only in
FB4tracker.firebird.org/browse/CORE-2557
Regards,Karol Bieniaszewski
To do this you must follow this steps (for FB 2.5):
- grant role RDB$ADMIN to user in your working DB
- user must login with RDB$ADMIN role into your DB.
After that he can access MON$ATTACHMENTS.
Hi,
how can i grant select on MON$Attachements to normal user
that he/she can see all
>It depends on information in IMessageMetadata.
>
> > I have tried:
> > ss: Array[0..199] of Char;
> > ss: Array[0..199] of Byte;
> > ss: Array[0..199] of AnsiChar;
>
>This is a right declaration for CHAR(200).
>
OK
> > ss: String[200];
> >
> > with last string[200] i got result
15.05.2018 6:54, 'livius' liviusliv...@poczta.onet.pl [firebird-support] wrote:
> what kind of buffer?
It depends on information in IMessageMetadata.
> I have tried:
> ss: Array[0..199] of Char;
> ss: Array[0..199] of Byte;
> ss: Array[0..199] of AnsiChar;
This is a right declaration for
Hi,
I want to connect a QT/Pyside Application to a firebird 3 server using ODBC
but I get only "Error":
app = QApplication(sys.argv)
db = QtSql.QSqlDatabase.addDatabase('QODBC')
db.setHostName('localhost')
db.setDatabaseName('iNew.fdb')
db.setUserName('SYSDBA')
Hi,
how can i grant select on MON$Attachements to normal user
that he/she can see all attachements not only self?
I use Firebird 3.
regards,
Karol Bieniaszewski
13 matches
Mail list logo