Connecting via ODBC to SQLServer 2005 June CTP using MARS

Discussion in 'microsoft.public.sqlserver.connect' started by Florian B., Oct 17, 2005.

  1. Florian B.

    Florian B. Guest

    Hello newsgroup,

    after searching around the web, some reading and testing I'm still having
    problems using MARS via ODBC with the SQLServer2005 June CTP.

    I'm trying to enable MARS by connection string, after some looking about
    "MARS_Connection=yes" should be the setting. That right?
    I found different settings for OLEDB and ADO.NET I don't know why three
    different strings are needed instead of one for all.

    Anyway, it's not working and I'm getting the "connection is already full
    with data from another result" message. I'm using the old odbc client for
    SQLServer 2000, is that the problem?

    I'd really like to use SQLServer in future, but I need MARS because else the
    application would need some restructuring and that's too expensive. Currently
    I'm working with two other DBMS and they work fine when it come to this
    feature.

    Thanks for help,
    florian
     
    Florian B., Oct 17, 2005
    #1
    1. Advertisements

  2. Hi Florian,

    Inorder for MARS to work you will need to use the new SQL Native Client; The
    ODBC client for SQLServer 2000 does not support MARS.

    ADO.NET, OLEDB and ODBC have different connection strings for MARS inorder
    to preserve the naming conventions for connectino attributes bettween the
    different providers.

    Prior versions will get the 'connection busy' errors if you try to use
    implicit multiple connections in and ODBC application.

    Chris Lee has written an excellent blog about this here: It describes
    migrating from MDAC to the SQL Native Client (very easy) and also about
    using MARS
    http://blogs.msdn.com/dataaccess/archive/category/9952.aspx

    There's a great technet article here as well
    http://www.microsoft.com/technet/prodtechnol/sql/2005/marssql05.mspx
     
    Brad Sarsfield [MSFT], Oct 21, 2005
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.