How does jdbc connect to sql server

Search Chat. CData Connect Universal, consolidated data connectivity on-premisis or in the cloud. CData Sync Replicate any data source to any database or warehouse. Relational Databases. Ready to get started? In the New Driver wizard that results, enter the following information: Driver File s : Click Add and, in the file explorer dialog that appears, select the cdata.

The driver JAR is located in the lib subfolder of the installation directory. Then select cdata. SQLDriver from the menu. Name : Enter the name for the driver. Define Connection Parameters Follow the steps below to define required connection properties: In the Service window, right-click the Database node and click New Connection.

Contents Exit focus mode. Is this page helpful? Yes No. Any additional feedback? Skip Submit. Submit and view feedback for This product This page. View all page feedback. Building the connection URL. This file is installed in the following location:. Use the x64 folder. In the entry, include the full path to the library file. Do not include the library file name. Save and close javalibrarypath. Then, on the right of the Apps section, click the Show more arrow to open the apps gallery.

Alternatively, enter databaseExplorer at the command line. In the Name box, enter a name for your data source. You use this name to establish a connection to your database. In the Database box, enter the name of your database. In the Server box, enter the name of your database server. Consult your database administrator for the name of your database server.

In the Port Number box, enter the port number. To establish the data source with Windows authentication, set Authentication to Windows. Or, to establish the data source without Windows authentication, set Authentication to Server.

Under Connection Options , in the Name column, enter the name of an additional driver-specific option. Then, in the Value column, enter the value of the driver-specific option. Click Test. The Test Connection dialog box opens. If you are connecting without Windows authentication, then enter the user name and password for your database. If your connection succeeds, the Database Explorer dialog box displays a message indicating the connection is successful.

Otherwise, it displays an error message. Click Save. Close this dialog box. Set the JDBC connection options. To set the connection options with Windows authentication, use the 'AuthenticationType' name-value pair argument. To set the connection options without Windows authentication, omit the 'AuthenticationType' name-value pair argument.