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
0
votes
2 answers

Querying data from multiple clustered tables as one unified

I've recently started work on a project which involves creating a web-based reporting interface for a fairly old software responsible for managing some access control hardware like electronic door locks for example. I have chosen CakePHP for the…
duckyflip
  • 16,189
  • 5
  • 33
  • 36
0
votes
1 answer

MSDE vs SQL Server

There is a project that a developer is suggesting to use MSDE instead of SQL Server, I need to know the differences and limitations of MSDE to make sure it will be able to handle our project.
Ali
  • 595
  • 4
  • 13
  • 42
0
votes
1 answer

Unable to connect to instance

I've installed Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A using the following switches/parameters in the setup.ini file: [Options] SAPWD="sa" DISABLENETWORKPROTOCOLS=0 DATADIR="C:\Program Files (x86)\SQL Server…
Zuno
  • 433
  • 1
  • 7
  • 17
0
votes
1 answer

How do I start MSDE2000A (mssql$netsdk) from cmd in Windows 7?

I'm trying to install MSDE2000A on a Windows 7 machine, and the database book I'm using described doing so through the command line. First I installed it to C:\< folder >. Everything went fine (except for a Windows 7 compatibility issue notice),…
Panzercrisis
  • 4,590
  • 6
  • 46
  • 85
0
votes
1 answer

Can an MSDE 2000 database be deplolyed to SQL Server 2000?

I am developing a Web Application using SQL Server 2005 for the database, but will need to deploy the database to SQL Server 2000 in the production environment. We don't have a license for SQL Server 2000 (we've only got for 2005), and I've come…
Saajid Ismail
  • 8,029
  • 11
  • 48
  • 56
0
votes
0 answers

Created new MSDE Instance, but can't connect to it

Hello all I have just created a new MSDE Instance. I started the instance in services.msc however when trying to set up a connection from "Data Sources (ODBC)> System DSN" It tells me that my credentials are invalid or the instance does not exist.…
mfoehrer
  • 35
  • 8
0
votes
2 answers

SQL query alignment change when Arabic characters are inserted

I have a query like this SET QUOTED_IDENTIFIER OFF SET DATEFORMAT 'mdy' INSERT INTO TABLE1 (AccountID, TimeStamp, UserID, NodeID, Deleted, UserPriority, ParentRecordID, NodeLevel, Name, NodeClass, DeviceID, DeviceType, SubTypeLevel) VALUES…
bdhar
  • 21,619
  • 17
  • 70
  • 86
0
votes
1 answer

Restoring a MSDE database to SQL Server 2005

I am having a hard time trying to get a SQL Server 7.00.1094 backup to restore to a 9.00.1399 (MSDE to 2005) I was told that this will work. However I have done some research and all signs point to detaching and then attaching to the 2005 instance.…
Tekwhat
  • 35
  • 1
  • 12
0
votes
1 answer

Upgrade MSDE to SQL Server or another version of MSDE

We have a production application which installs MSDE on user system in production and application access that as local database. Now we are migrating user systems with Windows 7 and application technology to .NET. We are planning to upgrade the MSDE…
user863952
  • 103
  • 2
  • 5
  • 15
0
votes
2 answers

Connect to SQL Server with ODBC alias

I have an MSDE installed and I have a DB for it. And on a client computer an ODBC alias (x). I want to connect to this using a .NET4 program written in C#. What connection string should I use if I have only a login name (y) and a password (z)? Or am…
Zéiksz
  • 688
  • 1
  • 11
  • 25
0
votes
1 answer

which account does MSDE execute under?

have a .net app that talks to a locally hosted MSDE instance -does anyone know the user account the MSDE runs under? The business sysadmins have released a bunch of "upgrades" to PC's (apparently for active directory and a bunch of other stuff) and…
Bz Burr
  • 93
  • 1
  • 1
  • 8
0
votes
1 answer

migrate from mysql to sql server express - concerns

I have a desktop application which is distributable commercially. Currently I use MySQL as database but I read I need commercial license for MySQL each sale of my software. So I am planning to move to SQL server express or MSDE as it is freely…
sjd
  • 1,329
  • 4
  • 28
  • 48
0
votes
2 answers

How to Attach Existing SQL Server 8.0 Database Files to Microsoft Data Engine (MSDE)?

I am trying to attaching microsoft sql server 2008 database into msde 2000 but unable to attach. i googled many sites but still cant find solution. the only thing i found is that newer version cant attached into older version servers... Please…
akkhatri
  • 1
  • 4
0
votes
2 answers

Upgrade MSDE to SQL Server 2008

I am trying to upgrade an named instance of MSDE to SQL Server 2008 Express. When I get to the "Select Features" page of the 2008 installer there are no instances listed. The upgrade to SQL Server 2005 Express (on the same VM image) however works…
Brian
0
votes
1 answer

How to restore MSDE database to last backup

we have a huge (17 gig) MSDE backup file that have discovered has been appending nightly for the last 4 years. We had a database failure last night and now we need to restore the database. We tried a standard restore but it restored the database…
Bz Burr
  • 93
  • 1
  • 1
  • 8
1
2