Can SqlSrv2k use ADO and ADO.net from VB?

[Rich]

Hello,

I have several VB6 apps that access Sql Server2k using ADO
(mdac 2.6). I am stepping up to dotnet and have loaded
vs.net on a workstation.

1st, do I need to do anything to sql Server2k to access it
using ado.net? 2nd, can I use regular ADO in vb.net?
3rd, if I use ado.net to access Sql Server2k from vb.net
can I still use regular ado in my VB6 apps on the same sql
Server2k? Or is it either ADO or ADO.net?

Thanks,
Rich

 

[Jan Tielens]

1) No
2) Yes, you can use ADO, but I recommend you learn ADO.NET
3) Sure, no problem!

 

[Cowboy \(Gregory A. Beamer\)]

1. No. Just make sure .NET is installed
2. Yes, but only with COM interop, which is slower. NOTE: using recordsets
is a pain compared to DataSets and DataReaders
3. Yes. No problems. One is COM, one is .NET.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************

 

[Rich]

Thank you all for your replies. And yeah, the dataset
thing from ado.net sound hot - disconnected recordset.

While I'm at it, a book I am reading on dotnet says the
examples are from vs 2003. I loaded vs 2002. Is there an
update patch on microsoft to update vs to 2003 or do I
have to purchase 2003?

Thanks again,
Rich

 

[Jan Tielens]

There is no update or something like that. But I thought (at least in
Belgium) there is a promotion running until the end of the year which allows
you to upgrade for around 30?.

 

[Rich]

I wasn't sure where I wanted to go for the holidays, but I
guess Belgium would be nice this time of year, sleighs and
all? Maybe it would be cheaper for me to just buy 2003.

Thanks

 

[Chris Dunaway]

I wasn't sure where I wanted to go for the holidays, but I
guess Belgium would be nice this time of year, sleighs and
all? Maybe it would be cheaper for me to just buy 2003.

MS was offering v2003 for around $30 for those that have 2002, but I'm not
sure if the offer is still good.