Dear all, My platform is: Firebird 1.5 on Linux WinXP MS Access 2000 IBPhoenix ODBC driver V1.02.00.59 When I try to link a table in Firebird server, Access...
Martijn, Daniel, all, ... D> I agree with you. One of my findings(that I just remembered) was that D> I got the error "object in use" when creating a second...
Christian, ... C> I had thought of this too, but I thought there was a more "Firebird" C> way to do this. If there is no other way, I will use this workaround....
Alan, A> But why on earth do you wnat to use only one generator? it is a pretty common technique when doing object/relational mapping with IB/Fb. No need to...
I am new to Firebird and am about to switch from the open source version of IB to FB 1.5 using IBObjects 4.3.A on XPPro. 1) I converted my gdb to fdb via...
Ross Garbig
ross@...
May 1, 2004 10:54 am
41222
... How large are these tables? For how long is the CPU at 100% ? If you have a lot of indexes on the tables, try to set them inactive before sweeping (or use...
... likely ... key. You ... cursor, ... correct ... Yes, it is related with the previous restore problem. What do you mean with "rogue" character? Do you mean...
... If it is the cause of the transliteration error, it is a value in the (presumably character-type) FK column, which has been stored with a character code...
... Yes, almost. You will need the proper client library (fbclient.dll) and either to modify the name and location of the client IBO looks for (ask in the IBO...
Thanks Helen I have one app on the databse server PC and others on a LAN talking to the database. Can the app on the db server be using localhost and the...
Ross Garbig
ross@...
May 1, 2004 1:40 pm
41227
Hi Ross, ... This will work just fine. ... I doubt it very much that this is a problem. Unless you're using the local connection (not localhost). With regards,...
... Depends on the sort of problems, I guess. If you have a resource-hungry local application eating up resources, then it's taking memory that the db server...
How do I respond to a response to my posting? I have tried a couple of 'Reply to Group' but they don't show up. Thanks [Non-text portions of this message...
Ross Garbig
ross@...
May 1, 2004 4:21 pm
41230
... Did you try simply "Reply"? Which email program are you using?...
Hi, Is there a big difference between ASCII and ISO8859_1 character set? My default is set to ISO8859_1, but I've one ASCII column and I'm now wondering if I...
Pardon my stupidity, but this is all new to me. Why is the following stored procedure failing to compile? declare variable fkvalue varchar(11) character set...
Hi, ... Dan, He's using Outlook Express(it's in the headers). He probably got confused between e-mail group and newsgroup. Ross, You are posting via the...
... Yes, they are quite different. The ISO character sets use ANSI encoding. But as well as different encoding, they support different characters, as well....
... I) Is this all of your stored procedure? Or did you just omit the CREATE PROCEDURE <procedure-name> AS clause to save bandwidth? 2) Probably you created...
Hello, After reading a few of the posts on this topic, I was a bit discouraged to see people dismiss the idea of being able to figure out the database path...
Hello, I want to install Firebird as a non-root user, because I'm not root of the machine I try installing it. I searched around the website and the web for...
Jens Mueller
jens.k.mueller@...
May 2, 2004 1:10 pm
41238
... It should be sufficient to run bin/fbguard or bin/fbserver. Elmar...
... $ ./fbserver fbserver: Invalid user (must be firebird, interbase, interbas or root). $ ./fbserver -z Firebird TCP/IP server version LI-V1.5.0.4290 Firebird...
Jens Mueller
jens.k.mueller@...
May 2, 2004 1:46 pm
41240
... The purpose of an ASCII column, is to prohibit funny 'internatial' charcters to sneak into your data. As long, as all charcter data are really ASCII...
... set? ... now ... I ... different ... for ... Am I does correct to assume that the ASCII set is a subset in the ISO8859_1 set and would be able to change...
... set? ... Okay, this is the reason why I used an ASCII column. But since the default set is ISO8859_1 I should use CAST for the ASCII column to insert/edit...
... CREATE ... sorry. Here is the full code (I was using IBExpert): which is now working except for the fact that at compile time I now get the message: " ...
... <helebor@t...> ... I'm ... then ... characters, ... Is the following code (which I use now) correct? Or do I've to force a cast on the ascii column? CREATE...
Hi, some days ago I posted a message about Embedded Firebird and UDF but nobody answered me. Is this the right forum about Firebird Embedded ? I need an help...
... By "default set", do you mean: a) the default character of the database b) your connection character set c) your operating system's default character set ...