Unanswered: What is the difference between OLEDB and ODBC.
I was creating a asp page that contained a recordset that was opened by calling a stored procedure from Sql Server 2000. At the time I was using an oledb connection and would receive the error:
Item cannot be found in the collection corresponding to the requested name or ordinal.
I then changed the connection string to ODBC and now the ASP runs fine. So besides what I just mention what are the difference that I need to be aware about? Which is better to use? Was I not calling the stored procedure properly using the OLEDB? I am confused.
OLEDB is always faster than ODBC - basically, the levels of communication between your app and the database is smaller with oledb than odbc. Did you have an parameters for the sp (input or output ) ? Did you use the same code for both the oledb attempt and the odbc success ? Which database are you using (include version /sp) ? Which version of mdac are you using ? I ask these questions because this might be a service pack /version issue.