Solved

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

Posted on 2008-10-27
4
327 Views
Last Modified: 2013-12-17
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
Comment
Question by:jvalescu
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22817369
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
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 400 total points
ID: 22817377
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
 
LVL 26

Assisted Solution

by:Anurag Thakur
Anurag Thakur earned 100 total points
ID: 22819220
check out this site
you can create connection string to whatever database you want to configure
http://www.connectionstrings.com/
0
 

Author Comment

by:jvalescu
ID: 22821941
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Get id from json Data with NewtonSoft 3 32
C# application error "Parameter Is Not Valid". 3 79
Server Error 11 47
how to read json value 2 29
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now