RE: Unable to geneate trace file

It's not working yet

-----Original Message-----
From: Jess Balint [mailto:[email protected]] 
Sent: Wednesday, January 09, 2008 4:17 AM
To: Rameez Fakih
Cc: [email protected]
Subject: 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
> 
>  
> 



--------------------------------------------------------------------
Mail Disclaimer: This e-mail and any files transmitted with it are confidential and the views expressed in the same are not necessarily the views of Synechron, and its Directors, Management or Employees. This communication represents the originator's personal views and opinions. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail by error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. You shall be under obligation to keep the contents of this e-mail, strictly confidential and shall not disclose, disseminate or divulge the same to any Person, Company, Firm or Entity. Even though Synechron uses up-to-date virus checking soft
 ware to scan it's emails please ensure you have adequate virus protection before you open or detach any documents from this transmission. Synechron does not accept any liability for viruses or vulnerabilities. The rights to monitor all e-mail communication through our network are reserved with us.

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