Connecting to SQL Server 2000 Via Internet

Hi guys,

I would like to know how to connect SQL Server-2000 via Internet. I have software developed by VB it is working under Intranet but I need to have it's database connected Via internet remotely.

Thanks

Quote:

Originally Posted by riyazrasheed1234

Hi guys,

I would like to know how to connect SQL Server-2000 via Internet. I have software developed by VB it is working under Intranet but I need to have it's database connected Via internet remotely.

Thanks

This should be the same process as before. Are you having an issue? What errors are you getting?|||

Quote:

Originally Posted by Motoma

This should be the same process as before. Are you having an issue? What errors are you getting?

Still I did not tried. I just trying to find code for the Connection!sqlsql

Connecting to MS SQL DB in other server ?

Hello, All

I have been checking out VB Express for over a week now and I have to say, Im very happy with this Software. Thanks MS

Ok, so far so good I have created a basic APP for use in my office that contains information about clients. Now what I just cant get is, How do I connect to a SQL DB that is in a server at a hosting company ? I have created the DB in the server and all tables now how do I get the connection going ? If any anyone can show me how to do it I would appreciate it or if you can show me a link to a site that has steps by step that would be cool also.

Thank you for your help,

You have to define the conenction string to point to the external server / database: For connectionstrings you can look up the information an www.connectionstrings.com.

You have to know the public adress of the server like the ip adress or the dns name and if you use a default instance or not.

Data Source=81.100.29.81;Initial Catalog=pubs;User Id=sa;Password=asdasd;" --OR

Data Source=81.100.29.81\InstanceName;Initial Catalog=pubs;User Id=sa;Password=asdasd;" --For a named instance.

HTH, jens Suessmeyer.

Connecting instructions?

My host sent these instructions, think they will work?

To access your SQL Server you can use your choice of database management software, including Microsoft Access, Visual InterDev, or the SQL Enterprise Manager.

If you are using Microsoft Access or Visual InterDev you will be connecting to the SQL Server via an ODBC connection, which requires you to make a Data Source Name (DSN) on your local computer.

If you have a Microsoft Access database, and you use the Microsoft SQL Upsizing Wizard to export your database into SQL, the Upsizing Wizard will assist you in the process of creating your ODBC connection.

To create a SQL DSN:

1. Log on to your hosting account's control panel at

http://sahcinfo.org/admin 2. Click "Database Connectivity."

3. Choose "Create DSN."

4. Choose "Microsoft SQL Driver" from the Type drop-down list.

5. Enter a name for your DSN in the DSN field. It can be anything you want it to be, such as "Orders" or "MyDatabase." The Filename field is not required for SQL.

6. In the SQL IP Address field, enter the SQL Server name.

7. Enter your SQL user name in the SQL User Name field.

8. Click Submit.

To access the SQL Server using the SQL Enterprise Manager:

1. Open your SQL Enterprise Manager software. This is not supplied by Web.com.

2. Right-click on "SQL Server Group", then select "New SQL Server Registration"

3. Once the dialog box is open, fill in the fields. In the server field, type in your SQL Server name.

4. Type in the login information with your username and password.

5. Once all the information is entered click "Register." This will make contact with our SQL Server, and you will be able to add tables, manipulate your information and work on your database as you wish.

Please note that Web.com Technical Support will only troubleshoot connectivity to the SQL database, and cannot support issues with third-party software.

Web.com has also created a SQL 2000 User Guide to walk you through the process of setting up your account and database connections. To view or print it, go to

http://64.226.3.32/article.asp?article=14689&p=1001

think they will work for what?

those are standard isp type database connection instructions. What is your question exactly?

i would recommend going with Sql Server as opposed to access and a DSN type connection, but thats just my preference.

hth,
mcm

|||Hi Jerry, what's the problem here? I also vote for Enterprise Manager.