Unable to geneate trace file

Unable to geneate trace file

am 07.01.2008 11:54:02 von Rameez Fakih

------=_NextPart_000_017E_01C85149.B8CDB2D0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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




------=_NextPart_000_017E_01C85149.B8CDB2D0--

Re: Unable to geneate trace file

am 08.01.2008 23:46:52 von Jess Balint

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/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: Unable to geneate trace file

am 09.01.2008 12:27:11 von Rameez Fakih

It's not working yet

-----Original Message-----
From: Jess Balint [mailto:jbalint@mysql.com]
Sent: Wednesday, January 09, 2008 4:17 AM
To: Rameez Fakih
Cc: myodbc@lists.mysql.com
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/myodbc?unsub=gcdmo-myodbc@m.gmane.org