October 5, 2005 at 8:35 am
Hi everyone,
Hope u are all ok, got a bit of a question.
We have all our website connections setup as ODBC but have now changed them to OLEDB connections. Everything seems ok, but i am getting an error with a sproc that returns a select statement, it says the field is not valid, but it is definetly there.
Can anyone tell me if there is anything that you have to code different when using OLEDB instead of ODBC??
And here is the error.
Com Error No. = -2146824584
Description = Operation is not allowed when the object is closed.
This refers to the line where i do "If Not (RS.EOF And RS.BOF) Then".
On another page, where i return a select statement made up of variables.
i.e. Select @NoOfPage As NoOfPage, @NoOfTitles As NoOfTitles
I get the following error when accessing the value
Com Error No. = 2146825023
Description = Item cannot be found in the collection corresponding to the requested name or ordinal.
On my asp page all i am doing is
Title = RS.Fields.Item("NoOfTitles").Value
I have now changed the connection back to ODBC and everything works, so how can i get it to work with OLE??
Thanks everyone is advanced
October 5, 2005 at 8:52 am
Please do not cross-post. If someone knows the answer they'll help you.
Finish the thread here :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=20&messageid=226173
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply