SQL 2005 Express embedded?

[LiquidE_SA]

Good day. I've set-up my SQL 2005 Express server to run on my local machine. What I want to do is develop an application that makes use of an embedded database. What I mean by this is my database must be distributed with each copy of the application. The application is not multi-user and needs to run local machine only, so as I understand it I don't need to intall a server on each client machine to do database handling. Am I right, or must I install the Express server on each client machine? I would like to use SQL Express as it's easily embedded into Visual Studio 2005 and has a properly working visual interface. Foreign key constrains is a must have(as always). I have great difficulty in finding help on the net with regards to this. Can someone please help me or explain to me how I can make my database embeddable? Self explanation or website reverences will be greatly appreciated. Thank you in advance

ASBESTOS-Greetings LiquidE

[topcatalpha]

hmm not sure, but it could be the SQL native client is a solution. When connection using a udl file i can give for "SQL native client" only path and file to acces the SQL 2005 database... hope it helps.. Greetz kurt.

[Scott Dorman]

Using SQL Express will require your end-users to install an instance of SQL Express on their machine. Programatically, you access the database the same way you would as if you were developing to a "normal" (full) SQL Server 2005 installation. If you want a database that is actually embedded (in other words, has a minimal footprint and does not require a separate install) you should look at SQL Server 2005 Everywhere Edition[^] (also called SQL Mobile) which is also a file based database that allows you to scale up to (and integrate with) SQL Server 2005 when necessary.

----------------------------- In just two days, tomorrow will be yesterday.