mainrotor
asked on
I need assistance with my ASP.Net application
I just built an ASP.Net web application on my local machine. My app saves data to my SQL Server database that is also on my local machine. I am ready to go live with this app (i.e. put it on the web). What do I have to do to make sure that the application still save data to the SQL Server DB on my machine? Or do I have to use the MySQL databases that are provided by the web hosting company?
Thanks in advance,
mrotor
Thanks in advance,
mrotor
Your best bet would be to use the SQL database on your web host's computer. Your solution will be faster that way.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you take SQL out of intranet where is your IIS then you reduce performance and security.
Anyway you will need to change connectionString in your web config "Data Source=you_pc_ip;Initial Catalog=..".
You can find some info about connect via IP address here.
Anyway you will need to change connectionString in your web config "Data Source=you_pc_ip;Initial Catalog=..".
You can find some info about connect via IP address here.