dsn

The Access Object (DAO) provides a common API for accessing data stored in different database management systems (DBMS). Therefore, when you replace the underlying DBMS with another, you do not need to modify the code that uses DAO to access the

Stored Procedures | view | data | database First, the preface ASP (Active server Pages) is a server-side scripting environment that is supported by Microsoft's IIS3.0 version. It can be used to create dynamic Web pages or build powerful Web

Stored procedure 1, calling a stored procedure without parameters Set Conn=server. CreateObject ("Adodb.connection") Set Cmd=server. CreateObject ("Adodb.command") Strconn= "Dsn=pubs;uid=sa;pwd" Conn. Open strconn Set CMD.

Programming | control | data | Database very valuable code, the following code is compiled using ADSI's object database concept, so long as you understand what I said in the previous article, the following code is just ADSI his experiment as long as

This article welcomes the non-commercial use of reprint, but need to indicate from the "Programming Network" and the corresponding URL link. (1) Open the ODBC Data Source Manager in Control Panel, select the "MS Access Database" option in "User DSN"

Coding | tips | optimizing ASP (Active Server Page) is a Microsoft based PWS (Personal Web server) &iis (Internet Information Server) platform The Dynamic Web page development technology based on ISAPI (INTERNETSERVICEAPI) principle is becoming

Stored procedures | Stored procedures learning to use stored procedures (Stored Procedure) is one of the necessary lessons for an ASP programmer. All large databases support stored procedures, such as Oracle, MS SQL, and so on (but not supported by

An ODBC (Open database connection) is an application's interface (API). This interface provides the ability to write applications independent of any data management system. OCBC provides a set of application interfaces for different database vendors

Whether you believe it or not, through the ASP, it may be easy to invade the Web server, the theft of files on the server, capture the Web database, such as the user password, or even malicious delete files on the server until the system damage,

server| Program | Problem Microsoft SQL Server7.0 is a large, distributed database system and can also be considered as a large, distributed data Warehouse. Because of its Windows NT and BackOffice, as well as Visual Studio, are closely matched and

Dreamweaver It's been a long time, so test it. Open index.asp and press F12. As shown in figure (7-49).7-49All in the grasp, because there is no message, so show no message. Post a message for a look, as shown in figure (7-50).7-50This page is also

The number of rows that can be affected directly by the following methods: Dim conn Dim sql Dim lngrecs sql= "UPDATE table1 set field1= ' good '" Set Conn=server.createobject ("Adodb.connection") Conn.Open DSN Conn.execute Sql,lngrecs Conn.close:

mysql| Data | Database Toss a while, finally the ASP and MySQL connection completed, feeling, close-up of this article with you to share. Check a lot of information, ASP and MySQL connection currently has two ways: one is the use of components,

ado| Data | Database I read the article "How to invoke Asscess database and COM program in PHP" after the article, the test immediately, the result failed. Sad isn't it. What to do? I had to go to the official PHP website for help, emperor not

Buy.asp Shopping Blue Src= "Http://edu.cnzz.cn/NewsInfo/file://C:/InetPub/wwwroot/images/title.jpg" > function ID (MYSTR) Pos=0 For I=1 to Len (mystr) If mid (mystr,i,1) = "'" Then If Pos=0 Then Id=left (mystr,i-1) Exit

Program | performance Performance is a very important feature. You need to design the performance metrics beforehand, otherwise you'll have to rewrite the program for that. is to imagine how to optimize the implementation of ASP programs?This paper

ODBC (Open Database Interconnection): An early Database interface technology introduced by Microsoft. It is actually the predecessor of ADO. Early database connectivity is very difficult. Each database has a different format, and developers have a

Scripting | Asynchronous tree structure is a common way to describe hierarchical data. The tree structure generation program introduced in this paper consists of one ASP page and two JavaScript functions. The tree structure is asynchronous, that is,

One install Sybase client Version: Sybase Client 11.9.2 for NT 1 after the installation completes, the operation starts-> program->sybase->dsedit 2 Select Menu ' Server Object ',-> ' Add ' to enter service name like 1.70 3 then select ' 1.70 '

Odbc ODBC File DSN's little secret 1. Use the attached WordPad text editor to create a suffix named. The file for the DSN, formatted as follows, and then saved in text format: Note: The format is important and must be saved as ' text format ',