Two questions about C# and Sql Server

[Guest]

1) Is there a discussion of somewhere of exactly which versions of Sql
Server will work with visual Studio and C#?

2) Is it possible to use the SQL Server 2000 Desktop Engine from a different
PC over a network by sharing the folder or drive?

 

[Mark Rae]

1) Is there a discussion of somewhere of exactly which versions of Sql
Server will work with visual Studio and C#?

It's the other way round... VS & C# will work with any RDBMS for which there
is:
a) a native .NET data provider
b) an OleDb provider
c) an ODBC driver

2) Is it possible to use the SQL Server 2000 Desktop Engine from a
different
PC over a network by sharing the folder or drive?

Please clarify. If you're talking about MSDE here, clients connect to it
pretty much like any other version of SQL Server...

 

[Guest]

Q 1 was prompted by the comment on page 438 of Visual C++ Step by Step (Sharp
& Jagger) which says the Standard Version of C#.net 2003 does not work with
Sql Server 2000. I guess the key word is "Standard." I'm using "Professional"
version of VS and should not have trouble.

The point of Q 2 is that it would be convenient to set up a demo or
prototype system using the desktop engine for 1 or 2 people until we get the
database server installed. Usage would be very light. I've been using the
version supplied with Visual Foxpro (already on my computer) for development.

Thanks