Re: Newbie Question about SQL Server 2005 Express connection...

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello Liam,

I have also been struggling with this problem. I wanted to connect to
an .mdf and use it more or less like one uses an .mdb. It seems that
things are not exactly like one would like. Or at least ms is making
things more complicate than we expect. All this useless security is
only preventing us to easily get set with our work, ... and probably is
not really stopping any hacker :)

After a few days of attempts, I have found a way to connect and deal
with mdf files which seems to work. I have not tried it yet with asp
net pages. Would you like to give it a try to see if there are
problems?

-tom

Liam ha scritto:

Hi, I'm fairly new to this, hope you'll forgive the newbie question.

I'm trying to build an app that will be installed on up to six PCs. The app
will use a Winform UI connected to a database sitting in a shared network
folder.

I chose to use SQL Server 2005 Express Edition based on the understanding
that I could treat the .mdf file much as I would an old-fashioned Microsot
Access file - a connection string in the app would point to the central
database file, enabiling the half-dozen users to share the same data.

Problem is that I can't find a way to attach my .mdf file to my Visual
Studio 2005 project without relying on the local installation of SQL Server
Express. When this gets rolled out, it will be on a network that has no SQL
Server 2005 Express Edition software installed on it.

I chose SS2005EE because I wanted the power of SQL Server functionality
combined with the ease-of-use (and portability) of Access data files...

Is what I'm trying to do even possible? VS2005 won't let me attach to my mdf
file unless the project connects to the local instance of SS2005EE...

Help!

.

Relevant Pages

  • sql server express, mdf and jdbc?
    ... I have an MDF file from an older sql server installation. ... What should be the url string for my jtds driver? ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Question: moving around SQLExpress MDF file...
    ... >I have a SQLExpress MDF file that I'm using for membership data, ... If I want to use the website MDF during development on my local ... To backup the database, if I just burn the MDF to a cd is that good ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: how to transform an MDF file o a permanent database?
    ... i will delete the local .mdf. ... I'm assuming by "central database" that you mean the instance of SQL Server ... What i want is to make that .mdf file permanent in the central database, ...
    (microsoft.public.sqlserver.setup)
  • Re: how to transform an MDF file o a permanent database?
    ... i will delete the local .mdf. ... I'm assuming by "central database" that you mean the instance of SQL ... Script the database out and run the script on the instance of SQL Server ... What i want is to make that .mdf file permanent in the central database, ...
    (microsoft.public.sqlserver.setup)
  • Re: Lost Log File !
    ... > Create a new database with same MDF and LDF name ... > stop sql server and delete the new MDF file and copy the old MDF file ... > Start SQL Server and see the status. ...
    (microsoft.public.sqlserver.clients)