Hi,


You connect to the Server (Anderson\VSDOTNET) and set nwind as the default database (initial catalog). Table level is only relevant in subsequent SQL statements. The simplest way to get the connection string right is probably to drag the relevant table onto a form and look in the 'Designer generated code' region for the ConnectionString constructed by .NET .

HTH,
Viv

>>
When the Server Explorer is open in VS.NET. There are several connections. Towards the bottom I see


SQL Servers
+ Anderson
- Anderson\VSDOTNET
+ Master
+ msdb
- nwind (with a cord image comming from it)
+ Database Diagrams
- Tables
+ Employees
etc.


What would the connection string look like to make the connection with the Employee table within the NWIND Database
>>