Cannot write to SQL Server and also cannot install external jar

[jimbo20814]

Hello, via a referenced project SQL Server metadata connection, I'm trying to write some records (about 5100 records) from Kafka to a SQL table. But I get the below errors. I read in some other related posts people complaining about the Talend SQL Server jdbc driver and to use the Microsoft driver instead. Then when I try to use the MS driver Talend then says to install external jar but the button is grayed out to download/install. So it it really a driver issue? If so how the heck can I install the MS jdbc driver, it won't let me.

I/O Error: Connection reset by peer: socket write error
[ERROR]: lenses.lenses_timeslots_0_1.Lenses_TimeSlots - tDBOutput_1 - I/O Error: Connection reset by peer: socket write error
[FATAL]: lenses.lenses_timeslots_0_1.Lenses_TimeSlots - tDBOutput_1 Invalid state, the Connection object is closed.

[jimbo20814 · Accepted solution]

Realized how to install external jar, my bad. Switched to MS jdbc driver but still having issues. What's weird is I'm able to read from table. I just can't write to table. What's up with that!

I/O Error: Connection reset
[ERROR]: lenses.msdrivertest_0_1.MSDriverTest - tDBOutput_1 - I/O Error: Connection reset
[FATAL]: lenses.msdrivertest_0_1.MSDriverTest - tDBOutput_1 Invalid state, the Connection object is closed.