Post reply

difference between DotNet and OLE DB connection strings?

  • June 29, 2010 at 2:21 am

    #141693

    I just lost a couple of days debugging why my Packages did not work and I think I understand but I'd like your opinions, please.

    Our SSIS Packages have all their connections soft driven from a table in a database.

    We store the details of that database somewhere in the master database as a boot strap.

    When starting, we need to reset the connection strings of some SSIS Package Connections as well as some variables used to initiate ADO Dotnet connections via scripting.

    It took me a while but I now realise that the format for OLE DB and ADO DotNet connections seems slightly different (but incompatible).

    We only connect to SQL Server (2005/2008) databases.

    Am I right to think that my OLD DB Connection is the same as my ADO DotNet connection with ";provider=SQLNCLI" appended at the end?

    For instance, the ADO Dotnet connection

    "Data Source=ERIC-DELL04\v2008;Initial Catalog=FoxAdmin;User Id=FoxDW;Password=Whatever"

    simply becomes (for OLE DB)

    "Data Source=ERIC-DELL04\v2008;Initial Catalog=FoxAdmin;User Id=FoxDW;Password=Whatever;Provider=SQLNCLI"

    If it is not so simple, I'll have to keep two different connections for each underlying database... 🙁

    Thanks

    Eric

  • July 6, 2010 at 2:47 pm

    #1189344

    The easiest way to answer this is to point you at:

    http://www.connectionstrings.com/

    CEWII

  • July 6, 2010 at 3:11 pm

    #1189352

    Thanks 🙂

  • July 6, 2010 at 3:27 pm

    #1189359

    You are welcome.

    CEWII

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply