To create a data source nameTo connect to a database by using ASP pages, you must first create a data source name (DSN) on the WEB server for the type of database that you want to connect to. To do this, use one of the following methods.To create a
Method 1: Using the CreateTableDef method
CreateTableDef method to create a linked table. To use this method, create a new module, and then add the following attachdsnlesstable function to the new module.
Copy Code code as follows:
The following is a brief introduction to several ADO connection methods: ODBC dsn,odbc dsn-less, OLE DB Provider, and "MS Remote" Provider.I.dsnoConn.Open "Dsn=advworks; Uid=admin; pwd=; "Note: It is not possible to use this method from the
Access | data | database
Program Database Classes
ActiveX Data Objects (ADO) is an easy-to-use and extensible technique for adding database access to a Web page. You can use ADO to write compact and concise scripts to connect to Open database
How to solve the connection problem in SQL Server 2000
Applicable
Important: This article contains information about modifying the registry. Before modifying the registry, you must back up the registry and know how to restore the Registry in case of
server| Resolution | How the problem resolves connection problems in SQL Server 2000 apply to important notes: This article contains information about modifying the registry. Be sure to back up the registry before you modify the registry, and be
Today, SQL Server R2 installed, 64-bit, and then can't wait to experience the operation of the connection database, programming language is java. I began to learn a very old connection, using the Jdbc-odbc bridge. The first use is not very skilled,
Access | data | Database A DSN connection requires the server's system administrator to set up a DSN with the ODBC tool in Control Panel on the server, or use a Third-party server component to have your ASP script create DSN by modifying the
This article is part of the "Building a client/server application with Visual FoxPro and SQL Server" series, as the usual "remote view" should not be the opening chapter, but we found that there are too many theoretical things in the articles we
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.