Problem with updating MDF Data file as opposed to updating a running SQL Server DB
- From: multiformity@xxxxxxxxx
- Date: 10 May 2006 10:59:35 -0700
I posted this before, with no response, but now I have boiled the
problem down to it's core...
( see
http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_thread/thread/9b332249ef25387d/c2727e5ee9d641c3?hl=en#c2727e5ee9d641c3
for the original post )
It would seem that I could query a MDF file just fine and select data
from it, but updates and inserts to the MDF file would just plain not
work. When I say query an MDF file, I mean that my connection string
pointed to a data file, rather than an activly running SQL Server
database. Attaching the MDF file, and changing the connection string to
point to the SQL Server instance rather than an MDF data file made the
existing code work as expected. This is going to be a big pain because
we do not want to require for people to be running SQL Server on their
machines.
Any Ideas on this odd issue??
Andrew Baldwin
.
- Follow-Ups:
- Prev by Date: Re: Row Status Dataset
- Next by Date: Re: Problem with updating MDF Data file as opposed to updating a running SQL Server DB
- Previous by thread: Installed printers
- Next by thread: Re: Problem with updating MDF Data file as opposed to updating a running SQL Server DB
- Index(es):
Relevant Pages
|
