
errors different when executing SQL statements via recordset or connection object
Hi,
I have a little problem.
When I have a table opened in design mode in Access 97 and execute an
ODBC-SQL SELEDT statement via:
$connection = $Server->CreateObject("ADODB.Connection");
$connection->open("DSN='';uid='';pwd=''");
$connection->execute($_[3]);
I will get the nice error message:
"Table 'X' is exclusively locked by user 'Admin' on machine 'X'"
BUT:
If I do the same with the recordset object:
$connection = $Server->CreateObject("ADODB.Connection");
$recordSet = $Server->CreateObject("ADODB.RecordSet");
$connection->open("DSN='';uid='';pwd=''");
$recordSet->open($SQLquery,$connection,$adOpenKeySet,$adLockReadOnly);
I get the errormessage:
"The request properties can not be supported by this ODBC Driver."
But I want the previous error-message!
Is there anybody who knows how I can generate the same error (of the
first example) with the recordset object (the second example)?
I hope somebody can help me.
Jeroen