[firebird-support] Re: Precompiling with gpre and Firebird 2,5
--- In firebird-support@yahoogroups.com, Frank Schlottmann-Gödde wrote: > > On 30.12.2011 13:39, cartonace wrote: > > I am trying to migrate to 2.5 from 1.5. I am updating a c program that > > writes data to a table. When I try to run the program I get the following > > error: > > > > Your user name and password are not defined. Ask your database > > administrator to set up a Firebird login. > > > > When I supply a user name and password in the database connection statement > > and try to recompile, I get the following warning: > > > > gpre: -user, -password and -charset switches require -manual > > > > But I don't want to use the -manual option because I want to work with > > automatic transactions as I did with Firebird 1.5. > > > > Does anybody know a way around this? > > > Not shure whether it will help in this case, but did you try setting > ISC_USER and ISC_PASSWORD environment variables? > > hth > fsg > > -- > "Fascinating creatures, phoenixes, they can carry immensely heavy loads, > their tears have healing powers and they make highly faithful pets." > - J.K. Rowling > Hello Frank Thanks for the swift reply but the environment variables were/are already set and it still prompted me for a user name and password. I think the security has been beefed up somewhere between 1.5 and 2.5 Thanks for the suggestion though.
Re: [firebird-support] Precompiling with gpre and Firebird 2,5
On 30.12.2011 13:39, cartonace wrote: > I am trying to migrate to 2.5 from 1.5. I am updating a c program that writes > data to a table. When I try to run the program I get the following error: > > Your user name and password are not defined. Ask your database administrator > to set up a Firebird login. > > When I supply a user name and password in the database connection statement > and try to recompile, I get the following warning: > > gpre: -user, -password and -charset switches require -manual > > But I don't want to use the -manual option because I want to work with > automatic transactions as I did with Firebird 1.5. > > Does anybody know a way around this? Not shure whether it will help in this case, but did you try setting ISC_USER and ISC_PASSWORD environment variables? hth fsg -- "Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers and they make highly faithful pets." - J.K. Rowling
[firebird-support] Re: Firebird and TatukGIS - DBX or ODBC
One thing I forgot to mention was that my server in linux. Is an n-tier model supportable in that situation? Thanks --- In firebird-support@yahoogroups.com, "Carlos H. Cantu" wrote: > > Firebird comunication protocol is known to be slow in high latency > networks (internet). FB 2.1 had improvements in this area, and is > supposed to be +/- 30% faster compared to previous versions, but you > need to upgrade the client libraries too to take full advantage. > > Even so, the protocol is still slow. Right now I'm talking with some > core developers to see if they can improve this more, for FB 3 and > maybe FB 2.5.2 too. > > PS: If you change your app to use n-tier model, the communication > protocol between the client machine and the application server will > not be the FB one, so probably you could get better speed. > > []s > Carlos > Firebird Performance in Detail - http://videos.firebirddevelopersday.com > www.firebirdnews.org - www.FireBase.com.br > > CC> Background: > > CC> I am developing a GIS application for Win32 in Delphi XE using > CC> TatukGIS VCL DK 10 and Firebird 1.5. I save large aerial > CC> photography files as SQL Layers (BLOBs) using Tatuk's PixelStore > CC> format. Many of my users are remote, and hit against my server to > CC> load layers. At this point I provide access to the SQL Layers > CC> through ODBC. The speed for people accessing them from beyond my > CC> firewall is not great and I need to improve it if possible. > > CC> Questions: > > CC> 1) Is ODBC the way to go here, or should I use another driver, like DBX? > > CC> 2) Would I see an improvement in speed by using a more modern version of > Firebird? > > > CC> Thanks > > > > CC> > > CC> ++ > > CC> Visit http://www.firebirdsql.org and click the Resources item > CC> on the main (top) menu. Try Knowledgebase and FAQ links ! > > CC> Also search the knowledgebases at http://www.ibphoenix.com > > CC> ++ > CC> Yahoo! Groups Links >
[firebird-support] Re: Optimizing Firebird for SSD
Small size is actually value between 128-256 pages which is much more then what CS has now as default value. > > Be careful with that because Firebird will copy pages to its cache > before referencing their contents. If you make the database cache too > small, you'll spend a lot of cycles doing memory to memory copies. > Lots cheaper than disk reads, of course, but not free. > > Good luck, > > Ann >