Tutorial Northwind, connecting to SQL Express

Posts   
 
    
cgray
User
Posts: 62
Joined: 25-Nov-2007
# Posted on: 29-Feb-2008 04:49:34   

Hello, I am having trouble setting up a database connection to go through the LLBLGen Tutorial.

SQL Server (SQLExpress) is running as a service on my computer (XP Professional). I have downloaded the latest version of the LLBLGen Pro Demo.

I am able to connect to the Northwind database and view data in MS Visual Studio 2005. In Visual Studio I use the following: Datasource=.\SQLExpress;attachDbFilename="C:\SQL Server Sample Databases\Northwind.MDF"

In LLBLGen, I am not clear how to conncet to the local database. I select the database driver: SQL Server 7/2000/2005 Driver (SqlClient) as directed in following the Tutorial.

However, I am not clear what to enter in the Server name text box. I have tried a variety of things, including ".\SQLEXPRESS" and ".\SQLEPRESS\C:\SQL Server Sample Databases\Northwind.MDF"

I also tried "localhost".

Thanks for any assistance in getting started on the Tutuorial.

Carol

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
cgray
User
Posts: 62
Joined: 25-Nov-2007
# Posted on: 29-Feb-2008 23:34:44   

Thanks very much for the quick reply and the helpful links. It turned out that I did have the database attached. But I hadn't used SQL Server Management Studio Express and it was helpful to check that interface.

Turns out that my problem was the Symantec Firewall blocking access. Once I disabled that (I switched to the Windows Firewall.) I was able to see the Northwind catalog.

Thanks!

Carol