Importing data from SQL 2000 database to SQL 2008 database


  • I created an ODBC connection to the SQL 2000 database, and then used the .NET data provider as the connection to import from.  I was then given the error message Cannot get string literals from the database connection.

    I repeated by attempting to use the SQL Native Client to connect to SQL 2000 and still got the same error.

    Derrick Lau
    • Moved by KJian_ Tuesday, July 13, 2010 1:46 AM (From:SQL Server Data Access)
    Monday, July 12, 2010 5:04 PM

All replies

  • Not sure why you want to use ODBC with .net to connect to SQL Server 2000

    Can you use SQLClient ?


    We need more info including connection string used and sample piece of code?

    Monday, July 12, 2010 5:26 PM
  • Did not use any code; just using the import task of SQL Management Studio 2008.

    I tried with SQL Native client and still the same result.

    Derrick Lau
    Monday, July 12, 2010 6:24 PM