improve documentation, how to configure the database connection to mssql

[aisbergde]

I am not able to configure any connection to MSSQL

First I got the latest available JDBC driver from Microsoft
Microsoft JDBC DRIVER 8.4 for SQL Server

I added them to a "Klassenpfad"

But I can't connect to any of my mssql servers
I always get this error:

I have no idea about this

net.sourceforge.jtds.jdbc.Driver

and I did not change it. it will be entered when I select mssql

And I tried different servers and different databases, explicit user and integrated security, different strings:

jdbc:jtds:sqlserver://localhost/AdventureWorks2017
jdbc:sqlserver://localhost/AdventureWorks2017
jdbc:jtds:sqlserver://localhost/AdventureWorks2017
jdbc:sqlserver://localhost/AdventureWorks2017;integratedSecurity=true;
jdbc:sqlserver://localhost/databaseName=AdventureWorks2017;integratedSecurity=true;
jdbc:jtds:sqlserver://localhost\SQL2019;databaseName=dhw_self;integratedSecurity=true;

and other combinations

I also could try older drivers. Because I know some other applications which have not been able to use
sqljdbc_8.2 or sqljdbc_7.4, but only sqljdbc_7.2 or older

So I also added these older files to the "Klassenpfad". But nothing helps.

mssql-jdbc-7.2.2.jre8.jar
mssql-jdbc-7.2.2.jre11.jar

I am not a Java specialist, but a database developer.
I was looking for an OpenSource Tool to create WebForms form MSSQL Server database, I found OpenXava and there was mentioned MogwaiER which should be able to reverse engine my databases to generate OpenXava Applications. But I can't even start the basics - to connect any MSSQL database

[mirkosertic]

Thank you for using ERDesignerNG!

ERDesignerNG defaults to JDTS(http://jtds.sourceforge.net/) for Microsoft SQL Dialects. If you add original Microsoft JDBC drivers, you have to change the Driver Classname accordingly (the Treiber configuration option, which is the fullqualified class name).

The SQL-Server manual at https://docs.microsoft.com/en-us/sql/connect/jdbc/using-the-jdbc-driver?view=sql-server-ver15 states the full qualified driver classname is com.microsoft.sqlserver.jdbc.SQLServerDriver

[aisbergde]

@mirkosertic
Thank you very much, this works! I am able to reverse engine. And maybe I will be able to create some WebForms using OpenXava this way :-)
I will try if I can add virtual PK and FK to views.

Could you add some words about configuring connections into the documentation?
For users, not connecting with database using Java so often, this is not so clear.