ASP / HTML Links

[Raven_Writer]

Originally posted by seanwitte
It might be that the connection opened using the Jet provider can't handle a recordset and an update query at the same time. Just use an implicit connection like this:

Set MyConn = Server.CreateObject("ADODB.Connection")
	Set RS = Server.CreateObject("ADODB.Recordset")
	
	connectString = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
	MdbFilePath = Server.MapPath("directory\todatabasefile.mdb")
	
	'open the recordset
	SQL_query = "SELECT * FROM files"
	RS.Open SQL_query, connectString
	
	'run the update query
	SQL_query = "UPDATE myTable SET myField = 'foo'"
	MyConn.Open connectString
	MyConn.Execute SQL_Query

If you're running SQL you should ALWAYS use parameterized queries or stored procedures. SQL injection is the easiest way for people to completely screw up your database.

Ok, that works decent...except this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4e' 

Operation was canceled. 

/qtheory/conn.asp, line 9

All the paths are correct, it just deals with this line:

RS.Open SQL_query, connectString

Also, does anyone know the answer to my first question?