Alex
asked on
Firebird remote admin...
Hi Experts!
Let's say we have an application in delphi and a firebird database that we operate this db with our program and we have operations like to read from the tables,insert,update,delet e records e.t.c.
Is there a way to connect from a remote pc for example of my home to the pc that has the program and the db and to be able to do remote administration eg to read all the records from the db.
Maybe i could have a server to upload the local db data to the server db and then to download them to remote db or could i connect direct from the program of my home to the other pc or whatelse?
Thanks in advance!
Let's say we have an application in delphi and a firebird database that we operate this db with our program and we have operations like to read from the tables,insert,update,delet
Is there a way to connect from a remote pc for example of my home to the pc that has the program and the db and to be able to do remote administration eg to read all the records from the db.
Maybe i could have a server to upload the local db data to the server db and then to download them to remote db or could i connect direct from the program of my home to the other pc or whatelse?
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
yup that's option #1:)
you have to install firebird on computer which has access to internet.
then you can use your soft.
ziolko.
you have to install firebird on computer which has access to internet.
then you can use your soft.
ziolko.
ASKER
.. and then to select to connect to a remote database and no to a local...
So i must give a static ip to the "client" so to be able to connect from my home application to the remote db and to do any operation that i want or whatelse you suggest me?
So i must give a static ip to the "client" so to be able to connect from my home application to the remote db and to do any operation that i want or whatelse you suggest me?
once you do this you have to change database path on application side:
from C:\...\dbname.fdb to
ip_address:C:\...\dbname.f db
where ip_address is IP address of computer hosting your database server
ziolko.
from C:\...\dbname.fdb to
ip_address:C:\...\dbname.f
where ip_address is IP address of computer hosting your database server
ziolko.
ASKER
with this solution can i connect direct between two pc's or i want a solution something like a web hosting server to upload the local db data to mysql server db and then to download them?
diagram1:
client pc ------> home pc
diagram2:
client pc ---> web server mysql db ---> home pc
diagram1:
client pc ------> home pc
diagram2:
client pc ---> web server mysql db ---> home pc
>>So i must give a static ip to the "client"
not to the client but to server hosting your database, if you dont assign static IP then each time you want to connect to your db you have to change your connection string.
>>with this solution can i connect direct between two pc's or i want a solution >>something like a web hosting server to upload the local db data to mysql >>server db and then to download them?
direct connection is a lot better so if it's possible - use it.
dowloading and uploading data between two different databases always means extra effort because it might impact DB integrity
ziolko.
not to the client but to server hosting your database, if you dont assign static IP then each time you want to connect to your db you have to change your connection string.
>>with this solution can i connect direct between two pc's or i want a solution >>something like a web hosting server to upload the local db data to mysql >>server db and then to download them?
direct connection is a lot better so if it's possible - use it.
dowloading and uploading data between two different databases always means extra effort because it might impact DB integrity
ziolko.
ASKER
ziolko have you ever made an application like this, do you have any experience abou this?I am asking you because for now i am ok from your answers but when i am going to built an app to do those things maybe i 'll need some more specific details.
>>ziolko have you ever made an application like this, do you have any experience abou this?
that's what i do for living:)
ziolko.
that's what i do for living:)
ziolko.
ASKER
ok man... so i'll need to the future ( not so far ;) ) when i start to built it to give me more and specific informations ;)
thank a lot!!!!
thank a lot!!!!
no problem mate:)
ziolko.
ziolko.
ASKER
Yes this is a "simple" solution but i don't want to connect via a software of remote administration but throw my delphi program.Is that possible?