Re: HELP! WHERE statement crashes ODBC

Bruce-

    Do you have ODBC Test that comes with the ODBC SDK? If so, try your query with the WHERE clause in that environment first.

    I would be interested to hear the results.

Sincerely-

David Small
Blessing/White, Inc.

Bruce wrote in message <6cgdiq$egi$1_at_news.bc>...
>I am developing an ODBC access progam using the ODBC SDK 3.0. I have a
>problem. When a SELECT statement is passed to an Oracle data source via
>SQLExecDirect, data begins transfering (via SQLFetch), but after a short
>time the application crashes. This only happens when a WHERE clause is
>included in the SELECT statement. When there is no WHERE clause, the data
>transfer proceeds to completion. The syntax of the SELECT statement is
>correct. Any ideas would be appreciated.
> Thanks,
> Bruce
>
>
>
Received on Thu Feb 26 1998 - 00:00:00 CST