Establish OLEDB COnnection

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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