Error while executing a Dataflow in BODS{No default Driver Specified}

[Former Member]

Dear Folks,

My source table is in MS SQL and I want to load the data into Sybase IQ 16.0. What I have done is I have created two data stores in Data services Designer, one for ms sql and another for Sybase. I have created a dataflow with table from SQL as source and Table from Sybase as target. When am executing it am getting the below error:

ODBC call <SQLDriverConnect> for data source <SYBASE> failed: <[Microsoft][ODBC Manager Device] Data source name not found and no default drivers specified>

Please help me on this and find the attachment to view the error.

Thanks,

Mohan

[DayaJha · Accepted solution]

Hi Mohan,

Please refer the below KBA.

1771516 - Error: "Datasource name not found and no default driver specified" in Data Services

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

Thanks,

Daya

[Former Member · Accepted solution]

Hi,

Thanks for the reply, the error was because the Source and Target tables were conflicting with the host and database details.

The issue is resolved.

Thanks....