error after restotration of nav db

smshyd

Hi all
I am using Nav6.0sp1 and sql server 2005. we shifted the server to another system, It was working fine few hours then
giving error
This message is for C/AL programmers:

Invalid assignment. It is not possible to assign a _Recordset to a Recordset.
can any body tell me what may be the problem

kriki

That look like you are using some automation.
Can you give some more info on what exactly does not work?

smshyd

very thanks for your response kirki,
when I debug it, it is stoping in the below line
ADORecordSet := ADOConnection.Execute(SQLString,RecordsAffected,RSOption);

kriki

Check the subtype of variable ADORecordSet.

You are using "Recordset" but need to use "_Recordset" which is strange because I am using the same code and it uses "Recordset".
What library are your variables using?
I have 'Microsoft ActiveX Data Objects 2.8 Library'.

chi

Hi smshyd
I had the same error when running a report. After recompiling this object, it could be run without error. Have you tried recompiling the object contains the code occurring that error yet?

smshyd

Hi chi,
I compiled and uploaded the licence again. It is working fine.
thank you kriki and chi for your suggestions