Solved

SQL Server Connection String

Posted on 2012-03-27
9
538 Views
Last Modified: 2012-06-21
I have migrated a Microsoft Access 2010 database to Microsoft SQL Server 2008.  Is the following connection string correct?

    <add name="ConnStrNSMDB" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=vcnsql90\i90;User ID=nsm1171;Password=[Secret Password];Initial Catalog=nsm;" providerName="System.Data.SqlClient"/>
0
Comment
Question by:Ray Turner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 37770837
0
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 500 total points
ID: 37770869
Specifically http://www.connectionstrings.com/sql-server-2008

Much depends on your server set up and how you want to connect to it.
0
 
LVL 20

Expert Comment

by:BuggyCoder
ID: 37770891
Just remove provider key:-

<add name="ConnStrNSMDB" connectionString="Data Source=vcnsql90\i90;User ID=nsm1171;Password=[Secret Password];Initial Catalog=nsm;" providerName="System.Data.SqlClient"/>

Open in new window

0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 8

Expert Comment

by:PeteEngineer
ID: 37770995
0
 
LVL 8

Expert Comment

by:PeteEngineer
ID: 37770999
Or do this:

 In the design view drag in the sql data source object and configure from there.
0
 
LVL 16

Expert Comment

by:Rose Babu
ID: 37771155
remove Provider=Microsoft.ACE.OLEDB.12.0; in the connection string and update the connectionstring as below.
  <connectionStrings>
    <add name="ConnStrNSMDB" connectionString="Data Source=vcnsql90\i90;Initial Catalog=nsm;User Id=nsm1171;Password=[Secret Password];" providerName="System.Data.SqlClient"/>
  </connectionStrings>

Open in new window

Try this
0
 
LVL 35

Expert Comment

by:YZlat
ID: 37771170
you are connecting to SQL Server databse and Microsoft.ACE.OLEDB.12.0 is a provider for Access db
0
 
LVL 13

Expert Comment

by:Rick
ID: 37771487
<connectionStrings>
<add name="ConnectionNameHere" connectionString="Data Source=server.domain.com;Initial Catalog=DatabaseNameHere;Persist Security Info=True;User ID=UserIdHere;Password=PasswordHere;pooling='true';Max Pool Size=240;Connection Timeout=600" providerName="System.Data.SqlClient"/>
</connectionStrings>

Open in new window

0
 

Author Closing Comment

by:Ray Turner
ID: 37774971
Thanks!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 data base connection 35 95
Database Owner 3 46
history of pages 7 54
.NET universe documentation poster 2 25
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

751 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