c# doubt . database connection problem

naushad india

Hi, I am naushad from Kerala. (.net student)

Please help me !

I had created a simple database project in c sharp and make it exe file ans installed it. Its working fine in my system. because sql server is installed. when i installed it in my friends system its not working because it does not have sql server.

Can the project will run without sql server.

or is the connection string problem

static string path = Path.GetFullPath(Environment.CurrentDirectory);

static string databaseName = "ContactDB.mdf";

SqlConnection sqlCon = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename="+path+@"\"+databaseName+";Integrated Security=SSPI;");

when i install exe in my system no problem. When on friend's system the form appears. when we add new filed. its not reponding

please help...

Thanks in advance

Naushad

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P8y ago
hi naushad,
to work sql server database in your exe file,in system sql server is not required but the sql server client is required. that is free you can download by search for sql server express which version of sql server you have used in google. and in your connection string, you need to change to file system.
Nitin Sontakke8y ago
First, in your application start putting proper exception handling, so that exceptions are logged to a text file and you will know lot quicker what the problem is.

You will definitely need to install Microsoft SQL Server LocalDB on your friend's machine.

I believe that LocalDB is installed automatically as a default back-end when you install Visual Studio. That's why you didn't do it on your machine.

You will need to identify version of LocalDB used and use corrosponding installer for your friends machine.

For example, read the following:

https://stackoverflow.com/questions/27197359/localdb-sql-server-2014-express-creates-2-instances-localdb-projectsv12-loc/27201328#27201328

LocalDB installers available from Microsoft separately. Just google for the appropriate one. For example, have a look at the following:

http://www.hanselman.com/blog/DownloadSqlServerExpress.aspx