Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    6

    Unanswered: Is the connection string for SQL Server and MSDE the same?

    The connection string I'm currently using for SQL Server is Provider=SQLOLEDB;Server=SERVER\VSDOTNET;Database= CCDDbase;Integrated Security=SSPI

    would this be the same query string for MSDE database? I'm quite new in MSDE but I know that except for the tools that comes with SQL Server and its size, they are practically the same...

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You'll obviously have to change the variable parts of your connection string like the server and database names, but other than that you are "good to go" using the same connection string.

    -PatP

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Here's a nice little URL for your favorites:

    http://www.connectionstrings.com/
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •