terça-feira, 6 de março de 2012 02:40
Using the database explorer in Visual Basic 2010 you only have the three data sources
Microsoft Access Database File, Mirosoft SQL Server Compact 3.5, and Microsoft SQL Server Database File.
How do you add the Microsoft SQL Server to this list so I can select a database from the SQL Server 2005 express local server?
Todas as Respostas
terça-feira, 6 de março de 2012 20:13
This forum supports .NET Framework installation and setup.
For best answers to your VB Express configuration question, I suggest you ask here:
quarta-feira, 7 de março de 2012 07:37Moderador
Welcome to the MSDN forum.
You can add a local database through adding the Microsoft SQL Server Database File. You can try these: Choose “Microsoft SQL Server Database File” in Data source>>Continue>>Browse to the SQL Server File location and choose the way of authentication>>Test Connection>>OK.
If you have any other problems, please feel free to let me know.
Alexander Sun [MSFT]
MSDN Community Support | Feedback to us
quarta-feira, 7 de março de 2012 10:04
Hi OregonPass, I have done a comparison between VB 2010 Express and VS 2010 Professional and it seems that the Express version does not have the "Microsoft SQL Server" item, but VS 2010 Professional has it.
I believe this is one of the limitations that exists in Express editions.
quarta-feira, 7 de março de 2012 13:58
If that is the case why did Microsoft include "Microsoft SQL Sever" in the Visual Studio 2010 Express Web package and not the Visual Basic 2010 Express package?
quarta-feira, 7 de março de 2012 16:22
Hi Oregonpass, please have a look at this link: http://msdn.microsoft.com/en-us/library/8czxd086.aspx. If you have a look at the table, you will see "Remote SQL Server Connections" at the very bottom. It states that only VS 2010 Express Web Developer supports remote sql connections whereas the other Express editions do not, therefore you are able to see "Microsoft SQL Server" in the wizard. You will need to add the database file manually as advised by Alexander Sun.
Below are some links that have been posted by other users regarding your question as well for your reference. I hope this helps.