I have been reading past posts about kixtart being able to write to a ms access database. I was intrigued because this feature could be very useful to me. I just ran this sample test script but it says there is an expected expression missing on line 3. I copied this sample from here and plugged in my values.
Code:
$dsn='DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\\greg2k\netlogon\test.mdb'
$sql="INSERT INTO Table1 VALUES('eee','fff')"
$recordset = DBCommand($dsn,$sql)
? 'Error = '+@ERROR+' - '+@SERROR
$sql="SELECT Field1, Field2 FROM Table1"
$recordset = DBCommand($dsn,$sql)
? 'Error = '+@ERROR+' - '+@SERROR
for $row=0 to ubound($recordset,1)
for $column=0 to ubound($recordset,2)
? 'Field(row='+$row+', column='+$column+') ='+$recordset[$row,$column]
next
next
What am I doing wrong?
thanks.
