PDA

View Full Version : Does PWS support Recordset.AddNew?



20-05-2002, 05:43 PM
Hi there...

Title pretty much sums it up, I'm building a webpage with ASP, and I want to use the Object.Addnew command, but it gives me the error:


<%
Dim Connect 'As ADODB.Connection
Dim rsCustomers 'As ADODB.Recordset

ADODB.Recordset error '800a0cb3'

The operation requested by the application is not supported by the provider.

/web/test1.asp, line 17

------------

Here is the offending code:

<%
Dim Connect 'As ADODB.Connection
Dim rsCustomers 'As ADODB.Recordset

Set Connect = Server.CreateObject('ADODB.Connection')
Connect.ConnectionString = 'Provider=Microsoft.Jet.OLEDB.4.0;' & 'Data Source = D:/My Documents/Webpage/Parts1.mdb'
Connect.Open

Set rsCustomers = Server.CreateObject('ADODB.Recordset')
rsCustomers.Open 'SELECT * FROM Customers', Connect, AdOpenKeyset

rsCustomers.AddNew
rsCustomers('FirstName') = 'Erin'
rsCustomers('LastName') = 'Salmon'
rsCustomers.Update
rsCustomers.Close
Connect.Close
%>

What's up?

Cheers,

Erin

20-05-2002, 06:43 PM
Upgrade to IIS~ PWS is so limited in it's function.

20-05-2002, 07:56 PM
Well I could do that, except that I'm not hosting on this machine, merely trialling, and that to use IIS, I need Win2k, NT or XP.

I'm a student, nuff said.

:)

Erin