I have sql server 2000 installed on an nt server and am accessing from w2k on an IIS web site using asp and odbc connectivity. This works fine as the w2k box has sql server installed. When I try to run the web site fron an nt box with only sql server 6.5 it fails with
>Microsoft OLE DB Provider for ODBC Drivers error '80020009'
>Multiple-step OLE DB operation generated errors. Check each >OLE DB status value, if available. No work was done.
I have installed mdac 2.5 on the nt box in question. Could this error be caused by an older version of the odbc driver (3.7 as opposed 2000.81)? That seems to be the only difference between the 2 machines (other than nt vs w2k). Thanks.
>Microsoft OLE DB Provider for ODBC Drivers error '80020009'
>Multiple-step OLE DB operation generated errors. Check each >OLE DB status value, if available. No work was done.
I have installed mdac 2.5 on the nt box in question. Could this error be caused by an older version of the odbc driver (3.7 as opposed 2000.81)? That seems to be the only difference between the 2 machines (other than nt vs w2k). Thanks.