I have a computer (XP PRO) that I attempted to install MSDE on for a database application we use, not realizing that the Outlook Business Contact Manager has some sort of SQL server already installed. The installation failed. In looking through the services I noticed the MicrosoftBCM instance ...more >>

Can I connect to MSDE through Enterprise Manager from another machine?...more >>

We have a system which uses an ODBC connection to connect to SQL Server 2000 for Ceridian Prism--an application for HR departments. Now we are installing a VB.Net application which uses MSDE (SQL 7). The problem is that for some reason we are losing the original ODBC connection to 2000 when ...more >>

Does anyone have any sample code, or references to help when calling SQL DMO to backup / restore DB via C# Thanks ...more >>

When installing an app, what would you need to check in order to determine: 1. If MSDE is installed. 2. If a specifically named instance of MSDE is installed. Thanks. STom ...more >>

Hello there, I want to install multiple instances of MSDE on XP prof edition. How many instances can i create on a single machine? Also, any URL for this would be helpful? Thanks, David...more >>

I cannot install MSDE on a machine. If I run the following it does nothing: Setup.exe INSTANCENAME=BKUPEXEC BLANKSAPWD=1 /L*v C:\MSDE.log Do I have to completely clean the machine first? Any suggestions? This is on a Windows 2003 Enterprise Server. -- Eric Sabo NT Administrator...more >>

I was able to install MSDE into WXP and migrated my Access databases through Windows Integrated Authentication Method. But whenever I tried connecting to MSDE by SQL login it gives me the following error: Invalid username and/or password, you are using a windows login that is not your ow...more >>

Hi all. I have a client running MS Windows 2000 with MSDE 2000 (Build 2195: Service Pack 4) installed on local machine. My program connects to the SQL using "(local)" as server name. After working some time in the program (running queries, everything is OK) the program gets an error "Connection...more >>

In MSDE, since there is no sql mail, I am thinking of doing the following: 1. write a shell script which will query the sysjobhistory table to determine if any job failed. If so, then an email about the failure is sent out. Question: What should my sql command and my mail command look like...more >>

When I send a query 'SELECT somedatecolumn FROM....' I got resultset containing datetime. It's ok because it is a datetime field (or smalldatetime) but it is a little frustrating because I'm interested only in date. Is it possible to get only a date, without the time? My previous database was in...more >>

I have a windows 2003 ent server that we cannot install MSDE on. If we run this from terminal services and a command line, we get nothing: Setup.exe INSTANCENAME=BKUPEXEC BLANKSAPWD=1 /L*v C:\MSDE.log Not even a log file. Does anyone have any suggestions? -- Eric Sabo NT Administrato...more >>

I work on an application that uses MSDE 2000 as its database. Is it possible for client software written in .NET to execute stored procedures that return XML? Does MSDE 2000 support XML? If so how? MSDE 2000 is packaged with the application and is part of the installer. Is there any infor...more >>

Hi I have 2 tables, which consist of: - 1 header table - 1 detail table The key is in both tables, but: Table 1, looks like Key fld,data, data, data Table 2, is: Key Fld, SubKey1, data Key Fld, SubKey2, data Key Fld, SubKey3, data I am looking for a quick way to flatten this structu...more >>

Hi I have a C# Winform app which runs using SQL Server. I want to package up the app, so that it deploys with MSDE. Can anyone offer any pointers or references to help?? Thanks ...more >>

Hi, Is it possible to create DTS packages with MSDE? If so, how? Would you execute them via the "dtsrun" command-prompt utility? Thanks very much, Mark Holahan ...more >>

Hello! I am trying to determine how to differentiate a SQL 2000 and MSDE install without running a query on the database. In mmc's post and Andrea's answer on 1/18/05, a clear solution using a query is noted. I would like to be able to read a registy value to make the determination if pos...more >>

Hi All, I have a .SQL script file that contains database definitions. How can i run the .sql script file to add this database to my MSDE SQL server? Thanks for your help mustafa ...more >>

Hi, I have my SAPWD="8letters" in setup file, but a can't do anything with Command Prompt because my login name doesn't work. How can I find it, or reset it ? Regards, -- J.Alberto [ccs-ve] Nota: no enviar mensajes a mi direccion e-mail, solo spam. Avisar para asignarle un filtro ...more >>

Dumb question. I have Greatplains 7.5 on MSDE running. I notice that the data files in SQL data folder on the server do not change often. Transactions are done daily but the date stamp on the files do not reflect if. I can see allof the transactions in Greatplains fine. What is the deal?...more >>

I have a program installation setup that comes with a default MS Access Database. How do I attach this default database into MSDE on my server? -- Message posted via http://www.sqlmonster.com...more >>

I would like to modify the amount of backups that the sql server keeps on record. My reasoning is that I am trying to minimize the size of my full backups. I was made aware that the server keeps a certain time period of backups and that I could modify this and lessen the time period that it...more >>

I would like to know how I can move current MSDE 2000 database to SQL 2000 database. I want to put all databases on my 1 SQL server. Thanks....more >>

Hi Experts, I am currently having some problem after installing the MSDERelA version. I have performed an installation by running "setup SAPWD='password'". The installation was successful, but when I tried to connect from another machine by using the GUI it doesn't connect. The error me...more >>

Greeting folks.... I just finished a app using access and vb.net and now want to learn mdse. Is there a command prompt to test sql against a database from a client system?.. im more interested in learning sql syntax at this point. Any push in the right direction would help Steve ...more >>

Hi, Anyone know how to migrate migrate backup file DAT from MS SQL 7.0 to MSDE 2000? Thanks Michael...more >>

When trying to uninstall MSDE it doesn't clean up well. It leaves all kinds of registry entries and the disk directories are still there. I read somewhere that there was a problem with this and the you had to hand edit the registry to clean it up. I have been doing that with success. Doe...more >>

Hi, After I installed MSDE 2000 in Win 2000 (ENG), no MSDE registry is found. Why? How to solve it? Thanks....more >>

I downloaded the latest version (I guess) and tried to install, but it doesn't seem to have installed. The file name is MSDE2000A.exe, and it's about 43meg. I double-click, go through the whole thing accepting all the default options, and when I am done, I see nothing in the services dialog t...more >>

Hi, We want to host several web sites that use MSDE as backend. I have two questions: 1. Is there a limit to # of databases we can have in one instance of MSDE? 2. The # of simultaneous connections limit applies to an instance of MSDE not a database in it. Is this correct? Some web hos...more >>

Hi, I have a trigger on a MSSQL table that performs data validation on an Insert. Based on some simple logic (that is correct), when i recieve invalid data, I used: RAISEERROR ("My error message",18,1) to raise an error that I want my VB.Net ODBC error handler to handle. I have tried ...more >>

Hi. I am building a small app that lets our customer upgrade from using our main application with an access database file to using it with MSDE or SQL Server. I want this app to launch the MSDE setup file and install an instance of MSDE on the selected machine. This hasn't been so hard th...more >>

Thanks in advance....more >>

I use Wise Installation utility to install MSDE 2000A. To install MSDE, we give it a command line that sets the sa password. This seems to work ok. At the end of the install, we run a batch file that starts the SQL Service and the SQL Server agent (not sure if we need to do anything with the ...more >>

Are there any articles about connecting a MDB or ADP front-end to a MSDE database that is located on our ISP's server? When I try to Google the subject, I get a bazillion hits but non really apply to WAN connections. Any help or pointers would be appreciated Paul P ...more >>

I have been doing research on how to create a new instance with MSDE. Does anyone know how to create one in an automated fashion using one of the standard tools that are installed with MSDE 2000A? I suspect that is accomplished with cnfgsvr.exe but have not found any examples on the Internet. Tha...more >>

Our VB6 application uses either A2K or MSDE SP3a depending on the size of the customer and what they want to use. I have automated the MSDE install process where it installs to our own instance and configures the workstations to access MSDE thru an alias on a custom port on the server. My que...more >>

we get from a company installed at our customer sides an application using msde in a win 2000 server (terminal) or higher network enwironment. We have a lot of troubles because this application is going to let our application fail often , and we get a lot of instability....more >>

Hello All the samples I found are based on datagrid for the child table. What if I don't want the child records to be displayed in a datagrid, but in their own data bound controls like "text box, combo & list boxes). And I want to provide a second level of navigation buttons to traverse tho...more >>

I trying install MSDE 2000 for the first time on XP Sp2 When I try run setup it give error Instance name is invaild only choice click ok. When I click it just goes away. I now how do fix I just double clicking setup icon Thanks for the help ...more >>

Hi, How do we access MSDE database from a java/C applications? Can some one help me in finding the solution for this. Thanks Ramki...more >>

How can i purchase this MSDE, and where should i go, Where can i purchase MSDE bakup/restore alone....more >>

I have tried intalling MSDE on 2 machines and on each of them after the installation i get the small server icon running in system tray, but the circle is white and says cannot connect. Thanks ...more >>

Hello I've few questions regarding ADO & C#: 1) Is it possible to view tata from multiple tables in the Datagrid control ? Most of the examples I see are only for 1 table. 2) In Comboboxes, can we display multiple fields ? For example in a Form of customers, we have a combo box to sel...more >>

Perhaps I'm dating myself. In a table, I want to create a primary key that consists of two columns (patrolId and incidentId). From the documentation I have, it looks like you can only have one field that is a primary key. Can you help?...more >>

When attempting to install MSDE 2000a to a machine running XP Pro SP2, I get this error message: 2005-01-21 08:56:55.75 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.1 (Build 2600...more >>

Hi, I have VB 6.0 application using MSDE 2000. I created setup file using Package & Deployment Wizard. I have included "SQL Server Desktop Engine Merge Modules" and "sqlredis.exe". However, when I try to test it on another computer, I get following error. DBNETLIB[ConnectionOpen(Connect()).] ...more >>

We have a custom client/server application that runs against MSDE. This application is distributed to the field through a Setup CD. We used the Installshield to create the setup program. Most of the times when the user tries to install the application it fails after MSDE install saying that ...more >>

We’re trying to upgrade MSDE 7.0 to SQL 2000 Std.. Does anyone have any info on this. What are the do's and don'ts. (This was suggested if the number of Blackberry's exceeds 150) Thanks!!...more >>

HI all, I have in my create script, which was created by a ERD program called Dezign for databases, a line which creates a domain of type interger with an identity. The script is as follows: EXEC sp_addtype PrimaryKey, 'INTEGER IDENTITY(1,1)', 'NULL' GO But I get the following error message:...more >>