connctionstring

[farokhian]

Hi Please somebody help me. I need a connectionstring for c#windows application that connect to my database(my database near exe files in bin)without attach my database in microsoft sql 2005.

[PIEBALDconsult]

An SQL Server database must be attached to an SQL Server in order to access it. There are databases don't rely on a server, you could try one of those, but I don't recommend it. Why don't you want to attach it? You could attach it only for the duration of your application.

[dan sh]

Why would you need to do that?

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[Lost User]

There's two items: your database, and a database-server. You can only manipulate databases that are (temporarily) attached. You can talk to a database-file after you informed the server where the file is located. Try something like this;

Server=.\SQLExpress;
AttachDbFilename=|DataDirectory|\myDatabase.mdf;
Database=DatabaseAlias;
Trusted_Connection=Yes;

The "AttachDbFilename" makes sure that you can access the database-file without having to "attach" it. Good luck :)

I are Troll :suss:

[kstls]

If you don't want to rely on a DB server, you can us a smaler DBMS like SQLite I use that from time to time with minor apps.