I doubt (and i know i wouldn't) a hosting provider would do it through a vpn
because it would require them to set up the vpn connection on their server.
Your best bet would be to have your firewall at the place where the database
is allow connections from your hosting providers IP address where your
website is.

But to answer your question, yes its possible.  I used to do it so my
hosting accounts were pointing to a database server in my back room (i don't
do this anymore though as i have my own servers now)

Steve

-----Original Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Kear
Sent: Friday, 28 December 2007 5:12 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: connecting to external data sources outside a share
cf hosting environment


I do something similar connecting my dev server to the database on the
production server so I dont see why it wouldnt be possible.    I also
have a hosting client where we host the database and several sites
hosted elsewhere access it.    I doubt you'd be able to do it using
the control panel or whatever you have in your shared setup, but your
System admin should be able to help you set it up.

I believe it's technically possible, your problem might be persuading
the sysadmin to do it.

The problem would be timeouts and errors if the vpn connection isnt
available when a page is called.   You would probably need to persuade
your sysadmin that you have allowed for that in your code and it will
degrade gracefully if the connection isnt available.

IF the connection is on a public page, i'd want to be sure your vpn
connectoin is going to be reliable enough for production, otherwise
you might be better off looking  to duplicate your in-house database
on the production server instead, so the public pages dont rely on teh
vpn connection being up and fast enough.


Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month




On 12/28/07, Claude Raiola <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am running one of my cf sites on a shared cf hosting account.
>
> Is it possible for me to create a datasource in cf that points to a
database
> that is sitting within the clients own vpn network ?? I know the
datasource
> would need to be set up with the vpn connectivity access and then map to
the
> location of the database sitting on the server within the vpn network
>
> Kind Regards
> Claude Raiola
> B.Econ(Acc.); B.Hotel Mngt.
> Mobile: 0414 228 948
> Phone: 07 3666 0981
> Fax: 07 3319 6444
>
> Websites:
> www.WebsiteSolutions.com.au
> www.AustralianAccommodation.com
> www.AccommodationNewZealand.com
> www.HospitalityPurchasing.net
> www.Samaris.net
>





--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to