Solved

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

Posted on 2008-10-27
4
328 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ASP.net 2015 Syncing Azure web app projects on two machines 2 21
imap mails 1 23
SQL Help 27 45
List<PaisEntity> - show some 1 24
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

803 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