Create a JDBC Connection to SQL 2016 SP 1

[gvarghese1993]

I am trying to create JDBC connection to SQL Server 2016. Got the JDBC drivers  as per the link:

Download Microsoft JDBC Drivers 6.0, 4.2, 4.1, and 4.0 for SQL Server from Official Microsoft Download Center

I am not able to create a connection. It says "Modify details in the fields below to provide a unique name, a list of required jars, and set any available and applicable property values." This has been set in the the screen shot below:

So I have included the  drivers and connection properties. However I am not able to click OK and go back to test  connection. I checked the SQL server is running and listening on port 1433

Any thoughts, why I am doing wrong

[rareddy]

Go to the Name/Type tab, and provide name like "Accounts Database" then OK button will be enabled.

[gvarghese1993]

So, I tried that and still not able to click on OK.

[rareddy]

Well there is some other name or property you did not provide the dialog is looking for, find it and fix it then OK button will be enabled.

[blafond1]

Let's start with your installation/configuration...

What is your version info for JBDS & Teiid Designer?

Access it via the Help > About Red Hat JBoss Developer Studio dialog

Assuming JBDS 10.1 + Teiid Designer 10.0.2.Final?

[blafond1]

After further investigation.. it appears you launched the "New Connection Profile" wizard from Designer's Advisor panel.

You selected SQL Server type, but already had a SQL Server driver definition and clicked the "Edit" button (triangle icon).  Clicking this launched the Edit Driver dialog which requires you to change something in order to enable the OK button.

Note that creating and editing JDBC Drivers is managed somewhat independent of Connection Profiles which use driver configurations.

[gvarghese1993]

Tejid Designer is 10.0.2 and JBDS is 10..2. GA

r is

[gvarghese1993]

I am not sure what you mean by "Note that creating and editing JDBC Drivers is managed somewhat independent of Connection Profiles which use driver configurations."

[rareddy]

It is an implementation detail, IMO it not be too concerned about. What needs to be done is, first you need to load the JDBC driver, and configure the properties JDBC URL, user and password kind of details as a template first. Most of the times these templates are already there but the driver file is not. So, you would need to make sure you add the JDBC driver file and make sure the path is correct. Then using that template you create "connection profile" with actual values to your source, that will create the connection.

[gvarghese1993]

Please verify that I can use the JBDC driver  from Microsoft as per the following link

Download Microsoft JDBC Driver 6.0 for SQL Server from Official Microsoft Download Center

• Sqljdbc42.jar requires a JRE of 8 and supports the JDBC 4.2 API