Re: How to display tables on asp pages ?

So you are using a prehistoric driver, that was designed for Oracle 7, and you never know how Microsux dealt wuth the rowid issue. Please upgrade your ODBC driver to version 3.x

Hth,

Sybrand Bakker, Oracle DBA

"Eric Gernot" <gernote2_at_cti.ecp.fr> wrote in message news:3B126518.89621C35_at_cti.ecp.fr...
> I give an example :
> I have a table, "table1" with the following columns :
> "id", "name", "address". The "id" column is the primary key.
>
> The following statements work :
> select name from table1
> select name, address from table1
> select name from table1 where id=10
>
> But these ones do not work :
> select id from table 1
> select * from table1
> select id from table1 where name="moi"
>
> It's the same for the other tables. I can't access the primary key column.
 I
> work with Oracle 8. The driver is "Microsoft ODBC Driver for Oracle"
> 2.00.00.6325.
> I don't get any error message. The response sheet is just empty.
>
> Thanks for help.
>
> Jim Kennedy wrote:
>
> > Not sure I understand the problem. If you issue "select name from
 table"
> > then you will get back all the rows from the table. It has nothing to
 do
> > with primary key columns unless you are trying to have the Jet engine
 handle
> > the selection on your selection (very inefficient). Try posing an
 example
> > of what does not work and the error message you are getting. Also
 please
> > include the versions of things (e.g. Oracle, the driver etc.) that you
 are
> > using.
> > Jim
> >
> > "Eric Gernot" <gernote2_at_cti.ecp.fr> wrote in message
> > news:3B124D64.5B885232_at_cti.ecp.fr...
> > > Hi,
> > >
> > > I try to connect to a Oracle Database using ASP code.
> > > It works with queries like "select name from table". But I can't get
> > > primary key columns, and therefore, the SQL statement "select * from
> > > table" does not work.
> > > I don't think it comes from my ASP code.
> > >
> > > Can someone help ?
> > >
> > > Thanks.
> > > EG
> > >
>
Received on Mon May 28 2001 - 12:00:10 CDT