Re: Select * using Oracle ODBC Driver

What is the code you are using..are you selecting into a recordset, and array, or what... AFAIK, Select * is supported..
( Btw, I would advise using ADO DSN-less connections for ASP rather than ODBC ) - its faster and a little easier to debug.IMHO)

.

petemax7_at_yahoo.com (Pete) wrote:

>Hi everyone,
>I'm trying to switch from MS ODBC Driver for Oracle to the Oracle ODBC
>driver and have run into a problem. In doing a select * statement
>from my ASP page, I get an error that says "Subscript out of range".
>I have been told (by someone here at work) that the Oracle ODBC Driver
>does not support Select *. Can someone confirm this for me? I've
>looked on the Oracle website but have not been able to find anything.
>I'm using driver version 8.00.05.00. I find it hard to believe that
>this would not be supported. If it is true, is there a fix for this??
>BTW, I'm trying to switch to the Oracle ODBC driver because it
>supports commandTimeout which the MS ODBC for Oracle does not support.
>Thanks for any help that can be given!
>
>Pete

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Fri Nov 09 2001 - 12:09:57 CST