Can SqlSrv2k use ADO and ADO.net from VB?

  • Thread starter Thread starter Rich
  • Start date Start date
R

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
 
1) No
2) Yes, you can use ADO, but I recommend you learn ADO.NET :-)
3) Sure, no problem!
 
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!
**********************************************************************
 
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
 
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?.
 
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
 
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.
Click to expand...

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