mdf

can't insert a record into table

Hi, I wrote a program which includes writing and reading from database. When I run the app and try to perform writing I call the following method: public static void AddMessage(string callID, string content) { string select = "INSERT INTO Sporocilo (oznaka_klica, smer, vsebina, prebrano, cas_zapisa) VALUES (@cal...

convert sdf to mdf

I have this sql ce database which I would like to convert to SQL 2008 because I want it to be accessible through the network. I am using SQL 2008 express; and VB9. Any idea? ...

How do I refer to APP_Data from another project

I have the following project solution: There is a ASP.NET MVC Web Application where I have a SQL database (mdf file) in the App_Data directory. There is a class library where I have some migrations from migratordotnet. In my build file I have to specify where the SQL database is so it can run the migrations. For the moment on the mig...

Cannot delete SQLServer2005 data or log files

I was trying to restore a backup but I kept getting OS error 32 - cannot delete because in use. Couldn't figure out what was locking the data and log files - so I rebooted the machine, stopped the service but still no luck. Then I deleted the DB but data and log files are still there. Rebooted again - tried to delete them but looks li...

SQL Server, Restore a .BKP file into an MDF file but not LDF (no space for it)

I'm in an issue where I don't have enough space to accomodate my MDF and LDF files from a LiteSpeed backup we had done. I've come up with the following sproc: exec master.dbo.xp_restore_database @database = 'OSiteDB', @filename = 'L:\OSiteDB_2009_01_07_Wed_LiteSpeed_Full.BKP', @with = 'move "O1_SITEDB" to "S:\OSiteDB_Data.mdf"', @with...

How to recover database from MDF in SQL Server 2005?

I have an MDF file and no LDF files for a database created in MS SQL Server 2005. When I try to attach the MDF file to a different SQL Server, I get the following error message. The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database...

Connection String to Connect to .MDF

I've created a new project in VS2008, and added a .MDF file to the project. This is the first time I've tried to use the MDF files and .SQLEXPRESS databases (I've always used extenal Oracle servers in the past). I'm trying to document everything as I go, but I can't figure out what credentials are being used to connect to the .MDF file...

Does user need SQL 2008 Express Installed if I deploy app with .mdf file?

I'm making a Win app on the 3.5 framework. I'd like to include a database file with the app. This would a single-user db. I looked at the 2 different types of db files I can add, the sdf and mdf. Thw sdf (compact) db is missing some functionality I need, so I prefer the mdf. The description on the mdf file "Service oriented database f...

convert sql-server *.mdf file into sqlite file

Just wondering if it is possible to convert sql-server *.mdf file into sqlite file ? ...

What is the best local-database solution for WPF applications?

What is currently the best solution for WPF applications which are meant to be used on one computer where various users log into them and use them to get/save information locally? Here's how I see the options: MDF would seem to be the best choice since I assume you can lock it down quite well so that even though users can access the .m...

how to use an mdf in App_Data with shared hosting

If I create a website that uses an mdf in App_Data with the connection string: Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname; Trusted_Connection=Yes; what do I need to do to run the site in a shared hosting environment? Do I need to copy the contents of my mdf to the main SQL Server engine of my ...

Linq Not Retrieving Correct Items in a Big Table

I'm with a very strange problem. I've a table with more than 800.000 records and 2GB mdf Database. When I try to get the last records: I'm only getting the records until one month ago, the last ones doesn't show up. Dim Items = From Item In DB.Items _ Where Item.CatID = CatID _ Order By Item.PubDate Descending ...

Problem with deploying an application that is using sql server 2008 express

I've developed an application for my college project in Visual C# which uses SQL Server 2008 Express database. My application is desktop-based. But the problem now is deploying the application. Is it required that a SQL Server 2008 be installed on the client machine (with my tables and data inserted) or can I just have the .mdf file expo...

What is an MDF file

Is this like an "embedded" database of sorts? A file containing a built in database? ...

Importing a MDF file into SQL Server 2008?

I have inherited a VB.net web app that I'm making some changes on. I'm perfectly capable with the programming side (VB and MSSQL) but I'm getting lost with the tools. I was given a zip file of the code and everything. I opened the sln file in Visual Studio 2005 and it worked fairly easily with little modification. Running the app works ...

How to protect the sql server 2005 MDF file.

How to set the Password for sql server 2005 MDF file. Becoz i want to give the trail package to the client,package including the MDF. After installing the package, the MDF will be placed in C drive, user data will store in MDF file through the application. but not allow to attach that MDF file using sql server in that system. ...

.mdf files and cross-database querying?

Greetings. I was wondering how I create a cross table query via C# when the databases are unattached (development) I know the .mdf files are temporarily attached to the database when you execute--but that's really the source of the confusion. If your DB connections are all to separate database files that cause them to be dynamically a...

Cannot add database to an Asp.Net application

Hello everyone, I'm unable to add an mdf database file by right clicking on the project name and clicking on "Add->New Item->SQL Server Database". It gives me the following error... ** Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the compone...

LINQtoSQL Not saving to database,but changes show in app.

Hey all, I have a linq app using C# express2008 and sqlserver express 2005 (mdf file connection) I followed the regular dml generation and vanilla datacontext. However i created a repository class to manage the Linq stuff. In using the functions, selecting data works fine, updating data works in the app.But when i check the data in the ...

What is the best deployment approach for WPF applications with local database?

I want to make a WPF application that exists in one directory including all files that it needs: .exe, .mdf database, .xml config files, etc. the application should work no matter what directory it is in so that it supports this scenario: person 1 executes the application in c:\temp\wpftool.exe the application reads and writes to the c...