Multiple-Step ERROR (Dynamic Cursor??)

[lazytrucker]

Hi I have been making the change from mssql to mysql in order to save myself £10,000 for the mssql evaluation edition.

Everything seemed to be going ok untill the last hurdle when I recieved this error:

<ErrorMessages>
<ErrorCode>-2147217887</ErrorCode>
<ErrorDescription>Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.</ErrorDescription>
</ErrorMessages>

This occurs in a dll which processes using xml (hence the strange reply) However I think the problem arrises when using dynamic cursors in statements like this:

select * from table where colum='" & var & "' and colum2='" & var2 & "'", con, adOpenDynamic, adLockOptimistic

I have enabled dynamic cursors through the odbc but still the errors come any suggestions would be much appreciated.

Cheers LazyTrucker

 

[Bastien]

MySQL seems to prefers a clientside cursor.

See here

We use...

Const adUseClient       = 3
Set PortalDB = Server.CreateObject("ADODB.Connection")

   PortalDB.CursorLocation = adUseClient
   PortalDB.Open PortalStDB, "" , ""

'-----------------------------------------------------------------------------
'          Fetch Flags from system config
'-----------------------------------------------------------------------------
   Set rsConfig = Server.CreateObject("ADODB.Recordset")
   sql = "SELECT 8 "&_
         "FROM   system_config "&_
         "WHERE  System_Configuration = '"& Config &"' ;"   
   rsConfig.Open sql, PortalDB, adOpenDynamic, adLockReadOnly

Bastien

Cat, the other other white meat

 

[ericbrunson]

Of course, you need adodb for that.