Skip to Content
author's profile photo Former Member
Former Member

CON-120302 Error

Hello Friends,

I am facing CON-120302 error while extracting or transferring data to MySql.

I am getting following error in the DS,

ODBC call <SQLConnect> for data source <test_sql> failed: <[MySQL][ODBC 5.1 Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)>. Notify Customer Support.

Datastore connection parameters are mentioned as below.

Please guide me on this issue.

Thanks & Regards,

Rahul More

DataStore.png (73.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Sep 13, 2013 at 07:38 AM

    Hi Rahul,


    Please refer the below SNotes from SAP Market Place.

    1514119 - Error: "CON-120302...ODBC call <SQLDriverConnect> failed...Data source name not found and no default driver specified - DS and IS

    Links:

    https://service.sap.com/sap/support/notes/1514119


    1243336 - Error: "ODBC call for data source failed....SQL Server does not exist or access denied" when running a job in Data Integrator (DI)

    Links:

    https://service.sap.com/sap/support/notes/1243336


    Or

    Please refer below Documents.

    BODI 2006 Data Service Installation Issue:

    Links:
    http://scn.sap.com/docs/DOC-31062

    Thanks,

    Daya

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2013 at 12:14 PM

    Hi,

    I faced a similar issue with MSSQL database in the datastore connection, because of Missing MSSQL Native driver installation. Hence, i created an ODBC Connection and resolved the issue.

    Did you try creating ODBC Connection and using it for Datastore instead?

    • Open "ODBC Data source Administrator"
    • Go to "System DSN"
    • Add a new connection, Test and save it.

    Use this newly created ODBC Connection in the Datastore.

    You can also create new configuration under 'Edit Datastore' and utilize this connection.

    Thanks,

    Parthiban

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 30, 2013 at 07:26 AM

    Hello Friends,

    Actually i have already maintained the DSN names but then also this error was coming.

    Then i asked the basis person to look into this issue.

    As BODS server is installed on Linux, basis person has created a symbolic link for this & this problem got solved...

    Thanks for input from all of you.....

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.