I am a new .Net user. I am trying to use Visual Studio.net 2003 to creat a Windows application. When I try to connect to my SQL server I am getting th efollowing message
"Unable to connect to batabase. It is only possible to connect to SQL server Desktop engine database and MS Access databases with this version of Visual studio.
Someone suggested that I may not have proper security set up. i am not sure where to start checking.
Any help would be tremendoously appreciated
Thanks
Anand
Unable to connect Sql Server from VS.Net
Hot Topic
- ASP.NET
- Sending E-Mails the secure way
- How C# performs sql procedure?
- Delay on first call to web service
- Preparing a Web Service and VB.Net client for easy deployment.
- SQL strings and distributed applications
- How to encrypt messages without X509?
- DataChanged
- Avoid Repetition of primary tables's record
- Cannot start X2 service on machine ‘.’
.NET Development
- Help Required
- Please tell me where can I get a code example about Web distributed application.
- ADO.Net-DataAdapter.DeleteCommand Can't Delete Row
- Bug with NullableConverter ?
- WinForms GUI TEST tools?
- MMC 3.0 SDK
- Installing Net Framework 2.0
- Using HttpWebRequest how to upload a file in Windows application
- Removing element tag names during serialization
- Process.Start() of xcopy only works under the debugger?
Unable to connect Sql Server from VS.Net
LarrySquit
I am using VS.Net 2003 and I am tying to create a VB project.
Any help would be welcome'
Thanks
Anand
Carolyn19162
Ok, then this should be the Visual Basic.NET standard edition. As I already said this is a limitation of the Standard Edition of Visual Basic.NET.You will need to manage using Enterprise Manager since Server Explorer within the IDE will not work with SQL Server.
This has been documented in the following link:
http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon/html/vbgrfVisualBasicStandardEditionFeatures.asp
[See section Server Explorer]
Regards,
Vikram
orc
Thanks, I will do some reading and see what has to be done, I am not yet quite sure how to use Enterprise Manager in the Project. Bu I will follow up with necessary pertinent questions if need be. This is my forst venture into .Net programming. I am a little lost right now and I am hoping I can fit the pieces together quickly.
Do you think I should use the .Net Framework instead of VS Is there any advantages
Thanks and Best Regards.
Anand
Dawgmatix
Thanks, yest it does.
David Zarlengo
Are u able to connect to the SQL Server using Enterprise Manager
Which edition of VS.NET 2003 are u using: Is it Enterprise Architect, Enterprise Developer or Professional
Regards,
Vikram
xp104904
I am using Development Environment 2003 V 7.1.3088 and VB.Net
Yes, I can access using Enterprise manager.
I am not using Windows authentication. Do you see this as a problem
zoranj
Which edition of Visual Studio are you using
You can only access MSDE or Microsoft Access databases with the
Server Explorer in Visual Basic .NET Standard Edition/ Visual C# Standard Edition.
Regards,
Vikram
dpoz
Visual Studio is an IDE which makes it easier to use the .NET Framework. You can continue using Visual Studio and write code that connects to database etc. But in your case, since you have Visual Basic Standard Edition you cannot use the Servere Explorer within the IDE for connecting to the database. Using the server explorer you can manipulate the database by adding, deleting and modifying tables. This can be achieved using Enterprise Manager that comes with SQL Server.
As for connecting to the database from your application using a ConnectionString, that would work from your code whether u write the code using the VS IDE and compile it or simply using notepad and the .NET Framework tools. The IDE provides aids such as debugging etc and so will increase your productivity. Hope this makes it clear.
Regards,
Vikram