Re: Unable to geneate trace file

Rameez,

To enable ODBC call tracing with unixODBC, add the following lines to
odbcinst.ini:

	[ODBC]
	Trace = Yes
	TraceFile = /tmp/odbc.log

Hope this helps.
Jess

On Mon, Jan 07, 2008 at 04:24:02PM +0530, Rameez Fakih wrote:
> Hi There,
> 
>  
> 
> 1) I am using odbc drivers on linux rhel4 (update 4)  using below
> configuration I am not able to get trace file.
> 
>  
> 
> [petra_c5_primary_dsn]
> 
> Driver        = /usr/lib/libmyodbc3.so
> 
> Description   = Connector/ODBC 3.51 Driver DSN
> 
> SERVER        = xxxx
> 
> PORT          = 3306
> 
> USER          = xxx
> 
> Password      = xxx
> 
> Database      = prod
> 
> OPTION        = 4
> 
> SOCKET        =
> 
> TraceFile     =  /tmp/odbc.trc
> 
> Trace         = 1
> 
>  
> 
>  
> 
>  
> 
> 2) I have configured it to be used by dblink from oracle to mysql but I am
> not able to get data for large tables it error as 
> 
>  
> 
> SQL> select count(1) from "rCamPag"@primarydblink;
> select count(1) from "rCamPag"@primarydblink
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> [Generic Connectivity Using ODBC][MySQL][ODBC 3.51
> Driver][mysqld-5.0.34-enterprise-gpl-log]Lost connection to MySQL server
> during
> query (SQL State: S1T00; SQL Code: 2013)
> ORA-02063: preceding 2 lines from PRIMARYDBLINK
> 
>  
> 
> Please suggest
> 
> Regards,
> Rameez Fakih.
> Synechron Technologies Pvt. Ltd.
> Tel: +91-20-30513400 extn: 413 | VoIP: 732-790-5379
> Cell: +91-9960683970 | +91-9860759501
> 
>  
> 

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]