-
Before connecting to the database to read, add, modify, and other operations such as data reading, adding, modifying, etc., an asp page must first establish a connection to the database in the form of adodb, and the connection mode has different specific ways to write according to the different types of databases. Since every asp page that has a database needs to establish a connection, it is more convenient to write the action of establishing this link as a function, and call this function directly when you need to establish a connection. If the database is adjusted, you only need to modify the content of the function, and you don't need to modify every asp page.
The sub you see is a function for establishing a database connection, and the ** of the database is a database of the access mdb file, and the path and name of the mdb file are stored in the xf mdb variable, for example:
xf_mdb = "/database/"
Instead, convert the virtual path specified above to a physical path on the server (e.g. d: inetpub wwwroot database
On Error Resume Next is a program that allows the program to continue running even if an error occurs.
The syntax for connecting to the Access database (called the connection string) is fixed, i.e.
dbq = database address; defaultdir=;driver=;password=database password; "
-
sub openconn()
xf_mdb=def_shopdatabase'Database links.
Instead. sub openconn()
xf_mdb=def_shopdatabase'Database links.
Database path.
The database path should be displayed.
-
ASP is an abbreviation for Active Server Page, which means "Active Server Web Page". ASP is an application developed by Microsoft to replace CGI scripting programs, which can interact with databases and other programs, and is a simple and convenient programming tool. The format of the asp web page file is:
ASP is now commonly used in a variety of dynamics. ASP is a server-side scripting environment that can be used to create and run dynamic web pages or web applications. ASP web pages can contain HTML markup, plain text, script commands, and COM components.
-
ASP functions are similar to VBStrip, ASP functions include ASP functions and user-created functions, which are necessary for ASP web programming to implement functions.
Nothing, I'll give you a few mantras, but practice slowly. >>>More
That's not what you mean:
Table name: price >>>More
There are two main aspects of poor English, first, English grammar; 2. The number of words in English. One cannot be the other. I can't learn grammar thoroughly, even if I recognize each word, I can't understand sentences and articles, I can't write correctly, let alone listen and listen correctly. >>>More
Hard pen calligraphy and brush calligraphy are two different things. If you learn hard pen calligraphy, fast, you can buy a hard pen calligraphy sticker online, there are more than 20 yuan is enough, to the convex one. As soon as I learned it, I got started, and in a month, I was able to write very well. >>>More
Assumption: The variable passed is tt and the value is "2,9". >>>More