Hi

I'm upgrading from ADO 2.5 to ADO2.7 Firstly is this
recommended or should I goto 2.6 ??

We have a huge application in VB6 and SQL server 2k, I
need to upgrade our version of ADO so that I can use it
with SQLXML.

Currently the provider for the DB connections is MSDASQL,
can I change it to SQLOLEDB with virtually no impact on
existing code that uses this and currently works with
ADO2.5 ?

regards
Sagie

<sagie (AT) discussions (DOT) microsoft.com> wrote

[snip]
You might try the ADO newsgroups with this question. I'm not sure what the
impact of changing the data provider will be on your code. It probably
depends on how you're using ADO. If you're just using vanilla ADO (ex:
create recordsets using connections and commands) you will probably be fine.
But I really don't know enough to give you an exact answer.

--
Bryant