Connect Local Database from Website

Question

0.00/5 (No votes)

See more:

HI all,
I done a project using vb.net and sqlserver, now i am going to start a small web application for getting some in formations from my sqlserver database which one is connected in the local machine. is it possible to connect my local database after hosting of my web application ? if it is possible what are the prerequisites.. please help me to find a better solution.

Posted 21-May-10 3:33am

Rajmin

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Viral Upadhyay · Accepted Answer · 2010-05-21T03:46:00

Solution 1

No, you have to upload your database to some hosting provider and then have to connect your database from them.

Posted 21-May-10 3:46am

Viral Upadhyay

Comments

Rajmin 21-May-10 10:03am

thanks

Gandhi Ashish · Accepted Answer · 2010-05-21T05:38:00

One solution is as per the guy suggested that you need to host both of your application as well as database one server. The main reason is if you will only host your application then how the application will know where the database for it is located? It needs to be specified with some ip address that, this is the location from where you can find my database,right ? so if in the case you need to use your own pc for database source , then in that case you need to get a Static IP for it. Then its simple. Just point your application hosted anywhere on interntet , with the Static IP of your computer for denoting the database to connect to.

Hope this would be the sufficient and opt information you are searching for.

Thanks & Regards,
Mr.Ashish Gandhi

Lalit Kumar 5733 · Accepted Answer · 2010-05-21T08:13:00

Rajmin, one solution is that if you don't want to take sql server at hosting site then you can convert sql server database into ms-access or mysql because it is free database on hosting. so migrate your database into ms-access or mysql and upload to hosting site.

For this purpose you have only 3 solution :
1. Take sql server space on Hosting site

2. Get Static IP and connect your application with Static IP address. as per Mr.Ashish Gandhi answer. he give right answer.

3. Migrate your database into Ms-Access or MySql.

Hope you will satisfy with my suggestion.

Connect Local Database from Website

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0