Forum Home
Press F1
Thread ID: 19644	2002-05-20 06:43:00	Does PWS support Recordset.AddNew?	Guest (0)	Press F1

Post ID	Timestamp	Content	User
49741	2002-05-20 06:43:00	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	Guest (0)
49742	2002-05-20 07:43:00	Upgrade to IIS~ PWS is so limited in it's function.	Guest (0)
49743	2002-05-20 08:56:00	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	Guest (0)
1