Two questions about C# and Sql Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
1) Is there a discussion of somewhere of exactly which versions of Sql
Server will work with visual Studio and C#?
Click to expand...

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?
Click to expand...

Please clarify. If you're talking about MSDE here, clients connect to it
pretty much like any other version of SQL Server...
 
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
 
Back
Top