Re: [firebird-support] Connecting to Superserver on CentOS 6

2015-05-12 Thread marcus mar...@antiphasis.net [firebird-support]
includes “localhost” as a name for 127.0.0.1, for what that’s worth, so I doubt it’s a host name issue. TIA, David Cheers, Marcus [Non-text portions of this message have been removed]

Re: [firebird-support] Open Database xxxxx failed Creating Odbc DSN for Firebird 1.5

2015-05-10 Thread marcus mar...@antiphasis.net [firebird-support]
? A marginal note by the way: you are shurely aware of the fact that Firebird versions up to Version 2.1 are not maintained any more. See http://www.firebirdsql.org/en/roadmap/ for more information. A first guess for your problem: Windows Firewall. hth, Marcus [Non-text portions of this message have

Re: [firebird-support] Re: Cannot install 2.5.4 on Linux Mint - gsec error

2015-05-08 Thread marcus mar...@antiphasis.net [firebird-support]
Hej, On 08.05.2015 12:35, David Nock dav...@accessitsoftware.com [firebird-support] wrote: This particular machine instance had no previous firebird install. However, I have tried purging the packages and reinstalling. Still have the same problem... On 8/05/2015 10:02 p.m.,

Re: [firebird-support] Database Size Is Not Reducing

2015-04-08 Thread marcus mar...@antiphasis.net [firebird-support]
backup/restore? cmd, service api, some 3rd Party components? Doublechecked file locations? Stumpled upon that to often for myself. hth, Marcus With Best Regards. Vishal [Non-text portions of this message have been removed]

Re: [firebird-support] Revert DB to previous version

2015-03-18 Thread marcus mar...@antiphasis.net [firebird-support]
with the 2.1 fb, that won't work IMHO the clean solution would be to create a new empty database with the appropriate structure and pump the data afterwards. hth, Marcus [Non-text portions of this message have been removed]

Re: [firebird-support] Firebird database seems to influence multi user ability

2014-12-08 Thread marcus mar...@antiphasis.net [firebird-support]
version of Firebird? - which user? SYSDBA is allowed to connect an 'offline' database. He has to, else a database would only become a big jumbled piece of bits'n'bytes if one pulls the trigger gfix -shut ... Do you have the output of gstat -h database.fdb? What does the row Attributes say? marcus

Re: [firebird-support] Stability on newer windows ...

2014-11-24 Thread marcus mar...@antiphasis.net [firebird-support]
On 24.11.2014 12:09, Lester Caine les...@lsces.co.uk [firebird-support] wrote: On 19/11/14 18:18, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] wrote: Try using the 32 bit version of Firebird, maybe this can help you. Run 32bit Firebird 2.1.6 with 32bit

Re: [firebird-support] Firebird can't connect to host

2014-11-15 Thread marcus mar...@antiphasis.net [firebird-support]
On 14.11.2014 08:55, Andromeda andromedar...@gmail.com [firebird-support] wrote: Hello, I'm new in FirebirdSQL. I can't connect into my host address whereas it can connect to localhost successfully. It prompt show errors like this: |SQL connect

Re: [firebird-support] Firebird on Mac

2014-11-15 Thread marcus mar...@antiphasis.net [firebird-support]
instances - that is in case of classic fb_inet_server You may try from the terminal: /path/to/isql -user SYSDBA -password whateveritis 127.0.0.1:/path/to/database for further informations: http://www.firebirdsql.org/file/documentation/papers_presentations/html/paper-fb-macosx.html hth, marcus

Re: [firebird-support] Firebird 2.0 Support Windows Server 2012?

2014-11-11 Thread marcus mar...@antiphasis.net [firebird-support]
not be a problem running a server as vm Is there anything to configure in Server 2012? Is Firebird 2.0 Supportet with Server 2012? See regards... Thanks Reegards hth, Marcus Mit freundlichen Grüßen Sven Knappich system engineer service, projects

Re: Odp: [firebird-support] FB server installation a nd concurrent users limits on Windows Server

2014-11-06 Thread marcus mar...@antiphasis.net [firebird-support]
On 06.11.2014 20:22, af_12...@yahoo.com [firebird-support] wrote: Hi i am new to databases and i am going to choose Firebird. Supposing that i will have to interact with some MS server where are some already installed software, mail server and other softwares i were starting to ask

Re: [firebird-support] What is wrong with transactions here?

2014-11-04 Thread marcus mar...@antiphasis.net [firebird-support]
On 04.11.2014 16:21, simion_coro...@yahoo.fr [firebird-support] wrote: Hi! I have some lines in firebird.log like this: === cxv.servers.netTue Nov 4 11:37:38 2014 Sweep is started by SWEEPER Database SkyNetInt OIT 1221095, OAT 1231335, OST 1231313,

Re: [firebird-support] What is the difference between these connection strings?

2014-10-03 Thread marcus mar...@antiphasis.net [firebird-support]
On 01.10.2014 13:27, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On Wed, 01 Oct 2014 13:14:52 +0200, marcus mar...@antiphasis.net [firebird-support] firebird-support@yahoogroups.com wrote: Yes, you likely will loose the connection: greetings from the firewall. Albeit

Re: [firebird-support] What is the difference between these connection strings?

2014-10-01 Thread marcus mar...@antiphasis.net [firebird-support]
process to the exceptions or, at least: allow incoming tcp/3050, outgoing tcp/any. That should be enough. Tearing down the firewall isn't an option. Thanks for your time. hth, Marcus [Non-text portions of this message have been removed]

Re: [firebird-support] Can't connect to CentOS 7 service port 3050 from network

2014-09-17 Thread marcus mar...@antiphasis.net [firebird-support]
into a superclassic. Do I need a 64 bit client for connecting to FB on a CentOS 7? No, the client bitness depends on the client os and/or requirements of the app. Any help will be appreciated. hth, marcus Best regards, Hernando. [Non-text portions of this message have been

Re: [firebird-support] Re: Proper way to configure Firebird startup on FreeBSD 10

2014-09-14 Thread marcus mar...@antiphasis.net [firebird-support]
http://www.firebirdsql.org/manual/qsg2-config.html#qsg2-config-security discusses some points you should consider. And where to place databases - now, there are some common locations such as /var, /usr/var or /opt - but there is no general authoritative answer possible, as it depends on how

Re: [firebird-support] Re: Proper way to configure Firebird startup on FreeBSD 10

2014-09-13 Thread marcus mar...@antiphasis.net [firebird-support]
Perhaps you should read tutorials and documentation - that's the way most of the users have learned how to do this and that, asking questions for single topics. Your questions do not show any basic knowledge, neither of freebsd nor of firebird. You're asking for do my job, now!

Re: [firebird-support] Proper way to configure Firebird startup on FreeBSD 10

2014-09-12 Thread marcus mar...@antiphasis.net [firebird-support]
stevef...@yahoo.com [firebird-support] wrote: I've successfully installed Firebird on FreeBSD 10 but can't seem to find documentation on the proper way to configure it to run at system startup. Somewhere on the www, I found that you should add the following line to/etc/rc.conf:

Re: [firebird-support] Where is release 2.5.3 on FreeBSD?

2014-08-31 Thread marcus mar...@antiphasis.net [firebird-support]
://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/ports-using.html Word of advice - if yoo aren't that familiar with freebsd and/or the packaging/ports mechanisms - stay on 2.5.2_5 until 2.5.3 becomes available. hth, Marcus [Non-text portions of this message have been removed]

Re: [firebird-support] Date literals

2014-08-14 Thread marcus mar...@antiphasis.net [firebird-support]
uses the separator to decide, see the chapter Separators in Non-U.S. Dates at the half hth, marcus [Non-text portions of this message have been removed]

Re: [firebird-support] Invalid request BLR execting UNION of views

2014-08-12 Thread marcus mar...@antiphasis.net [firebird-support]
, marcus [Non-text portions of this message have been removed]

Re: [firebird-support] Database Too Large.

2014-06-29 Thread marcus mar...@antiphasis.net [firebird-support]
IIRC that's the second user having problems with SAM Broadcast using firebird. The Product company Spacial Audio has its own support site at https://spacialaudio.zendesk.com/home, that should be your way to ask for help, as they do know how their application talks to the database. And, as

Re: [firebird-support] this keeps happening

2014-06-23 Thread marcus mar...@antiphasis.net [firebird-support]
MYKS51 my...@telus.net [firebird-support] wrote: Hello, Using SAM 2014.3 on Win7 system with built into SAM, Firebird. Whenever I try to reboot my computer it hangs at Shutting Down and though I've waited as long as 10 minutes it doesn't seem to continue so must hit reboot button. When I

Re: [firebird-support] How to convert big FIREBIRD DB to one charset (win1251) to UTF8 ?

2014-06-03 Thread marcus mar...@antiphasis.net [firebird-support]
/resources/documents/design/doc_150 hth, Marcus

Re: [firebird-support] Cannot connect to remote FB Server

2014-03-04 Thread marcus
Hej, dennisktl...@yahoo.com wrote: Hi marcus, Thanks for your reply. Appreciate it. Yes it is able to ping, from server to client and vice versa. As for the routing information, i will try to get from the network administrator. Thanks. If ping is allowed between both parties - have you

Re: [firebird-support] Cannot connect to remote FB Server

2014-03-03 Thread marcus
is fine. If I connect from a client PC which resides on the same network segment, it is working fine. I suspect is has something to do with the packet routing or have I missed anything here? Your help is very much appreciated. Thanks in advanced. hth, marcus

Re: [firebird-support] Firebird server 64 bit, OS 64 bit, Firebird client 32 bit

2014-03-03 Thread marcus
into that construct. And even an 64er OS uses a lot of 32er system processes and that. hth, Marcus

Re: [firebird-support] Firebird 2.5 under Windows 8 64bit

2014-02-20 Thread marcus
will run with current user rights, so that may be your problem. If running as Service, fb is running in system\service context and should not have those problems. hth, Marcus -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB

Re: [firebird-support] Udf returning VARCHAR

2014-02-03 Thread marcus
. There's a little table describing what you are looking for. hth, marcus regards, Karol Bieniaszewski W dniu 2014-01-31 09:24:20 użytkownik Bogdan Mihalache bogdan.mihala...@soter.ro napisał: Why don`t you use CAST ( var as VARCHAR(NN)) ? *Bogdan MIHALACHE* *From:*firebird

Re: [firebird-support] Garbage collection / sweep not happening on super classic

2014-01-07 Thread marcus
Hej, rmcgi...@oceris.com wrote: Sweep interval: 0 IIRC a Sweep interval of 0 disables automatic sweeping?

Re: [firebird-support] arithmetic exception, numeric overflow, or string truncation

2013-12-19 Thread marcus
the same error. First i would try the procedure without the insertsql-stuff. Marcus

Re: [firebird-support] Database Inaccessability

2013-12-18 Thread marcus
... Marcus *From:*firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] *On Behalf Of *hil...@healthrad.co.za *Sent:* Wednesday, December 18, 2013 2:58 PM *To:* firebird-support@yahoogroups.com *Subject:* Re: [firebird-support] Database Inaccessability OS : windows server

Re: [firebird-support] FreeAdhocUDF: file functions - can not SAVE#92;LOAD blobs with unicode paths.

2013-12-13 Thread marcus
Hej, brucedickin...@wp.pl wrote: Hi guys, have anyone tried these functions? I can save and load ascii named blobs to disk but it does not work for unicode paths. For example: SELECT F_BLOBLOAD('E:\你好.txt') FROM RDB$DATABASE gives me an empty blob. I can not test it via FlameRobin because

Re: [firebird-support] Replication of Firebird Databases (meany to one)

2013-12-07 Thread marcus
to a service. thanks Andy hth, Marcus ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search

Re: [firebird-support] wcdata.fdb file opened many times, hogging space !

2013-11-23 Thread marcus
Hej all jboss...@nwtel.ca wrote: No i'm not deleting any file. Sure? If not you, may it be a script or an application? Because dropping a database per fb service or isql statement (which may be the same) would not left over any hanging fb_inet processes. -we use the gfix script to stop the

Re: [firebird-support] what should i think of when creating a shared server with firebird?

2013-11-23 Thread marcus
Hej, g80r...@gmail.com wrote: it's time we start creating servers for firebird. i thinking of shared servers, like they do on mysql on almost all shared server around the world. i am thinking of selling shared server accounts with firebird. what do i have to think of and what do i need to

Re: [firebird-support] what should i think of when creating a shared server with firebird?

2013-11-23 Thread marcus
for users. let's say it on a linux server. and let's say it's also on a windows server. please give one better answer. ---In firebird-support@yahoogroups.com, marcus@... wrote: Hej, g80rock@... mailto:g80rock@... wrote: it's time we start creating servers for firebird. i

Re: [firebird-support] Overflow occurred during data type conversion

2013-10-09 Thread marcus
the same name as returning variable? Marcus On Mon, Oct 7, 2013 at 7:56 PM, Leyne, Sean s...@broadviewsoftware.com mailto:s...@broadviewsoftware.com wrote: __ You need to provide some better context (SP source code), the error message alone does not provide any details from which

Re: [firebird-support] firebird performance on xeon cpu

2013-08-26 Thread marcus
安占江 wrote: I have some create table scripts, run well on most pc, but the hp server. hp server as bellow cpu xeon 2.8Ghz 4core not used hyperthreading mem 8gb disk 500gb 7.5k/s sata os win7 64 firebird.conf cpuaffinitymask=1 this scripts normally run less than 1s, but on there two

Re: [firebird-support] Detecting / Removal of Firebird

2013-08-20 Thread marcus
craigmas...@btinternet.com wrote: Can anyone help with how to detect if Firebird is installed on a server? A recent health check here has detected that an older version of one of our applications used to use Firebird and there are fragments that need removing. However, all attempts to find

Re: [firebird-support] Re: Question about Temp Directory

2013-07-12 Thread Marcus Bajohr
, Anto Hej, simply point your tempdir to something non-existant and try to restore a database. It will stop at the end and you'll not getting it done. That's what the temp dir is used for, too. hth, Marcus

Re: [firebird-support] guest user

2013-06-19 Thread Marcus Bajohr
hej, - create custom user - grant needed rights for user on table hth, marcus Sergio wrote: Hello, sorry if this is a silly question, but I'm googling it and can't find the answer... I need to create test user which is not allowed to drop or alter anything of the database metadata. Just

Re: [firebird-support] New User

2013-06-13 Thread Marcus Bajohr
Hej, Marco Sucuzhañay wrote: estimated as I can create a user with read permissions to a table in my database firebird, thanks. grant select on table to user; hth, marcus [Non-text portions of this message have been removed

Re: [firebird-support] Re: Rename database command

2013-06-05 Thread Marcus Bajohr
and that) Robert writes about (may be he has in an earlier post) , it is just peeking around. just my EUR 0,02, Marcus Alexandre Benson Smith wrote: Em 5/6/2013 13:33, Leyne, Sean escreveu: Alexandre, While I completely agree with your points. I read the OP as meaning that they are running

Re: [firebird-support] Rename index?

2013-06-03 Thread Marcus Bajohr
First guess: create a new Index with the appropriate name and drop the old Kjell Rilbe kjell.ri...@datadia.se wrote: Any simple way (including update in an rdb$... table) to rename an index? Drop/recreate is a bit expensive on 200+ million record tables... The rename is motivated by a renamed

Re: [firebird-support] Re: Aliases and Windows 7

2013-05-30 Thread Marcus Bajohr
(X86)% %PROGRAMDATA% %USERPROFILE% Reason: Security and Privacy. So it is easier to create a separate folder for databases which is out of the security scope. syl, marcus the error occours both with local or remote access. For example, I had Firebird installed on a Windows 2003 machine (named

Re: [firebird-support] Overflow during backup. Apparent date problem.

2013-05-17 Thread Marcus Bajohr
Hej, are there any anormal entries in the firebird log? homerjones1941 mailto:ho...@agencybusys.com Freitag, 17. Mai 2013 20:35 Using GBAK via IBExpert, I get the following message. I don't know how to fix it (or find it). Overflow occurred during data type conversion. conversion error

Re: [firebird-support] autodate and autofill columns

2013-04-20 Thread Marcus Bajohr
hej, AFAIK that cannot be handled by firebird on its own, as fb has no anchor to the outer world as long as there is no active connection. cheers, marcus dice_in_trouble mailto:dice_in_trou...@yahoo.com Samstag, 20. April 2013 14:22 hello i have a firebird database in which i have columns

Re: [firebird-support] Password Recovery

2013-04-11 Thread Marcus Bajohr
Hej, you're talking about encrypted data stored in the db? Then you'll have no luck, as data is encrypted by the app that's writing the data. Ii mailto:ii_tungt...@ymail.com Donnerstag, 11. April 2013 10:48 i have problem with my softwarethat software using a encryption passwordand

Re: [firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?

2013-04-09 Thread Marcus Bajohr
Hej, AFAIK there are no dedicated return codes for gfix. So you'll get a non-zero return code if there is a problem while executing gfix, but not from gfix when there are any problems with a database. cheers, Marcus un_spoken schrieb: Hi guys. My application needs to call gfix every day

Re: [firebird-support] Install Firebird SS in Ubuntu Linux by apt-get or tar.gz /install.sh

2013-03-15 Thread Marcus Bajohr
I've made best experience with the native tar.gz, as there are no external dependencies aside of a recent glibc. cheers, marcus piraju1379 mailto:assisinformat...@gmail.com Donnerstag, 14. März 2013 23:17 I'm installing Firebird Super Server version 2.5.2 on Linux Ubuntu. 1. Install