Re: c# and MSDE

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for the reply..... I'm a little confused also, which makes sense
since I'm a novice at DB's

I've got a small MS Acess database and I've got a small front end that has a
datagrid to display some of the information in the Database. I've got
VS.net 2005 and since I am a novice, I've been reading through books, that
pertain to C# 2005. All the examples I find are making a SQL connection and
use the MSDE.

Thats great if you download and install that, but if I do will my clients
also need to do that same? Can I use ADO Jet to connect to a MS Access DB.
Do you know of any examples that connect to the Northwind DB so I can use
something else as a working example rather then having to involve MSDE.

Thanks


"Jani Järvinen [MVP]" <janij@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eCBoqM10GHA.4176@xxxxxxxxxxxxxxxxxxxxxxx
Jason,

If I've got simple Access DB, and I've got a front end with a with a
datagrid and use SQL SERver 2005 Expression edition to create the
connections, develop the app then I give the DB and the front end
application to end users, do they need to have MSDE installed on there
PC?

I didn't completely understand your question (could you rephrase it a
bit?), but if your application is connecting to a SQL database, then yes,
somewhere on the network there has to be an SQL Server instance running.

Now, if you build your application so that it expects to find the SQL
Server installed on the same machine as your application ("localhost"),
then yes, users need to install SQL Server Express on their PCs.

--
Regards,

Mr. Jani Järvinen
C# MVP
Helsinki, Finland
janij@xxxxxxxxxxxxxxxxxxxxxx
http://www.saunalahti.fi/janij/




.

Relevant Pages

  • RE: Installing SP4 on SQL 2000
    ... SQL Server 2000 SP3a, x86 ... It seems like there is issue on your install. ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... As you said this is a fresh install, so it should not be an issue. ... If you are installing are installing a fresh version of SQL Server 2000, ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • Re: Why do I need to restart the SQL service?
    ... > I use Wise Installation utility to install MSDE 2000A. ... what I do within the app is: ... Check to see if the database exists. ... > SQL Server does not exist or access denied. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL SERVER 2008 Express + SP1
    ... Again there are three service pack setups which are provided by Microsoft. ... Are u sure you are using correct version for your install? ... DB Dev SQL Server 2005 ... Script level upgrade for database 'master' failed because upgrade step ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... I'm willing to continue because I need this database to be up and working on ... SQL Server 2000 SP3a, x86 ... It seems like there is issue on your install. ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)