Does SQL ODBC Driver for SQL 2000 works with SQL 2005

Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
edited 2008-08-13 in SQL General
Don't ask me why, but the customer wants/needs to use Sql ODBC Driver from SQL 2000 with a SQL 2005 database (with Dynamics NAV). Does this work?

EDIT: I have some more info now. They want to query the NAV database to get some data into Access. The PC has the ODBC drivers installed for SQL 2000. The NAV data is stored in a SQL 2005 database. I guess it's not a problem when one only reads data?
No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)

Comments

  • garakgarak Member Posts: 3,263
    i use ODBC Driver "Microsoft SQL Server ODBC-Treiber Version for 2000" and Excel to connect to NAV on an 2005-er server and the queries still work.

    Regards
    Do you make it right, it works too!
Sign In or Register to comment.