Re: [q] : Table info using ODBC

On Wed, 21 Jan 1998 10:21:18 -0600, ShivKumar <vihs_at_rocketmail.com> wrote:

<snip>
>retcode = SQLTables( hstmt,
> NULL,
> 0,
> NULL,
> 0,
> tablePattern,
> strlen(tablePattern),
> (UCHAR FAR *)"TABLE,VIEW",
> 10 );
>
>

The 4th parameter is NULL, this tells SQLTables to bring back tables for ALL USERS that you have permissions on.

<snip>
>
>Second question :
>
>Oracle ODBC Drivers doesn't seem to behave uniformly. For instance I
>found subtle difference between drivers provided by Oracle, Visigenic and
>Intersolv. And again Intersolv was the best one.

Not supprising, they charge the most for theirs.

>
>Oracle ODBC Drivers ( for 7.x.x ) did not allow me to get more than one
>row at a time. Even when I used SQLExtendedFetch() after setting
>SQLSetStmtOption( SQL_ROWSET_SIZE,... ), I only got one row.
>
>Oracle 8 ODBC Drivers seem to give some other problem(s). I was not able
>to get the table info using SQLTables() as documented in ODBC Manual. It
>said "Driver not capable".

be sure that you are using the latest version of the 8.x driver, (currently 8.0.4), with the latest version of the Oracle 8 client, (also current 8.0.4).

mark Received on Fri Jan 23 1998 - 00:00:00 CST