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 -~----------~----~----~----~------~----~------~--~---