MySQL Forums
Forum List  »  Newbie

Error-provider is not capable of performing requested operation
Posted by: Shital
Date: June 11, 2005 02:43AM

This is my Connection.asp file
<%
Dim REC
Dim str1

Set REC = Server.CreateObject("ADODB.Recordset")

set DBCONN = Server.CreateObject("ADODB.Connection")

str1 = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=paxstor;DATABASE=officedata;UID=root;PWD=abc;OPTION=35;"

DBCONN.Open strConn

str1="Select * from Customer"

REC.Open str1, DBCONN

REC.ADDNEW "CustomerNmae","Jhon"
REC.Update

Set DBCONN =Nothing
Set REC=Nothing
%>

I am getting error -
Object or provider is not capable of performing requested operation
on line - REC.ADDNEW "CustomerNmae","Jhon"

Pl. help me out

Options: ReplyQuote


Subject
Written By
Posted
Error-provider is not capable of performing requested operation
June 11, 2005 02:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.