I keep getting an error when I try and create a new data connection. This is the error I'm getting:
Unable to connect to database.
It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.
I can connect to Access without any problems. Is there anyway around this?
I'm using C# .net Standard with SQL Server 2000.
Thanks for any help.>>It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.
What version?? "C#.net standard" ??
What version of the .NET framework are you using? What IDE are you using?|||Thanks ehorn for reply
I'd like to runVisual C#.net 2003 Standard IDE against SQL Server 2000
I'm using Framework 1.1|||Given that you say this is the error:
Unable to connect to database.
It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.
I imagine that the problem is exactly what it says. That is, the version you are using will NOT allow you to access SQL Server. However, if you install the MSDE on your machine (which is binary compatible with SQL Server) you will be able to access that.|||Thanks Douglas for reply!
It was exactly what I did but now trying to install MSDE I'm getting the error:
'The instance name specified is invalid.'
Will I have to remove SQL Server first then try again?|||I expect so, or alternately, specify an instance name while installing MSDE.
No comments:
Post a Comment