Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    5

    Smile Unanswered: Connection string for SQL Server 2000

    I am upgrading my SQL Server 6.5 to SQL Server 2000 and i am
    using the following connection string to connect to my SQL Server 6.5
    database.

    Provider=sqloledb;Data Source=.;Initial Catalog=emu;User Id=sa;Password=""

    Do i need to update the provider or any of these settings to connect to SQL Server 2000?

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: Connection string for SQL Server 2000

    Nope, just make sure, you got the latest MDAC (2.7 SP1a) version.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  3. #3
    Join Date
    Aug 2003
    Posts
    5
    Thanks DoktorBlue...

Posting Permissions

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