[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

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!
0
Alex
Asked:
Alex
  • 6
  • 5
1 Solution
 
ziolkoCommented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now