June 5, 2009 at 6:04 pm
Every time I try to add a new data source in VB2008 I get a message which reads as follows:
Connections to SQL Server files (*.mdf) require SQL Server Express to function properly. Please verify the installation of the components or download from URL http://go.microsoft.com/fwlink/?linkId = 49251
Does anybody know how to fix this? I have installed both VB2008 Prof. Ed. and SQL Server 2008 twice thinking that it was an installation error but problem still persists. As consequence I cannot see the tables in the solution explorer
June 5, 2009 at 6:45 pm
VS2008 is trying to connect to SQL Server Express which is installed by all VS2005/8 installations so you have to manually create connection at the top of VS2008 go to tools then connect to database in the section that is server click it and remove Express and add the SQL Server and then create the connection.
Kind regards,
Gift Peddie
June 5, 2009 at 7:21 pm
I could not follow your directions. Can you be more specific please.
Thanks
June 5, 2009 at 7:46 pm
Here is an attachment for the add connection object, I have two pictures showing the difference. You must know I have SQL Server 2005, 2008 and 2008 Express so I have to click and change the server name as needed at my point of connection.
Kind regards,
Gift Peddie
June 5, 2009 at 8:04 pm
Gift: Thanks for your suggestions. When I installed VB2008 I named the instance SQLEXPRESS to follow the Murach' VB 2008 by Anne Boehm. When I first encountered the problem I downloaded what was suggested in msd.com and installed a new SQL server instance which I called newsqlexpress. I can connect to the database and test the connection but when I click finish in the Wizard is that I get the message. I tried what you told me. In the dropdown box I can see the instances SQLEXPRESS and NEWSQLEXPRESS but regardless of which one I use I get the same error. If you have any ideas I would really appreciate it.
Thanks for your time and consideration
June 5, 2009 at 8:31 pm
I think I have found it is related to SQL Server Express here are the directions of how to fix it, I checked mine and found 2005 in there but you know I have three instances running so follow the directions in the links below and post again. There are very good VB tutorials from Microsoft I will find those and post again.
http://predicatet.blogspot.com/2007/01/connections-to-sql-server-files-mdf.html
Kind regards,
Gift Peddie
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy