Developer Product Briefs Make a SQL-to-Java Connection SQL Server 2005's Type 4 JDBC driver provides database connectivity from a Java application. Though the driver class and connection URL are a bit ...

In this third example, you use a DSN-less connection to connect to the data source. In this type of connection, you specify all necessary information (the driver, the server, the database name, and ...

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

Click the "Add" button to create a new connection and start the connection wizard. Click the "SQL Native Client" in the list of drivers. The SQL client is included with the Windows 7 operating system.