Dear Friends,
I have on my pc a well working istance of SQL SERVER 2005.
I can connect with it by "SQL Server Management Studio Express CTP" and successfull create database, table ecc.
But Visual Basic 2005 "Database Explorer" don't view any istance of SQLEXPRESS Server.
The first row of Database Explorer say: "......Data Connection".
In this manner I cannot use database that are inside a SQL SERVER!
What I can do to resolve this issue
Thanks
VB2005 don't view SQL SERVER EXPRESS
baziz
http://msdn.microsoft.com/vstudio/express/support/readme/#exvb
You can manually code to use SQL Server or any other database that .NET supports but the IDE on the Express Products will only work for Access and SQL Server Express.
To get IDE support for other databases, you will need to purchase a version of VB which will provide you with IDE support.
Johnny0910
Yes and no:
Yes, this is a limitation of the IDE - you can only use a local data file.
However, you can connect to any database you like through code.
Remember, this is a free product, designed for learning. If you want greater control over the development experience, then you can upgrade to the standard, professional or team versions of visual studio.
JasonV
Have you tried connecting to a SQL Server file. VB 2005 will connect to a SQL Server 2005 mdf file.
Click on Tools, then click on connect to database. Make sure that your data source is a Microsoft SQL server Database File, then click on the browse button and find your .mdf file, test the connection and if it comes back ok, just click on the ok button.
Hope this helps.
coosa
That is correct, as far as using the built-in Wizards are concerned. You can however, write the connection string in code and it wil work.
james
aka:Trucker
Stijn Fonck
Dear Friend,
.
I have create new database in my istance of SQL Server Express by "Microsoft SQL Server Management Express" . The database is sucessfull create and work good.
With VB EXPRESS 2005 I would access to this database but in my IDE, in Database Explorer i found only this label "Data Connections" and any istance of my SQL Server Express
On this forum I have found the follow:
You are seeing this because the Express editions of Visual Studio 2005 do not support connecting to remote database servers
. By "remote" I mean that you cannot connect to a database that is not a local file in your project, even if the server is on the local machine. In practical terms, this means you can only use SQL Express or Access .mdb files with the Express editions of Visual Studio.
Is correct that there is this limitation in Express Edition and I can only use local database file