Data Access components with MSSQL 2000

microsoft.public.sqlserver.programming

17 Feb 2006 7:30 PM

MedioYMedio

Can I use an application developed with DAO, ADO or RDO with MSSQL 2000?
(I'm migrating the server)

Are there compatibility issues?

Greetings,

17 Feb 2006 7:33 PM

Yes, you can access SQL Server 2000 using ADO, so an application that can
reference ADO can access SQL Server 2000. That's typically what ADO is used
for. ADO superceeds RDO and DAO, but I believe they can still use the SQL
Server 2000 provider.

Show quote

"MedioYMedio" <MedioYMe***@discussions.microsoft.com> wrote in message
news:72CBE14D-5F52-45C9-8CDA-D702B62DA444@microsoft.com...
> Can I use an application developed with DAO, ADO or RDO with MSSQL 2000?
> (I'm migrating the server)
>
> Are there compatibility issues?
>
> Greetings,