#1382 Error with Microsoft SQL Server JDBC Driver 7.2

[Wichart M.]

I used Squirrel SQL Client 3.9.0 try to connect to MS SQL Server Express 2017 with MS SQL Server JDBC Driver 7.2 and got error as in picture attached. May be I miss something, Could you please check and solve for me? Thank in advance.

[Wichart M.]

More information, This MS SQL Server JDBC Driver 7.2 no problem with another, as dBeaver. I checked and set Driver's parameter in the same value.

[Gerd Wagner]

Sorry, I can't reproduce your problem.

Can you give some more details?

For my test I used the driver from here:
https://github.com/Microsoft/mssql-jdbc/releases

[Wichart M.]

Many thanks. I use from Microsoft directly as below, that the lastest version, to connect to MS SQL Server 2017 Express with Squirrel SQL Client 3.9.0. and got problem as shown. As your suggestion I'll try it, if any question, may I ask you for help?
https://www.microsoft.com/en-us/download/details.aspx?id=57782

[Wichart M.]

After I downloaded and used driver from URL you suggested, I still got error as before. Perhap some Drive's properties setting may be conflic. Could you please check it?

[Gerd Wagner]

Two things you may try:

• put as few libs as possible on your extra class path. First try should be the JDBC driver jar only.
• Got to menu File --> Global Preferences --> tab SQL --> Adjust the login time out and see if after a longer time out the connection is created.

[Wichart M.]

I had try as you suggested, and still stucked!

[Wichart M.]

I tried another JDBC Driver, jTDS Driver from SourceForge, got problem too,

[Wichart M.]

But both of these JDBC Driver are working on dBeaver without any setting in Driver's Properties.

[Wichart M.]

OK, now I had solve with jTDS Microsoft SQL Server, Microsoft JDBC Driver 7.2 still stucked!

[Wichart M.]

Execuse me! I noticed that in Squirrel log file show some error that not deal with JDBC Driver. Does this occured due to I use .zip file, (no installation) in my machine or not ?

[Gerd Wagner]

I don't think the log messages have anything to do with your MSSQL problem.

If you know a bit of Java you may try to reproduce the problem with the following code:

Driver driver = 
Class.forName("<YourFullyQualifiedDriverClassName >").newInstance();

Properties myProps = new Properties();
myProps.put("user", "<username>");
myProps.put("password", "<password>");
Connection con = 
driver.connect("<jdbcUrl>", myProps);

[Wichart M.]

I known that the error in this log not related to my MS SQL JDBC error, just doubt that these errors occurred due to I using .zip file no installation instead. So I should be use the installation file to get out of these such error, isn't it ?