Could you point a strategy to access a DB that remains at AWS cloud by using Visual FoxPro?

Eduardo Fuerte
Eduardo Fuerte used Ask the Experts™
on
Hi Experts

Could you point a strategy to access a DB that remains at AWS cloud by using Visual FoxPro?

The reason it to reuse an alrealdy developed app to do that.

Thanks in advance!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ICT Infrastructure Engineer
Commented:
If you run Visual Fox Pro on your PC. Create an SSH tunnel to map a local port to your database instance (or RDS)

Eg: map localhost:3308 to Ec2:3306

In windows;
plink.exe from PUTTY can do this easily.

Something like this

plink.exe -N -L 3308:localhost:3306 ec2-user@db.public.ip -i "your_key.ppk"
Eduardo FuerteDeveloper and Analyst

Author

Commented:
Hi

Thank you for the reply.
By the way all DB access must to be performed by using AWS web services and then the result sent as a cursor to Visual FoxPro...
Is that correct?
RobOwner (Aidellio)
Most Valuable Expert 2015

Commented:
Eduardo,

What Kapila is saying is that the database will look like it is on your local machine after you create a SSH tunnel to the AWS instance.  In Visual FoxPro you connect to the database as if it were on your own computer, eg localhost.  

Does that make sense ?
RobOwner (Aidellio)
Most Valuable Expert 2015

Commented:
If you're building to have the front end on another server (not AWS) then you would need to open the relevant ports on the AWS instance (not a good idea security wise...)

OR

Move your application to an AWS instance and connect to the database "locally"
Eduardo FuerteDeveloper and Analyst

Author

Commented:
Thank you for the help!

Now it's up to me to develop and then probably return with new questions.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial