I am setting up a HSODBC connection from a Solaris machine running 10G to a MySQL 4 machine.
We have successfully setup an ODBC link to the remote MySQL server ok.
Created the relevant services for HSODBC connection.
Created the Db Link.
Each time I execute a simple select I get the following error indicating that the Oracle connection is trying to connect to mysql locally.
Does anyone have any good places to trouble shoot.
I have the hsodbc logs which dont offer much more:
From log
-------------------------------
Heterogeneous Agent Release
10.2.0.3.0
[Generic Connectivity Using ODBC] version: 4.6.3.0.0070
connect string is: defTdpName=mysql;SYNTAX=(ORACLE8_HOA, BASED_ON=ORACLE8,
IDENTIFIER_QUOTE_CHAR="",
CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navobj><binding><datasources><da-
tasource name='mysql' type='GENERIC_ODBC_FOR_HS'
connect='mysql'><driverProperties/></datasource></datasources><remoteMachines/-
<environment><optimizer noFlattener='true'/><misc year2000Policy='-1'
consumerApi='1' sessionBehavior='4'/><queryProcessor parserDepth='2000'
tokenSize='1000' noInsertParameterization='true'
noThreadedReadAhead='true'
noCommandReuse='true'/></environment></binding></navobj>
ORACLE GENERIC GATEWAY Log File Started at 2008-07-04T16:33:52
[MySQL][ODBC 3.51 Driver]Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2) (SQL State: 08S01; SQL Code: 2002)
(Last message occurred 2 times)
------------------------
If anyone has any pointers it would be apreciated.
Thanks