Re: Q+E ODBC, SQL Statements
Date: 1995/06/06
Message-ID: <odysscci.363.00151776_at_teleport.com>#1/1
In article <1995Jun6.120206_at_msserv.rz-berlin.mpg.de> lawrenz_at_fhi-berlin.mpg.de writes:
>Path: nntp.teleport.com!news.reed.edu!sun.lclark.edu!netnews.nwnet.net!news.uoregon.edu!cs.uoregon.edu!reuter.cse.ogi.edu!uwm.edu!math.ohio-state.edu!cs.utexas.edu!news.sprintlink.net!EU.net!Germany.EU.net!nntp.gmd.de!news.rwth-aachen.de!news.rhrz.uni-bo
>n.de!news.uni-stuttgart.de!news.belwue.de!news.belwue.de!fu-berlin.de!neptun.rz-berlin.mpg.DE!not-for-mail
>From: lawrenz_at_fhi-berlin.mpg.de
>Newsgroups: comp.databases.oracle
>Subject: Q+E ODBC, SQL Statements
>Date: 6 Jun 95 12:02:06 +0100
>Organization: Fritz-Haber-Institut, Berlin
>Lines: 19
>Message-ID: <1995Jun6.120206_at_msserv.rz-berlin.mpg.de>
>NNTP-Posting-Host: neptun.rz-berlin.mpg.de (141.14.128.169)
>X-Access: 16 25 816
>--
>Hi folks,
>does anybody know how I can have a look at the exact sql statement a
>session is executing at the moment ?
>Or is it even possible to log the sql statements that are beeing sent
>from an MS Access application via the Q+E ODBC driver to SQL*NET ?
>Thanks
>Peter
>-----
> _|_ Sometimes you loose, sometimes the others win.
>---*--O--*---
> O O X Peter Lawrenz (DFV3772)
> X X http://www2.rz-berlin.mpg.de/~lawrenz/
> X lawrenz_at_fhi-berlin.mpg.de irc: zaremba
> FreeFall-> FreeBag-> FreeBeer
Ah the dreaded Access. Yes, you can turn on ODBC trace. Go to the control
panle and then bring up the ODBC thing. Press the options button and you
should be off. There are also shareware tools that make the reading of the
odbc trace bearable. Look at windows archives. Also you can alter your
session to turn trace on alter session set sql_trace=true; I think. Please
check the syntax. If you do this via pass thru in Access you should generate
a trace file. You can then use tkprof to deal with it. (Or you can read it
your self)
Jim Kennedy Received on Tue Jun 06 1995 - 00:00:00 CEST