Asked by:

Importing data from SQL 2000 database to SQL 2008 database

Question

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.