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