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:
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.
 
Back
Top