VS 2005 and Databases

[DJel]

Hi,

I am trying to deploy a RSS reader I have built involving a SQL database. I was wondering if there is a way to deploy the app so that when the user runs it on a machine that does not have SQL 2005 Express Edition they do not have to download and install it as well.

Thanks,

DJel.

[randem]

It depends on where the database they are going to use is located. They will however need to install the drivers (client) for any database that need one.

You are using ADO and connect using the ADO Connection Strings and OLEDB?

[DJel]

Sorry I am a bit new to databases,

I just setup a normal .mdf database in VS and then setup their relationships using a dataset (.xss). Then the items on the form just have a connection to the database via a table adapter and a binding source.

[szlamany]

If the database is for a single user can use SQL Server Compact Edition - it requires no other installs and runs in the process space of you application itself.

[DJel]

How would I go about incorporating that into my install, so that the user doesn't have to download it?

[szlamany]

How would I go about incorporating that into my install, so that the user doesn't have to download it?

I'm not big on installs of VS stuff yet - but I believe it simply becomes part of the ref's that are put into the setup for your app.

Remember SQL CE does not run as a service - it's compiled into your .EXE itself.