Re: SQL*net for windows NT and ODBC

ODBC is a Microsoft's protocole which allows Windows applications to access differents databases. In the case of Oracle database, it's based on SQL*Net. Usually this method is running with no great problem.

Any 3rd party tool developping compagny can create their own driver (just like ODBC) to access Oracle database (always by SQL*Net). This is the case of your BRIOQUERY. If you set up SQL*Net For Windows NT, I suppose that the tool loads his own driver (his is transperent to you). Usually, the driver dosen't run very well (with bugs).

Do not make confusion between the real "SQL*Net For Windows NT" which is purchased by Oracle, and a 3rd party tool with the same label.

HTH.
Yang

Maggie wrote in message <8cls63$n6l$1_at_web1.cup.hp.com>...
>What is different for user to read data through SQL*net for windows NT and
>ODBC?
>
>I have a third part tool BRIOQUERY for my user to query data from table.
 At
>beginning, we set up ODBC in the BRIOQUERY to connect the database.
>However, it is very slow to extract thousands of rows.
>
>Hence, we set up SQL*NET FOR WINDOWS NT in the BRIOQUERY. It speed up
 query
>time, which is good. However, sometimes when the user scan the table, he
>always got
>"ORA-01013: user requested cancel of current operation " message, then he
>clicked OK and can still get data. I know this because the user
 interrupted
>an Oracle operation by entering CTRL-C, Control-C, or another canceling
>operation and forces the current operation to end. However, he didn't
>enter any operation to interrupt process. Also, only for two paticular
>table, he got this message. And there is no such problem when he use ODBC.
>
>Is there anyone can tell me what is difference the way to access data
>through SQL*net for windows NT and ODBC?
>
>Thanks.
>
>
>
>
Received on Sat Apr 08 2000 - 00:00:00 CDT