Hi

just begun playing around with VB and SQL programming, and have a question.
When I'm making a data source in my project I want to set up a SQL server
connection. But, I see that I have 2 choices, Microsoft SQL Server and
Microsoft SQL Server Database file. What are the differences between these
to sources?

/A.

The "Microsoft SQL Server" interface assumes you're connecting to a named
instance of the SQL Server service which has the target database already
installed. The "...Database File" option builds a connect string that points
to a .MDF database file that's attached (on first use) to the specified SQL
Server instance.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]