28 novembre 2003 alle 03:33:23

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/handicapscuola/aspnuke/setup.asp, line 283

01 dicembre 2003 alle 07:02:19
Modificato il 01 dicembre 2003 alle 07:07:44

Before using the ADO Objects to access your database you need to load them into memory from the ADODB library. For ASP this is different than in VisualBASIC. To load the ADO Objects you are going to use into memory you must first declare the variable names with the Dim statement. Then use the Set statement and Server.CreateObject function to create them.

Example:

Dim Conn, RS 'Declares the Conn (Connection) and RS (Recordset) variables

Set Conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")

By: Matthew Holder

Once you have made your database objects, next you must connect to a database and open table or run a query on a table. The table or query will get your RecordSet, a set of records that matches a special set of rules. These records may be updated, or you can add new records to the table that the record set was queried from, if it was queried from one table.

To connection to a database you need to give the ADO's Connection object a DSN. In the case of DomainDLX that would be a DSN string that returns a DSN-Less connection. (confusing huh?) Well, we do this by calling the Open method.

ADODB.Connection.Open DSNString

To continue from the Starting Point page we would do the following to open a database:

DSNStatement = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
DSNStatement = DSNStatement & Server.MapPath("/USERNAME/database/mydatabase.mdb")
Conn.Open DSNStatement

Now, your database is opened, you just need to open or query a table... This is a little trickier. A little SQL knowledge will help here. Here we will use SELECT * (to select any field) FROM Table (from the table Table) WHERE (((Table.Field)='Value') AND ((Table.Field2)='Value2')) (where the Field from Table = Value and the Field2 from Table = Value2). This will explain querying. The only time when you will use WHERE is when you want to query a select set of record where certain rules apply and in ( ) you place those rules. Once your table is selected and your rules set and put in a string you need to call the Open method for the Recordset object.

ADODB.Recordset.Open SQLCommand, ActiveConnectoin, CursorType, LockType, Options

Example:

SQLStatement = "SELECT * FROM Table WHERE "
SQLStatement = SQLStatement & (((Table.Field)='Value) AND ((Table.Field2)='Value2'))
RS.Open SQLStatement, Conn, 3, 3
'These options will open the database for writing while allowing others to still read it.