bhutanesedude
The Thunderer
Geeks! I am trying to develop a Stand Alone Employee System. It works perfectly when the SQL DB is in same system with the Front End, but what I am looking forward is to keep my SQL DB is Local Network Server and Front End to be on terminal PC.
I used this code to access the DB when SQL and Front End is in same system.
================================
Shared cs As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=" & Application.StartupPath.Replace("\bin\Debug", "") & "\hrims.mdf;Integrated Security=True;User Instance=True")
================================
Please help me what code to use if I want my SQL DB "hrims.mdf" to be in SERVER.
Regards
I used this code to access the DB when SQL and Front End is in same system.
================================
Shared cs As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=" & Application.StartupPath.Replace("\bin\Debug", "") & "\hrims.mdf;Integrated Security=True;User Instance=True")
================================
Please help me what code to use if I want my SQL DB "hrims.mdf" to be in SERVER.
Regards