Unable to geneate trace file

"Rameez Fakih" <[email protected]>
Newsgroups gmane.comp.db.mysql.odbc
Organization Synechron Technologies Pvt. Ltd.
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.