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,delete 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!
LVL 9
AlexSoftware EngineerAsked:
Who is Participating?
 
ziolkoConnect With a Mentor Commented:
two options:
1. make your DB server accessible from network and use software from your home
2. use remote desktop or VNC to connect to server on which your software is

ziolko.
0
 
AlexSoftware EngineerAuthor Commented:
thank you once for the post again.

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?
0
 
ziolkoCommented:
yup that's option #1:)
you have to install firebird on computer which has access to internet.
then you can use your soft.

ziolko.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
AlexSoftware EngineerAuthor Commented:
.. 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?
0
 
ziolkoCommented:
once you do this you have to change database path on application side:
from C:\...\dbname.fdb to
ip_address:C:\...\dbname.fdb
where ip_address  is IP address of computer hosting your database server
ziolko.
0
 
AlexSoftware EngineerAuthor Commented:
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
0
 
ziolkoCommented:
>>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.
0
 
AlexSoftware EngineerAuthor Commented:
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.
0
 
ziolkoCommented:
>>ziolko have you ever made an application like this, do you have any experience abou this?

that's what i do for living:)

ziolko.
0
 
AlexSoftware EngineerAuthor Commented:
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!!!!
0
 
ziolkoCommented:
no problem mate:)
ziolko.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.