Updating a RS in a COM

[JayF82]

Hi everyone,

I've been hacking at this thing for the last couple of hours and I just can't seem to get it to work.

I'm trying to update a RS before returning it to my ASP page. The RS is in a VB6 COM.

Everything is working fine if I don't do any update but as soon as I add this:

RS("network") = "2"
RS.Update

The ASP page raises the error -> Automation error The specified module could not be found at the line where I call my COM function

I googled that error msg and it's often related to a corrupted file but in my case it's not the problem as when I remove the two lines and recompile/re-register in IIS it doesn't happen.

My RS parameters are:
RS.CursorLocation = adUseServer
RS.LockType = adLockOptimistic

Any help or pointers would be greatly appreciated this is driving me nuts

 

[Sheco]

Does the "network" field allow text or is it numeric?

Another way to test:
[tt]adoCN.Execute "INSERT MyTable (network) VALUES (2)"[/tt]

Where [tt]adoCN[/tt] is an ADO connection object.

 

[JayF82]

Hi Sheco,

Thanks for the answer, I'm pretty sure it allow text as it's not being queried directly from the db.

It's in the SQL query and I have

Select [...], '' network, [...] from [...]

So its a text value in the RS...or I believe it is...