asked on

What is the equivalent OLEDB connection string of this SQL connection string?

I need to convert the SQL Connection string below to a OLEDB connection string in order to use a certain 3rd party control. Having all kinds of fun with it..................

As you can see, we are connecting to a SQL Server Express 2005 database.

<connectionStrings>
    <remove name="OrderEntry_prodSQLConnectionString" />
    <add name="OrderEntry_prodSQLConnectionString" connectionString="Data Source=your-136e9fe339\sql2005dev;Initial Catalog=OrderEntry_prodSQL;Integrated Security=True" providerName="System.Data.SqlClient"/>
    
    
 </connectionStrings>

Open in new window

Guy Hengel [angelIII / a3]

that would be:

<add name="OrderEntry_prodSQLConnectionString" connectionString="Data Source=your-136e9fe339\sql2005dev;Initial Catalog=OrderEntry_prodSQL;Integrated Security=True;provider=SqloleDb;" /> 
or: 
<add name="OrderEntry_prodSQLConnectionString" connectionString="Data Source=your-136e9fe339\sql2005dev;Initial Catalog=OrderEntry_prodSQL;Integrated Security=True;provider="/>

Open in new window

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Anurag Thakur

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jvalescu

ASKER

This is the one that did it for me, thanks!

<add name="OrderEntry_prodSQLConnectionStringOleDb" connectionString="Provider=SQLNCLI;Server=your-136e9fe339\sql2005dev;Database=OrderEntry_prodSQL; Trusted_Connection=yes;"/>