none
Visual Studio 2008 and SQL Server 2012 (This server version is not supported)

    Question

  • Hi,

    I use the dataadapter to generate the dataset, but now when i try to create the connection, it prompt this error message:

    This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.

    Is there any way to solve this problem? or any plan on solving it in the future?

    Wish to hear from you soon.

    ~ Thanks ~

    Friday, October 05, 2012 6:36 AM

Answers

  • Hello fall cky,

    Please, could you tell if you have installed the Visual Studio SP1 ?

    It seems that it is necessary to access a SQL Server  2008 or later.

    Anyway, the documentation of SQL Server 2012 ( and the blog of the SQL Server Express Team ) writes only VS 2010 SP1 or VS 2012 SP1 to be able to connect to SQL Server 2012

    Have you configured your VS to have projects supporting .Net Framework 4 ( not 3.5 which is the default for VS 2008 )

    Please, could you also give the full edition of your SQL Server 2012 ?

    Have a nice day

    PS : you should have a look at

    http://blogs.msdn.com/b/sqlexpress/archive/2011/07/12/introducing-localdb-a-better-sql-express.aspx

    and especially the last answer of sqlexpress . You need to have installed .NET Framework 4 Update 4.0.2

    Even if the article is related to the LocalDB feature of SQL Server 2012, it is necessary for every edition of SQL Server 2012


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.


    Monday, October 15, 2012 6:34 PM
    Moderator

All replies

  • Hi Fall,

    From my research, I think you can currently use the Visual Studio 2008 with SQL Server 2012.

    However you should do some steps as folloing below:

    • First, set the Provider to OleDb. 
    • Then, set your connection string: Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

    More information you can refer to:

    http://social.msdn.microsoft.com/Forums/en-US/vseditor/thread/3beb3c3b-cebb-4b5e-9a9a-4a91f52964e8

    Best regards,


    Ego [MSFT]
    MSDN Community Support | Feedback to us

    Monday, October 08, 2012 7:34 AM
  • Hi,

    I have tried to use OLEDB as well, even though it is able to connect and generate SQL Scripts, however, it still not able to generate the dataset.

    Somemore the parameters generated in SQL Scripts is different from those used in SqlDataAdapter :(

    Monday, October 08, 2012 12:56 PM
  • Hi fall,

    Base on this issue related about connection of sql. We don't support it.

    We are moving this thread to off-topic.

    You can try asking for help from http://social.msdn.microsoft.com/Forums/en/category/sqlserver

    Thank you for your understanding and support.
     
    Best regards,


    Ego [MSFT]
    MSDN Community Support | Feedback to us

    Monday, October 15, 2012 9:37 AM
  • Hello fall cky,

    Please, could you tell if you have installed the Visual Studio SP1 ?

    It seems that it is necessary to access a SQL Server  2008 or later.

    Anyway, the documentation of SQL Server 2012 ( and the blog of the SQL Server Express Team ) writes only VS 2010 SP1 or VS 2012 SP1 to be able to connect to SQL Server 2012

    Have you configured your VS to have projects supporting .Net Framework 4 ( not 3.5 which is the default for VS 2008 )

    Please, could you also give the full edition of your SQL Server 2012 ?

    Have a nice day

    PS : you should have a look at

    http://blogs.msdn.com/b/sqlexpress/archive/2011/07/12/introducing-localdb-a-better-sql-express.aspx

    and especially the last answer of sqlexpress . You need to have installed .NET Framework 4 Update 4.0.2

    Even if the article is related to the LocalDB feature of SQL Server 2012, it is necessary for every edition of SQL Server 2012


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.


    Monday, October 15, 2012 6:34 PM
    Moderator