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

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!
Eduardo FuerteDeveloper and AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kapila JayasingheCommented:
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"

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eduardo FuerteDeveloper and AnalystAuthor Commented:

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)Commented:

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)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...)


Move your application to an AWS instance and connect to the database "locally"
Eduardo FuerteDeveloper and AnalystAuthor Commented:
Thank you for the help!

Now it's up to me to develop and then probably return with new questions.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.