topic Re: Establish OLEDB COnnection in Talend Studio

Establish OLEDB COnnection

Anonymous — Sat, 16 Nov 2024 11:07:28 GMT

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

Re: Establish OLEDB COnnection

Anonymous — Thu, 06 Aug 2015 09:06:32 GMT

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

Re: Establish OLEDB COnnection

Anonymous — Thu, 06 Aug 2015 09:18:22 GMT

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

Re: Establish OLEDB COnnection

Anonymous — Thu, 06 Aug 2015 14:08:00 GMT

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