HOWTO: Using Visual InterDev's Database Tools On the Internet

 Last reviewed: December 11, 1997
Article ID: Q175246
The information in this article applies to:
  • Microsoft Visual InterDev, version 1.0
  • Microsoft Visual Database Tools, version 1.0

SUMMARY

This article describes how to set up SQL server and the Visual InterDev client so that Visual InterDev can connect to the SQL server when the connection to the SQL server is via the Internet. A common scenario is when you are developing a Web site on an internet service provider (ISP) from home and using the SQL server located on the ISP's server machine. In this development environment, you are unable to use the Database Tools in the standard way, because the Database Tools require a direct network connection to the database.

MORE INFORMATION

In order to accomplish this task, the following configuration elements are required:

  • The SQL server must have TCP/IP Sockets installed.
  • You must have the IP address of the SQL server.
  • You must have the SQL library DLL Dbmssocn.dll installed on the client.

    You can obtain the DLL by installing SQL Server or Workstation on the client machine. This file can also be copied from a machine that already has SQL Server or Workstation. This file is not in the registry, so it requires no special steps to get it "installed."

Once you have met the above requirements, do the following:

  1. On the client, create a new SQL System DSN.

  2. Enter the following information into the fields listed below.

Server

Type in the name you want for the System DSN; you may reference it in future DSNs. NOTE: If you intend to FTP or CopyWeb the Web application to the ISP's server name the local System DSN the same as the System DSN on the ISP's remote server.

Network Address

IP address of the SQL Server (for example, 123.45.6.7)

Network Library

Path to the DLL for the client to use (for example, "c:\data\ dbmssocn" if the Dbmssocn.dll is located in the C:\Data\Dbmssocn folder on the client machine).

Once all these fields are entered and you click OK, this information is written to the registry. Now, whenever you create a File DSN using the name of the System DSN created above, the client machine knows what IP address to use and how to communicate using the DLL.

REFERENCES

For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site: 

   http://support.microsoft.com/support/vinterdev/


Keywords          : kbDtDbDesigner kbDtDesignSurface kbDtQDesigner
Technology        : kbInetDev
Version           : WINDOWS:1.0
Platform          : WINDOWS
Issue type        : kbhowto

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: December 11, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.