Tutorials to .com

Tutorials to .com » Asp » Database » ASP Database Related

ASP Database Related Articles


121: ODBC keyword Collection
The following are keywords ODBC function call, when using ODBC, they should avoid using them. ADD EXIT PRIMARY ABSOLUTE EXEC OVERLAPS ACTION EXECUTE PAD ADA EXISTS PARTIAL ADD EXTERNAL PASCAL ALL EXTRACT POSITION ALLOCATE FALSE ...

122: Collection of T-SQL keywords
Debugger often encountered some keywords prompted the use of the wrong. The term are the following T-SQL statement in the keywords in you to write SQL statements, stored procedures, triggers, or field name, such as to avoid the use of these words. ...

123: Using ASP to access a variety of commonly used type of database (a)
Abstract: This article discusses the use of ASP to access DBF, DBC, MDB, Excel, SQL Server-based data and function, and finally give a use of the function This article provides database access to Excel example, the reuse and sharing of enterprise d...

124: Using ASP to access a variety of commonly used type of database (b)
Second, connect the database and open the data table Different database connection methods are different (that is, the establishment of Connection as an example of method), once established finished Connection example, using Recordset object to acc...

125: Using ASP to access a variety of commonly used type of database (c)
2) the establishment of Mdb password database with the Recordset object, the establishment of its way with the establishment of non-password Mdb database Recordset object is similar to a password only parameter, that is, with the database connection...

126: Using ASP to access a variety of commonly used type of database (d)
4) generated by the Foxpro database with MDB database DBC is similar to a database contains several data form, so access to the DBC database MDB database with similar methods. Function CreateDbcRecordset (DBC database file name, data tables or Sele...

127: Using ASP to access a variety of commonly used type of database (e)
6) SQL Server is Server-class database, use a more stringent requirement must be requested to enter a user name and password to use. Function CreateSQLServerRecordset (computer name, user ID, user password, database name or to view data sheets or S...

128: Access MySQL using ODBC Interface Guide
Access MySQL using ODBC Interface Guide Current Author: Wang Meng (HeartIcy@163.com) Create Date: January 15, 2003 Revised version: 1.1 MySQL's own good or bad I am still always think that this is not a programmer or system designers should ...

129: ADO error code
Subscript list drawn off from the standard ADO error operation. Description of the code constant providers adErrProviderfailed 3000 failed to complete the requested action adErrInvalidArgument 3001 applications are using the type of errors, beyon...

130: Most of the ADO error code corresponds to the meaning of
In addition to the Error object and Errors collection that error outside of the provider, ADO itself will also be wrong to return to the run-time environment of the exception handling mechanism. The use of programming language mechanisms to capture ...

131: Asp debugging stored procedures
asp development bs three-tier system architecture, the system for small and medium-sized structure on the business logic inside sqlserver stored procedure is a good method, but to do so there is a asp client and match between the database stored pro...

132: The data into the database in two ways
The data in the form inserted into the database in two ways. 1. Direct the use of sql statement Advantages: fast, non-consumption of resources Disadvantages: can not transfer the contents of the field too long, a long time relatively easy field t...

133: Sophisticated SQL statement
See the original posted detailed ^ _ ^ Description: Copy table (only copy the structure, the source table name: a New Table Name: b) SQL: select * into b from a where 1 <> 1 Description: copy table (copy the data source table name: a target...

134: Connect database with ASP
Original Author: Alan Saldanha IIS3.0 with Microsoft's ASP as Web site building can be, INTRANET applications to build a flexible approach, he can easily access ODBC-compliant database. This article, we will learn the basic operation of the da...

135: ASP to create SQL Server database in two ways
Method One: <% '************ ************************ Used to create objects ADODB.Connect Dim oConn Dim sDatabaseName sDatabaseName = "CodeCreateDB" Set oConn = Server.CreateObject ( "ADODB.Connection") oConn.Open ...

136: ACCESS access when "80004005" Couldnt Lock File "" wrong solution
Apply to: Microsoft Active Server Pages Microsoft Data Access Components 1.5 Microsoft Data Access Components 2.0 Microsoft Data Access Components 2.1 Microsoft Data Access Components 2.1 SP1 Microsoft Data Access Components 2.1 SP2 Microsoft...

137: Operation of the database structure
Author: tonny Reprint, please show the source: http://www.weiw.com Operation of the database structure. Adapted to access, sql server database, such as common. 1. Establish a connection. Through ODBC or OLEDB connection. Set gObjDC = Server.Cre...

138: Various databases through the ADO connection string Tsui set (a)
In the process of network programming, ADO (Activex Data Object) programming are often the work is indispensable, especially the development of e-commerce sites. As mentioned ADO data objects, then the way to brief you on ADO data objects and functi...

139: Various databases through the ADO connection string Tsui set (II) (End)
(Connected to articles) 22, followed by talk about the use of OLE DB to connect to the database example. 1) OLE DB Provider for Active Directory Service <% Dim oConn, strConn Set oConn = Server.CreateObject ( "ADODB.Connection") S...

140: Page Control
First of all, read the first database, and retrieve query results and build-up Open the database part of ... ... omitted All data will be assembled in an array of variables sum = rs.recordcount 'recorded information on the total amounts inqui...


Page 7 of 32
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]