Verbose output with VC++/ODBC or sqlnet?

Verbose output with VC++/ODBC or sqlnet?

Post by MEB » Thu, 25 Mar 1999 04:00:00



While using sqlplus one gets nice messages like "3 rows deleted", "table
created", etc.
Or if one types sth wrong, one gets a '*' at the position where the error
occures.

How do I get these with VC++ via ODBC?

If it's not possible, how can I use sqlnet? Do I need some Oracle library?

Mirko

 
 
 

Verbose output with VC++/ODBC or sqlnet?

Post by Roy Brokva » Fri, 26 Mar 1999 04:00:00



>While using sqlplus one gets nice messages like "3 rows deleted", "table
>created", etc.
>Or if one types sth wrong, one gets a '*' at the position where the error
>occures.

>How do I get these with VC++ via ODBC?

>If it's not possible, how can I use sqlnet? Do I need some Oracle library?

>Mirko

The short answer:

These messages are created by SQL*Plus. Hence, it is not possible to get
them through ODBC or SQL*Net (which do not use SQL*Plus).

You probably never will use SQL*Net directly. If you create client
applications using any of the Oracle precompilers, your code will use the
OCI (Oracle Call Interface). OCI in turn interfaces with SQL*Net. You may
also program against OCI directly.

There most likely is a long answer, too, if anyone cares to fill me in...

Regards,

Roy Brokvam


 
 
 

Verbose output with VC++/ODBC or sqlnet?

Post by support ema » Tue, 30 Mar 1999 04:00:00


You can get similar information back if using the OCI. Of course the
messages themselves are generated by SQL*Plus, but you can get the
information needed to display your own.
 
 
 

1. History and Output Verbose Levels

I am working in a SQL Server 2000 replication database.  I am trying to
minimize the number of logs in the history tables.  I have read in BOL
that one can set the HistoryVerboseLevel and the OutputVerboseLevel
to the lowest setting to achieve performance benefits.  I believe that
by doing this, the merge agent doesn't write new records to the log,
rather it updates the date/time of the current records with the same
message.

I have tried setting these parameters in the merge agent properties,
but it has had no effect - there have continued to be new logs written
to the history table.

Is there someplace else I should change these settings?

Sent via Deja.com
http://www.deja.com/

2. How to store binary files into a database?

3. Vacuum verbose output?

4. SQL*Plus question

5. Rationalizing EXPLAIN VERBOSE output

6. Crystal Reports Run-time problem

7. output from EXPLAIN VERBOSE

8. Read best Visual Basic books online for free!

9. turning off verbose output of pl/sql?

10. how to manage OLEDB output Param Query in vc++

11. Output parameters in Vc++

12. vc++ and odbc - to open one session with oracle for whole application

13. tempdb growing and growing, odbc, sqlserver, vc++