Current recordset does not support updating asp my xbox keeps updating

Dim MYSQL Dim rs1 set conn1 = server.createobject("adodb.connection") conn1"provider = oledb.12.0;data source = C:\Users\nam2611\Documents\My Web Sites\Web Site1\Database3.accdb" set rs1 = server.createobject("ADODB. Fields("C_adress_1") = Request.form("adress1") rs1. Fields("C_adress_2") = Request.form("adress2") rs1. Fields("C_post_code") = Request.form("Postcode") rs1. Recordset") MYSQL = "SELECT * FROM customer" rs1MYSQL, conn1 rs1.addnew rs1. Fields("customer_name") = Request.form("custname") rs1. Fields("C_company") = Request.form("compname") rs1. Fields("Phone_number") = Request.form("phone") rs1. Connection, o Rs As Recordset Set o Conn = New adodb. Open DSN On Error Go To handler Set o Rs = New Recordset o Rs. Open Query, o Conn, ad Open Static, ad Lock Read Only Set o Rs. Close Set o Conn = Nothing Set Get Recordset = o Rs On Error Go To 0 Exit Function handler: Set o Rs = Nothing Set o Conn = Nothing On Error Go To 0 End Function I works for simple recordsets, but not with multiple recordsets... I get server-side cursor by commenting out the following lines 'o Rs. The Recordset object is an essential component in Access development, but it often trips up even experienced developers.If both properties are True simultaneously, the Recordset is empty.Tip: Including the Not operator is a matter of efficiency.Susan Harkins explains 12 common Recordset pitfalls you can anticipate and avoid.

After some difficulty upgrading it to SQL - it seems to work almost. Requery 'Read in the new topic's ID number lng Topic ID = CLng(rs Common("Topic_ID")) I really do not know - it is a Web Wiz forum & their support is pretty nill on updating from MSAccess to MSSQL.

Error: Current provider does not support returning multiple recordsets from a single execution I put the following code in a VB object and called from ASP. This problem is caused by closing the connection before retrieving the next recordset.

Public Function Get Recordset(Query As String) As Recordset Dim o Conn As adodb. Although the client side cursor is used, the next recordset is not in the client cursor engine.

If you expect the Recordset to contain records most of the time, it's more efficient to include Not in the check.

The previous technique uses BOF and EOF to expose an empty Recordset before code can generate an error.

Leave a Reply