Cannot add new database connection....

leroy1260

Member
Joined
Apr 4, 2011
Messages
8
Programming Experience
Beginner
I have created a database in Microsoft SQL SERVER 2005
When I Start with my Microsoft Visual Basics 2008 Where I create a new project using Windows Form and after that
Add Data Source -->Database-->New Connection

I want to change my data source to Ms SQL SERVER 2005 but it is not showing in the list

when I click on change button to change the source.....only options displayed are :
MS Access Database File
MS SQL SERVER compact 3.5
MS SQL SERVER Database file

I have tried the second and third option shown above and I get this error (unable to open the physical file "C:\Program Files\ Microsoft SQL SERVER \MSSQL.1\DATA\Library.mdf" Operating System Error 32:)
 
Last edited:

JohnH

VB.NET Forum Moderator
Staff member
Joined
Dec 17, 2005
Messages
15,589
Location
Norway
Programming Experience
10+
VB Express IDE does not support server-based connections, only file-based.
You could detach your server db and use the .mdf for file connections. Later, if needed after development, you could attach it to server permanently and just change the connection string in your app to connect to the server db instead.
 
Top Bottom