Establish OLEDB COnnection

One Star

Establish OLEDB COnnection

hi,
i am trying to connect to sql server 2012 using toledbinput because the system is capable of sending data only via oledb connector.
"provider=sqloledb;server=(my i.p)\\SQLEXPRESS;database=mydbname;Integrated Security=SSPI"


am getting many error messages kindly let me know if this is how i should establish a oledb connection.

thanks in advance..

Moderator

Re: Establish OLEDB COnnection

Hi sailesh1809,

You cannot use the specific tMSSQLConnection component(jdbc) to connect to your SQL Server 2012?
Can you connect to your SQL Server 2012 successfully through client without using Talend Tool?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Establish OLEDB COnnection

i need a oledb connection so there is no point of using tMSSQLConnection component(jdbc)  as it is a jdbc based connection.
Six Stars

Re: Establish OLEDB COnnection

Hi Sailesh,
I think you are finished here as this is not built-in to JDBC drivers :-)))
You can extend the component or write custom java code which will utilize the Java-COM Bridge solution:
http://danadler.com/jacob/
Best regards,
Ladislav

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now