Stack Overflow
Stack Overflow

Questions tagged [msde]

Microsoft SQL Server Data Engine also known as Microsoft Data Engine

Microsoft SQL Server Data Engine also known as Microsoft Data Engine is a reduced data engine compatible with SQL Server 7 created for Visual Studio 6. It was later displaced by SQL Server Express and it's Mainstream Support End Date was April 2008.

30 questions
46
votes
7 answers

MS Access DB Engine (32-bit) with Office 64-bit

We currently have a major issue using Microsoft Access Database Engine 2010. The engine comes in 64-bit and 32-bit forms, which is good. However, apparently you need to always install the 32-bit version if the host process is always 32-bit. Fine, we…
drharris
  • 11,194
  • 5
  • 43
  • 56
14
votes
4 answers

What are the best ways to determine what port an application is using?

This is an adapted version of a question from someone in my office. She's trying to determine how to tell what ports MSDE is running on for an application we have in the field. Answers to that narrower question would be greatly appreciated. I'm…
Scott Lawrence
  • 6,993
  • 12
  • 46
  • 64
4
votes
4 answers

Excessive reserved space on SQL Server

We have a database running under MSDE (SQL 2000, service pack 4) that is reserving massive amounts of excess space. Using sp_spaceused for each table gives a total reserved size of 2102560 KB, a data size of 364456 KB and an unused size of 1690760…
Paul G
  • 61
  • 1
  • 2
  • 3
4
votes
1 answer

Possible index corruption?

In the above image what you can see is that I have a table, that when I query a max value of a field from it, I get different results based on a where clause that the rest of the queries seem to rule out as irrelevant. Back end is MSDE 2000, front…
Sabre
  • 2,350
  • 2
  • 18
  • 25
2
votes
1 answer

How do I delete files from a table in MSDE 2000 that is selected by 3 joins?

I have a VB6 program that uses a n Access backend. The query that I am currently using is sQuery = "DELETE tblResultNotes.* " & _ "FROM (tblJobs INNER JOIN tblResults ON tblJobs.JobID=tblResults.JobID) INNER JOIN tblResultNotes ON…
MagnumPI
  • 25
  • 6
2
votes
3 answers

Install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A on Windows 10 (x64)

I need to install MSDE 2000 Release A on Windows 10. The installation window pops up and then immediately closes without an error message. This answer to this SO question seemed to solve a very similar problem and indicates that it is in fact…
Reto Höhener
  • 5,419
  • 4
  • 39
  • 79
2
votes
1 answer

How to copy a MSDE database to SQL Server 2008 Express?

We have a client environment that has MSDE. We're looking to install SQL Server 2008 Express on the clients but must retain MSDE for other applications. Assuming both MSDE and SQL Server 2008 Express exist on a single machine what options are…
byanity
  • 203
  • 1
  • 4
  • 14
2
votes
3 answers

Is MSDE supported on Windows Server 2008?

I know MSDE is no longer supported on Vista, is this also the case for Windows Server 2008?
Ben5e
  • 721
  • 2
  • 9
  • 15
1
vote
3 answers

Can I use SQL Server Management Studio Express to connect to an MSDE database?

Is it possible to use SQL Server Management Studio Express 2005 to connect to an MSDE database?
ObiWanKenobi
  • 14,526
  • 11
  • 45
  • 51
1
vote
2 answers

Cannot access WSS 3.0 sites after movind Content and Config DBs

Problem: No access to internal sites after new Instance of SQL was installed on MS SQL Server Description: I've got a WSS 3.0 installed on the W2K3 Sever. Originally, there was only one Instance of MS SQL (MSDE) for Backupexec (bkupexec). Later,…
KrzysztofS
1
vote
0 answers

How to uninstall MSDE on Windows 10?

I just upgraded my PC from Windows 7 to Windows 10. I did this because I need to upgrade SQL Server from 2014 to 2016 to match our production environment. I am unable to uninstall SQL Server 2014 due to a bug that seems to be due to SQL Server 2000…
user3592246
  • 157
  • 2
  • 16
1
vote
0 answers

extraction data from file.mdf using pyodbc

I have an application for managing pharmacies (just an example ) this application is developed so that it relates to a single pharmacy . This application map on a Micrsoft DBMS MSSDE each pharmacy generates database file ( pharmacy.mdf ,…
user3032122
  • 11
  • 3
1
vote
1 answer

MSDE .BAK not compatible with SQL Server 2012?

I'm trying to copy a database from ye old MSDE to SQL Server 2012 Express, since Microsoft decided not to make MSDE compatible with Windows 7. Lo and behold, when I try the osql restore from disk command, I get the message that 8.0.2055 backups are…
user1480460
  • 11
  • 2
0
votes
4 answers

How do I create a new Database and new tables in SQL MSDE 2000 programmatically with C#.net?

I am writing a program that will create a new datatbase, then add tables to that datatbase. Here is my code.... InsertTable("Create Database iBlast", "Null"); InsertTable("Create Table iBlast.tblBoreHoles (HoleID uniqueIdentifier, HoleName…
MagnumPI
  • 25
  • 6
0
votes
1 answer

MSDE backup file is appending

I have an MSDE 2000 database backup file which is appending rather than deleting or renaming. I am using this command: BACKUP DATABASE [SPSDB] TO DISK = 'E:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SPSbackup\spsdb.bak' with retaindays = 1 I…
Chad
1
2