How to publish SQL Server on the Internet.

[venkatanarasimhaa]

Hi,

I am new to web applications. I have designed one VB 6.0 application with SQL Server 2000 as backend. I have designed a setup package for my application and installed in each and every system in my small office. It is working fine because all my systems are connected to that server.

Now, My client wants the same appliaction to be run on his system. What is the procedure to publish this on internet so that my client can run the same application from his desktop.

Please help me out in the following.

I dont have any idea about .Net.
1. Is there any possible that I can share same setup file with my client so that he can install and start working from his desktop?
2. If yes, please let me know the procedure to create connection string so that he can connect to my database from his desktop.


Thanks in advance. Waiting for a good solution.

Regards,
Venkat.

[jeffstl]

Hi,

I am new to web applications. I have designed one VB 6.0 application with SQL Server 2000 as backend. I have designed a setup package for my application and installed in each and every system in my small office. It is working fine because all my systems are connected to that server.

Now, My client wants the same appliaction to be run on his system. What is the procedure to publish this on internet so that my client can run the same application from his desktop.

Please help me out in the following.

I dont have any idea about .Net.
1. Is there any possible that I can share same setup file with my client so that he can install and start working from his desktop?
2. If yes, please let me know the procedure to create connection string so that he can connect to my database from his desktop.


Thanks in advance. Waiting for a good solution.

Regards,
Venkat.

Is the server that hosts your database available over the internet?

You have to have a DNS\IP address and have a server prepared to handle incoming requests from a remote location.

In other words you can publish your database content into any application; web or otherwise, as long as your have a domain where this data can be accessed and the application is set up to point to that location..

Otherwise you will have to migrate your database on to a existing web server and then modify your app to point to the new location instead of your internal SQL Server.