HOWTO: Using Visual InterDev's Database Tools On the InternetLast reviewed: December 11, 1997Article ID: Q175246 |
The information in this article applies to:
SUMMARYThis 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 INFORMATIONIn order to accomplish this task, the following configuration elements are required:
ServerType 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 AddressIP address of the SQL Server (for example, 123.45.6.7)
Network LibraryPath 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.
REFERENCESFor 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 |
================================================================================
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |