Implement a system

[msnews.microsoft.com]

Hi All,

If I want to deploy an C#+SQL2000 application to client site, does the
client computer
need to have SQL2000 server at all ? or the relevant database and tables
will be collected
during the process of creating an installer ?

Thanks
John

[Nicholas Paldino [.NET/C# MVP]]

John,

The client site needs to have SQL server 2000 installed already.
Generally speaking, if I am deploying an app to the client that requires SQL
Server 2000, then I will require that they purchase and install SQL Server
2000, so that the responsibility of licensing is not on my shoulders (and
I'm not breaking any agreements, as I am not a SQL server 2000 vendor).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- ni**************@exisconsulting.com

"msnews.microsoft.com" <jy***@martecltd.com.au> wrote in message
news:ue**************@TK2MSFTNGP12.phx.gbl...

Hi All,

If I want to deploy an C#+SQL2000 application to client site, does the
client computer
need to have SQL2000 server at all ? or the relevant database and tables
will be collected
during the process of creating an installer ?

Thanks
John

[Eliyahu Goldin]

SQL2000 is a separate product and can't be installed from within your
application. You should call it "a prerequisite". It should exist before the
installation.

Database and tables are part of your solution and you should install them
during your application installation.

BTW, are you sure that the client computer should run SQL Server? May be
the server can be located on another machine and the application machine
will run SQL Client? Or may be you need two separate installs: server and
client?

Eliyahu

"msnews.microsoft.com" <jy***@martecltd.com.au> wrote in message
news:ue**************@TK2MSFTNGP12.phx.gbl...

Hi All,

If I want to deploy an C#+SQL2000 application to client site, does the
client computer
need to have SQL2000 server at all ? or the relevant database and tables
will be collected
during the process of creating an installer ?

Thanks
John

[Eliyahu Goldin]

As far as your database deployment is concerned, copying Access .mdb file is
fine. But Access itself also needs to be installed on the target machine,
either full version or run-time only. You can't use an Access db without
database components that come with Access. If you have the MS Office
development version, you can deploy Access run-time files with your
database,

HTH,

Eliyahu

"John" <jo******@froggy.com.au> wrote in message
news:eT**************@TK2MSFTNGP11.phx.gbl...

Thanks Nicholas / Mike

Due to the "SQL server" installaion and purchase was not in the contract in the first place,
and the client's size is not the big, thus, If I change the db to Access
rather than SQL, then
can I just copy the Access db file ".mdb" to client site during the
delployment ?

Regards,
John

"Eliyahu Goldin" <re*************@monarchmed.com>
:#h**************@tk2msftngp13.phx.gbl...
SQL2000 is a separate product and can't be installed from within your
application. You should call it "a prerequisite". It should exist before the installation.

Database and tables are part of your solution and you should install them
during your application installation.

BTW, are you sure that the client computer should run SQL Server? May be
the server can be located on another machine and the application machine
will run SQL Client? Or may be you need two separate installs: server and
client?

Eliyahu

"msnews.microsoft.com" <jy***@martecltd.com.au> wrote in message
news:ue**************@TK2MSFTNGP12.phx.gbl...

Hi All,

If I want to deploy an C#+SQL2000 application to client site, does the
client computer
need to have SQL2000 server at all ? or the relevant database and tables
will be collected
during the process of creating an installer ?

Thanks
John

[John]

Thanks Eliyahu !!

"Eliyahu Goldin" <re*************@monarchmed.com> ¼¶¼g©ó¶l¥ó·s»D
:O#**************@tk2msftngp13.phx.gbl...
As far as your database deployment is concerned, copying Access .mdb file is
fine. But Access itself also needs to be installed on the target machine,
either full version or run-time only. You can't use an Access db without
database components that come with Access. If you have the MS Office
development version, you can deploy Access run-time files with your
database,

HTH,

Eliyahu

"John" <jo******@froggy.com.au> wrote in message
news:eT**************@TK2MSFTNGP11.phx.gbl...

Thanks Nicholas / Mike

Due to the "SQL server" installaion and purchase was not in the contract in the first place,
and the client's size is not the big, thus, If I change the db to Access
rather than SQL, then
can I just copy the Access db file ".mdb" to client site during the
delployment ?

Regards,
John

"Eliyahu Goldin" <re*************@monarchmed.com>
:#h**************@tk2msftngp13.phx.gbl...
SQL2000 is a separate product and can't be installed from within your
application. You should call it "a prerequisite". It should exist before the installation.

Database and tables are part of your solution and you should install them
during your application installation.

BTW, are you sure that the client computer should run SQL Server? May be
the server can be located on another machine and the application machine
will run SQL Client? Or may be you need two separate installs: server and
client?

Eliyahu

"msnews.microsoft.com" <jy***@martecltd.com.au> wrote in message
news:ue**************@TK2MSFTNGP12.phx.gbl...

Hi All,

If I want to deploy an C#+SQL2000 application to client site, does the
client computer
need to have SQL2000 server at all ? or the relevant database and tables
will be collected
during the process of creating an installer ?

Thanks
John