Firebird - Connecting using an IP address

[taazz]

1) you share the client dll only to all the computers that have your program.
2) You install firebird server on one machine on the network.
3) you copy the database in a folder that firebird server has full control
4) You make sure that the firebird port is not blocked on the server.
5) You connect from your client with out using any network drives.

Don't confuse an SQL server with a file based database like access, the path to the database is the path as you would define it on the server aka the complete path to the database on the server machine eg D:\FirebirdData\MyDatabase. I use to define an alias in the aliases.conf file that allows me to just a simple name eg MyDatabase instead.

[timcs]

1) you share the client dll only to all the computers that have your program.
2) You install firebird server on one machine on the network.
3) you copy the database in a folder that firebird server has full control
4) You make sure that the firebird port is not blocked on the server.
5) You connect from your client with out using any network drives.

Don't confuse an SQL server with a file based database like access, the path to the database is the path as you would define it on the server aka the complete path to the database on the server machine eg D:\FirebirdData\MyDatabase. I use to define an alias in the aliases.conf file that allows me to just a simple name eg MyDatabase instead.

Thanks for the detailed reply Taazz - Problem is, is point 2, I cannot do that. Looks like I will be stuck with the dbase system unless there is another database system I can use that works like dbase in that no server installation is needed.


Thanks

TimCS

[taazz]

The DBase technology has been let to rest around the time that open source SQL servers become to life is a solution ridden with problems and inconsistencies. There is no one supporting that database model except access and that is getting attention only because is part of the MS Office so I do not think you are going to find a non server database to use easily. Personally I do not know any excpet te usual suspects access, DBase and paradox.

[timcs]

The DBase technology has been let to rest around the time that open source SQL servers become to life is a solution ridden with problems and inconsistencies. There is no one supporting that database model except access and that is getting attention only because is part of the MS Office so I do not think you are going to find a non server database to use easily. Personally I do not know any excpet te usual suspects access, DBase and paradox.

I know dbase is now obsolete but because I can access the data this way it seems to be the best. I presume Dbase is quicker than trying a plain text or XML file format as that would be the only other option.

Thanks

TimCS

[taazz]

actually now that I think about it there is one pascal native solution that might help in your case it is a bit old but it was rock solid and highly apprised at its time that is the turbopower B-Tree Filler. As far as I know it has some security build in as well (data security as in lock record for editing etc). That library wend open source when the turbo power company closed down and you can find the code at http://sourceforge.net/projects/tpbtreefiler/?source=directory. I remember that some one had converted to freepascal but I do not remember where I red that commend probably in one of the mailing lists.

Let me search my archives and I'll come back to you.

EDIT:
OK found the announcement on fpc pascal mailling list. here is the mail

hello all;
 I have converted b-tree filer to work on Free Pascal on Windows Xp and Windows 7. Two of the function do not work, (reorg rekey). I wrote three function that do the same thing, only two are needed I have a demo (part of my program)

 the editor and map driver and graphics demo one text editor for the maps.

 
 It will work for 68,719,476,735 keys the demo only has 3,700 records at the moment.

 
 If you want a copy it is ready to download, there is a sub directory named gtest this is my source and compiled code btree code is in the source directory  tpbtreefiler_5_51a
 this is written for a wide screen monitor setwindowsize(1920,1080) it will work with smaller screens but some items will be off the screen.
 Go to the site below and download turbopower.exe  this is both btree filer and flash filer and their manuals.

 you may contact me( Allen Harrington at bluehare@att.net) my website is http://blue-hare.com

Let me emphasize this one more time, you and your client will be far better off if you convert today to server based solution like firebird in which case is lightweight and has a lot better security than the model you are already using.

[timcs]

actually now that I think about it there is one pascal native solution that might help in your case it is a bit old but it was rock solid and highly apprised at its time that is the turbopower B-Tree Filler. As far as I know it has some security build in as well (data security as in lock record for editing etc). That library wend open source when the turbo power company closed down and you can find the code at http://sourceforge.net/projects/tpbtreefiler/?source=directory. I remember that some one had converted to freepascal but I do not remember where I red that commend probably in one of the mailing lists.

Let me search my archives and I'll come back to you.

EDIT:
OK found the announcement on fpc pascal mailling list. here is the mail

hello all;
 I have converted b-tree filer to work on Free Pascal on Windows Xp and Windows 7. Two of the function do not work, (reorg rekey). I wrote three function that do the same thing, only two are needed I have a demo (part of my program)

 the editor and map driver and graphics demo one text editor for the maps.

 
 It will work for 68,719,476,735 keys the demo only has 3,700 records at the moment.

 
 If you want a copy it is ready to download, there is a sub directory named gtest this is my source and compiled code btree code is in the source directory  tpbtreefiler_5_51a
 this is written for a wide screen monitor setwindowsize(1920,1080) it will work with smaller screens but some items will be off the screen.
 Go to the site below and download turbopower.exe  this is both btree filer and flash filer and their manuals.

 you may contact me( Allen Harrington at bluehare@att.net) my website is http://blue-hare.com

Let me emphasize this one more time, you and your client will be far better off if you convert today to server based solution like firebird in which case is lightweight and has a lot better security than the model you are already using.

Taazz I was not expected such another detailed reply!!! This is just a small project I am doing for work and I know that they (as in the engineers) will not allow for firebird to be installed on this server. I am doing this off my own back (not always a good idea) to try and improve a situation we have here when connecting to customer sites. The database simply stores when a user is on a site and then waits for that connection to end to then write to the record when they are off. It also then checks if user(s) are on a site and informs another user who is these are etc. Dbase is the file I use to store this information , at the moment a few of us are using this but at some stage it will be used by around 40 or more users and I am just wondering if it will quick enough when checking for the records. I have put in place a routine that when the first person goes on in the morning it clears the previous days records.

Thanks

TimCS

[taazz]

well there are a lot of solutions to the server problem for example install the server on an other machine instead of the existing tight server eg your computer, as long as the computer is on the same lan as the clients then you are set.

Ofcourse if the current implementation with the DBase components that come with FPC covers all your requirements (which I doubt) then I do not see any reason for you to upgrade to an other database. on the other hand b-tree filer has data security and far better search capabilities build in, aka it does not require you to load everything in memory and filters data as you read them from the disk.

Now please keep in mind that I haven't touched that technology for a long time and memory can play tricks especial on events that long in the past, you need to evaluate the library your self and see if it gives you any benefit converting or not, you might even learn something new at the same time.