Wrox Programmer Forums
|
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Dreamweaver (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 9th, 2005, 08:24 AM
Friend of Wrox
 
Join Date: May 2005
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default uploading sql

first of all sorry becuase these days i asked many questions.
and after that my new problem:
our company has a website that doesn't support sql(its hosting ofcourse)and forced me to upload my site under this hosting.at the other hand we have a server in our company that has valid ip.and my data base going to be a very huge data base.can i attach my data base to our server data base and upload my pages to the site?and it is a logic way or no?if it is possible and logic how should i do this.i know that shoul chand my server connection ip but i didn't find any address in my connection page

 
Old July 10th, 2005, 03:20 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

It is possible, but I wouldn't recommend it.

First of all, it may be problematic to set up. You need to open ports in the firewall (1433 if you're using Sql Server) on both ends of the connection.

Secondly, it may not perform very well. When your database is on the same machine as the web server, or at least in the same network, you have a high-speed, reliable connection. However, when you connect to your database over the internet, things may become slow or unreliable.

Finally, it may be a security risk to open Sql Server ports on your server and web site.

One way to fix this is to use a private (possibly VPN) line between you and the ISP. We have done that in the past and it solves a few of the problems.

Another alternative is to bring the site in, instead of with the ISP. Depending on the site, that may not be a workable solution though.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.





Similar Threads
Thread Thread Starter Forum Replies Last Post
uploading and retriving images from sql servver bobwith5 ASP.NET 2.0 Basics 1 October 17th, 2007 11:37 AM
uploading SQL server hastikeyvan SQL Server 2000 2 August 5th, 2006 06:55 AM
Granular control in uploading data to SQL 2000 henryoh Excel VBA 2 June 26th, 2006 04:46 PM
UPLOADING SQL DATABASE aspnet79434319 Classic ASP Basics 1 June 27th, 2005 08:41 AM
Uploading Image into SQL Server sankar General .NET 0 June 16th, 2004 02:06 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.