![]() |
Click here to advertise with us
|
|
||||
|
Please do us the courtesy of posting in the most appropriate forum for the topic and not just the first one you come to. Thread moved.
There are two ways to connect to a SQL Server Express database: 1. You can deploy the MDF file with your application and then attach it to SQL Server on demand. This would only be done for single user apps with a local server. 2. You build a new database or attach an existing database permanently to the server using SQL Server Management Studio Express. This database can then be accessed by any user and any application on the network, assuming that the instance has been setup to support remote connections. If you can specify which of those scenarios matches your situation then we can provide more information if required. That said, as far as the application is concerned it doesn't really matter. The only thing that is different from the application's point of view is the connection string. You can find all the connections strings you might need at ConnectionStrings.com - Forgot that connection string? Get it here!.
__________________
![]() 2007, 2008, 2009, 2010 Why is my data not saved to my database? | Communicating between multiple forms MSDN: Data Walkthroughs | "How Do I?" Videos My Blog: Custom Events | Dynamic GDI+ Drawing |
|
|||
|
Hi,
Am using only Sql Express 2005. i want to create a server client like atmosphere with mdf file. mdf file will be in the server system and no mdf files in client systems. the clients and server should work from the mdf file. that is one database for all systems. is it possible ? i will be glad to hear from u ........ Thanks in advance. |
|
||||
|
SQL Server Express can handle multi-user networked apps no problem, although the databases can only be 4GB and it won't handle the same load as the full SQL Server. What you want to do is no different than it would be with the full SQL Server. You need to install SQL Server Express on your server and make sure you enable remote connections. You use Management Studio Express to create the database and then your application simply needs to specify the appropriate connection string, the format for which you can find using the link in my last post.
__________________
![]() 2007, 2008, 2009, 2010 Why is my data not saved to my database? | Communicating between multiple forms MSDN: Data Walkthroughs | "How Do I?" Videos My Blog: Custom Events | Dynamic GDI+ Drawing |
![]() |
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|