Visual Studio Magazine

Make a SQL-to-Java Connection

The SQL Server 2005 database is available in various editions: Enterprise, Standard, Workgroup, Express, Developer, and Mobile. The Enterprise Edition is for enterprise-level applications that require ...
Houston Chronicle

How to Establish an ODBC Connection to the SQL Database

Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save database setup information, so you can open a connection to the ...
Computerworld

How to create SQL Server connection strings in Visual Studio

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...
Analytics Insight

Install Microsoft SQL Server Easily: Quick Beginner’s Guide

Microsoft SQL Server installation is simple when system requirements and edition choices are planned.Choosing the right authentication mode, such as ...
Visual Studio Magazine

Tricks for Processing SQL Scripts

SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...