CON-120302 Error

[Former Member]

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

[Former Member]

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.....

[DayaJha]

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

[Former Member]

Thanks Daya for your inputs....

[Former Member]

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

[Former Member]

Hi Parthiban,

I have allready added a conection under System DSN & also tested.

Also i have used the same odbc connection in the datastore.

Test is positive even i can view the data from the tables but this error is coming while extracting or transferring the data to/from this tables.

Thanks & Regards,

Rahul

[Former Member]

Hi,

You must check your job server and make sure MySQL is also correctly configured there. From the error it apears that the job server is on Unix platform and therefore must use some type of Odbc driver such as DataDirect. The DSN would be entered in odbc.ini file. Has this been done (info about datadirect odbc should be Found in the install guide.

Thanks

[Former Member]

Thanks Nawfal for your inputs.....