Is SERVER OS Software needed with SQL Server?

I am learning VB.Net and ADO.Net database programming, so
I bought MS SQL Server 2000 Developer Edition. I need
some guidance on how to set it up over my LAN.
I installed SQL Server 2000 on a Win 2k Pro machine. I
would like to serve from here, then use a Win XP machine
for client apps for testing. When installing SQL Server, I
gave it a new domain name when asked. But i can't get the
client machine to find the domain. Is a DNS issue? Does
the SQL Server machine have to run Win 2k SERVER to get it
to be a DSN server? I hope not, can't afford Win Server OS
at this time. Thanks in advance."Larry" <anonymous@.discussions.microsoft.com> wrote in message
news:009001c3d3a3$f5179800$a101280a@.phx.gbl...
> I am learning VB.Net and ADO.Net database programming, so
> I bought MS SQL Server 2000 Developer Edition. I need
> some guidance on how to set it up over my LAN.
> I installed SQL Server 2000 on a Win 2k Pro machine. I
> would like to serve from here, then use a Win XP machine
> for client apps for testing. When installing SQL Server, I
> gave it a new domain name when asked. But i can't get the
> client machine to find the domain. Is a DNS issue? Does
> the SQL Server machine have to run Win 2k SERVER to get it
> to be a DSN server? I hope not, can't afford Win Server OS
> at this time. Thanks in advance.
You don't need a server to perform you testing... I'm not sure I understand
what you mean by "domain" name. Are your computers part of a workgroup?
Assuming that SQL Server is installed correctly and running, have you
enabled the File and Printer sharing from your W2K client? To rule out DNS
issues, from your XP client try connecting to your SQL Server by using the
IP address of that W2K machine.
Steve

is recordset open?

Someone told me how to do this before, but I can't seem to find it.
I've got an ADO recordset. What attribute do I check to see if the
recordset is open or not?Not sure what this has to do with SQL Server specifically, this will
probably vary depending on where you are using ADO. You're probably looking
for rs.state (e.g. adStateOpen). Open up your adovbs.inc file and look fo
adStateOpen to get the numeric constant.
A
"Les Stockton" <LesStockton@.discussions.microsoft.com> wrote in message
news:8FC89DE0-7E7A-4B85-AB0A-9302F224002E@.microsoft.com...
> Someone told me how to do this before, but I can't seem to find it.
> I've got an ADO recordset. What attribute do I check to see if the
> recordset is open or not?
>