Questions tagged [mdf]

Master Database File (.MDF) is the starting point of a SQL Server database. It is the primary data file and also points to the other files in the database.

See the Wikipedia article on Microsoft SQL Server.

Related Tags:

429 questions
1
vote
1 answer

Hibernate: connection.url for SQL Server .MDF File

How do I Hibernate connection.url for SQL Server .MDF File? I've tried prop.setProperty("hibernate.connection.url", "jdbc:sqlserver://c:\\db.mdf"); but don't work :( Thx!
1
vote
2 answers

error while Connecting .mdf database

I developed a small project in visual studio 2010. In my project I attach a service-based database named database1.mdf. My connectionString is : Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User…
Vero009
  • 612
  • 3
  • 18
  • 31
1
vote
1 answer

How do I truncate tables in an MDF in SQL Express?

The command EXEC sp_msforeachtable 'TRUNCATE TABLE ?' returns the following error: The EXEC SQL construct or statement is not supported. I execute the query like this: Question How do I erase all data, but keep existing tables, relationships,…
makerofthings7
  • 60,103
  • 53
  • 215
  • 448
1
vote
1 answer

making my datasource file path auto-detecting when running a build in other devices

i am planning to make my data source to auto detect the file path of my .mdf file and my current code is this Private Sub Form2_Load(sender As Object, e As EventArgs) Handles MyBase.Load con.ConnectionString = "Data Source=…
1
vote
0 answers

ASAM MDF library for C#

I have developed an application in which the user can import a csv file of measurement data and see all signals of the measurement in a list and plot them. I want to enable the user to import .mf4 (ASAM MDF) files as well, but I was not able to find…
nickolas
  • 121
  • 7
1
vote
1 answer

export tables from database to mdf file

i am python beginner. i have Database that has 5 tables, i use python to export all those tables to mdf file using asammdf. path_data = os.path.join('..\\Data', 'db_2021-05-06_11-49-42_day.db') con = sqlite3.connect(path_data) cursor =…
Laz
  • 29
  • 1
  • 4
1
vote
1 answer

adding and using an MDF in a DevOps Pipeline unit test

I would like to use a .MDF SQL Server database file on which my unit tests are performed during a Visual Studio Test when deploying via a DevOps pipeline. I added the .MDF and .LDF files to the unit test project and I am able to execute locally. I…
Ralph Hinkley
  • 370
  • 2
  • 9
1
vote
2 answers

exporting data from influxdb to dataframes and then store it in mf4 files using python

i need to store a huge amount of data from influxdb to mf4 files to run it in famos, so i get the data from influxdb using query and I get it as dataframes and then I am trying to save it to the mf4 file but every time i am getting this error…
maha
  • 11
  • 2
1
vote
0 answers

Save system information (mdf or app.config)

I would like your opinion. I am creating a WinForm application (C#) and I would like to know if there is any problem using a local database to save the application settings instead of app.config. My system constantly retrieves configuration data to…
1
vote
0 answers

Reading an SQL MDF file on a Linux machine

Is it possible to read an MDF without an SQL Connection, on a Linux machine? I have tried EF Core and can read it on a Windows machine but it is with SQL Server installed. Thanks,
user1154422
  • 548
  • 8
  • 22
1
vote
4 answers

Add *.mdf file to C# Project

I'm using Visual Studio 2005. I create a project, not Web Project, just Windows application. I remember that Access Database File can be added into a project. I don't need connection to server, data can be retrieved. And I want to do the same thing…
Gia Duong Duc Minh
  • 1,319
  • 5
  • 15
  • 30
1
vote
2 answers

How do I make a non absolute connection string so my small database works with my published C# application?

I'm working on a small project to track information. This C# application will take information uploaded via CSV/Excel and store/sort it. My current connection string is an absolute path (off thumb drive). I'm worried that when I publish it, the…
JoshG
  • 911
  • 3
  • 14
  • 20
1
vote
1 answer

How to get Datetime of the same hours?

At the moment I am working at a project to analyze the performance of different actions. For that I created an ASP.NET MVC Project with an MDF Database. I read the Log Files (.csv Files), parse them and safe them into the datbase. The csv files…
Flo Hab
  • 20
  • 7
1
vote
1 answer

How do I rename or replace signals using asammdf?

I have mdf files that have the names of some channels in a different language. I want to rename those channels in English. I've tried to do so, but there doesn't seem to be any renaming function in the documentation. Another option could be to copy…
Jack G
  • 13
  • 3
1
vote
1 answer

Different user account authorization on mdf localdb

I have the following problem, I have a service that runs at low level and connects to the mdf database of the sql server localdb. But this service is using a different account 'AUTHORITY NT \ SYSTEM' when that account connects to the database, it…
mba
  • 319
  • 2
  • 11