can anybody please tell me how i can add to a database using ADO. i'm trying the following code<br><br>use OLE;<br>use DBI;<br>$str='c:\abc1.doc';<br>$Conn= CreateObject OLE "ADODB.Connection" ¦¦ die "CreateObject: $!";<br>$rs=CreateObject OLE "ADODB.Recordset" ¦¦ die "CreateObject: $!";<br>$cmd=CreateObject OLE "ADODB.Command" ¦¦ die "CreateObject: $!";<br>$Conn->Open('Provider=MSDASQL.1;Persist Security Info=False;Data Source=chumdb');<br>$cmd->{'ActiveConnection'} = $Conn;<br>$cmd->{'CommandType'} = adCmdTable;<br>$cmd->{'CommandText'} =" resume";<br>$rs->{'CursorType'} = adOpenStatic;<br>$rs->{'LockType'} = adLockOptimistic;<br>$rs->Open($cmd);<br>#$rs->Open( 'resume', $Conn);#, adOpenStatic, adLockOptimistic, adCmdTable);<br>$str1=$rs->Fields(0)->Value;<br>print $str1;<br>$rs->AddNew (0,$str);<br>#$rs->Update();<br><br> but no row is getting added. Please help me.<br><br>Thanks & Regards<br>Srinivas <br><br><br><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
using ADO with Perl
- Thread starter yelimeli
- Start date
Similar threads
