Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Connecting To SQL Server 2k with VS.NET

MattRSMattRS Member Posts: 5
I am trying to connect to a "remote" SQL SERVER 2000 box. When I set-up my connection test the connection it says that my connection succeeded. However, once I click the OK button from the Connection Succeeded message I get another message that says "It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of Visual Studio. I'm using VB.NET Standard edition. Is there something on the install CD I missed, a setting that I need to change? Thanks for your help

Comments

  • chamsterchamster Member Posts: 662
    : I am trying to connect to a "remote" SQL SERVER 2000 box. When I set-up my connection test the connection it says that my connection succeeded. However, once I click the OK button from the Connection Succeeded message I get another message that says "It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of Visual Studio. I'm using VB.NET Standard edition. Is there something on the install CD I missed, a setting that I need to change? Thanks for your help

    What is your OS? I assume that the "remote" server is your machine.


    Kind Regards
    Konrad
    ----------------------------
    (+46/0) 708-70 73 92
    chamster@home.se
    http://konrads.webbsida.com

  • MattRSMattRS Member Posts: 5
    The box I'm doing the VB.NET development on is a Win 2k Server. The remote box that has the SQL Server 2000 on it is also a Win 2k Server. The situation is that I'm creating Win Forms that retrieve the dataset from the remote SQL Server box. Thanks. MattRS


    : : I am trying to connect to a "remote" SQL SERVER 2000 box. When I set-up my connection test the connection it says that my connection succeeded. However, once I click the OK button from the Connection Succeeded message I get another message that says "It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of Visual Studio. I'm using VB.NET Standard edition. Is there something on the install CD I missed, a setting that I need to change? Thanks for your help
    :
    : What is your OS? I assume that the "remote" server is your machine.
    :
    :
    : Kind Regards
    : Konrad
    : ----------------------------
    : (+46/0) 708-70 73 92
    : chamster@home.se
    : http://konrads.webbsida.com
    :
    :

  • chamsterchamster Member Posts: 662
    I ise WinXP and i've never got that error. Sorry i can't help here. :-(


    Kind Regards
    Konrad
    ----------------------------
    (+46/0) 708-70 73 92
    chamster@home.se
    http://konrads.webbsida.com

  • MattRSMattRS Member Posts: 5
    Good News - I went to the Microsoft Knowlegde base an got the answer. Thought I'd pass it along for anyone who might run into the same issue. Here is the answer from MS.

    "If you try to use the Visual Database Tools in Visual Basic .NET Standard Edition to connect to a data source other than a Microsoft Access data source, a Microsoft Jet data source, or a Microsoft SQL Server Desktop Engine (MSDE) data source (for example, Microsoft SQL Server), you receive the following error message - "It is only possible to connect to SQL Server Desktop Engine databases and Access databases with this version." - This error message is misleading. You can use Microsoft ADO.NET code in Visual Basic .NET to connect to other data sources. The limitation that is described in this error message applies only to the Visual Database Tools in this edition."




    : I ise WinXP and i've never got that error. Sorry i can't help here. :-(
    :
    :
    : Kind Regards
    : Konrad
    : ----------------------------
    : (+46/0) 708-70 73 92
    : chamster@home.se
    : http://konrads.webbsida.com
    :
    :

  • chamsterchamster Member Posts: 662
    So, basically, it's not even an error in the first place. Well, it is but not a real one, kind of...


    Kind Regards
    Konrad
    ----------------------------
    (+46/0) 708-70 73 92
    chamster@home.se
    http://konrads.webbsida.com

  • Justin BibJustin Bib USAMember Posts: 0

    ____ < http://forcoder.org /> free ebooks and video tutorials about { MATLAB Scratch Java Visual Basic .NET R PHP C# Swift PL/SQL Visual Basic C JavaScript Assembly Python Ruby Objective-C C++ Delphi Go Perl Scheme FoxPro Kotlin Erlang Clojure Scala ABAP Logo Rust Hack COBOL Dart LabVIEW D Julia SAS Crystal Prolog VBScript ML Awk Fortran Bash Lisp F# Transact-SQL Lua Ada Apex Alice } _____________

Sign In or Register to comment.