• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

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

0
jvalescu
Asked:
jvalescu
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
sorry, the "or" was not complete.
for the reference:
http://www.connectionstrings.com/?carrier=sqlserver2005
or: 
<add name="OrderEntry_prodSQLConnectionString" connectionString="Data Source=your-136e9fe339\sql2005dev;Initial Catalog=OrderEntry_prodSQL;Integrated Security=True;provider=SQLNCLI;"/>
    

Open in new window

0
 
Anurag ThakurTechnical ManagerCommented:
check out this site
you can create connection string to whatever database you want to configure
http://www.connectionstrings.com/
0
 
jvalescuAuthor Commented:
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;"/>
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now