Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem getting data with ADO and IIS
If you check out the asp newsgroup, you will notice the problem is pretty
common. You cannot use Oracle odbc driver with ASP. Period. Microsoft
release MDAC 2.0 a while back. That totally messed up the ODBC driver.
The only workaround is to get Intersolve 32bit Oracle driver. I had the similar problem. With Intersolve driver, everything works fine.
jw.
Ulrik Lunddahl wrote in message <7mku7h$iae$1_at_news1.tele.dk>...
>Hey All!
>
>I have some strange problems:
>
>This works fine from ASP:
>
>SELECT SALESID, SALESNAME FROM AXAPTA
>
>I gives me 1232 rows.
>
>SELECT SALESID, SALESNAME, SALESTYPE FROM AXAPTA
>
>This gives me nothing, not even an error, there is simply no rows returned.
>
>I have found out that there is certan fields i can read, bu i can use them
>in a WHERE statement with no problems.
>
>The ODBC driver is Oracle ODBC Driver 8.00.05.00, and the remote oracle
>server is 8.00.04.00.
>
>Why ??????
>
>I spent 5 days to fint a solution on this error, with no luck....
>
>--
>kind regards
>
>Ulrik Lunddahl
>PROconsult Data A/S
>e-mail: ul_at_proconsult.dk
>
>
>
Received on Thu Jul 15 1999 - 20:33:26 CDT