I'm trying to convert the following Access Statement to an SQL Statement INSERT INTO IBs ( PhoneNum ) SELECT [campaign].[phonenum]+[N] AS PhoneNum FROM campaign, campaign AS campaign_1, Num WHERE (((campaign_1.PhoneNum)=DMin("phonenum","Campaign","[phonenum] > " & [campaign].[phonenum])) AND (...more >>

Did a remote backup of a database used to run a live website. Restored the database to my local MSDE installation. Now cannot access the local database using the user login FRED, which is the same as the website, as I use it for local testing. Get error message: cannot open user default databas...more >>

I'm trying my first install of MSDE 2000 and having some difficulty. I downloaded the package, then extracted it. Then read the entire readme telling me all the requirements and such. I then opened a console window, and tried to install it. I made my changes to my .ini file and referenc...more >>

Hello, Can anybody tell me about your own experience using IIS with MSDE as repository? Would the concurrent access of the anonymous internet user to the MSDE engine affect its performance if the concurrent access reach more than 5 at a time? Im planning to deploy an Intranet Applicat...more >>

I have a database that was developed with Sql Server 2000 and then deployed to a server running MSDE. I detached the database on the development server (Sql Server) then attached it on the production server (MSDE). I then added a login for my web app user. My app uses stored procedures, and I can...more >>

Greetings, Earlier this week I was able to create User DSN's and Access ADP's using MSDE 2000. Yesterday I started getting the error message "SQL Server does not exist or access denied". I don't know why this is happening. I uninstalled MSDE and installed the latest SQLExpress 2005 with .ne...more >>

I'm having difficulty connecting to my MSDE installation. I've done this on numerous machines and always get the same result. Currently, it's installed on Windows 2000 Server. Client is Windows XP SP 1. MDAC Version appears to be 2.7 I changed the registry key to 2 (for mixed mode auth...more >>

I have installed MSDE 2000 SP3 on a single Windows XP Professional system. When I try to set up a maintenance plan to backup the databases, the frequency in the "Remove files older than" section is blank. If I try to save the maintenance plan, I get the following error: "Microsoft SQL-D...more >>

does any one know is there any feautres in MSDE that can do schedule and auto purge data? Millions thanks...more >>

Hello, I was developping with SQL Server and now I'm testing with MSDE. I meet a problem with SQL containing dates. My SQL is : INSERT INTO PIPT_Campaigns(CAM_CampaignId, CAM_CampaignCode, CAM_CampaignLabel, CAM_CampaignStartDate, CAM_CampaignEndDate, CAM_CampaignStatus) VALUES (5, 'C0405...more >>

I have a VB.NET app using MSDE and the SQL-DMO to get a list of available server. I installed a copy of MSDE on the users' machine (this machine did not have MSDE previously so it was a new copy including latest SP3), then installed my app. When I start my app, the local computer name does not ...more >>

Hi All, I have a question, we are developing an Intranet Web application with SQL and I need to make a choice between MSDE or SQL Server. Someone can halp me? What are the real technical limits of MSDE? Thanks ...more >>

I would need to know if the MSDE SP3a is aleady Upgraded. I didn't search registy and Enterprise Manager(other PC) Thank for your help...more >>

Hi, I am looking for some statistics for MSDE. In particular, I am looking for information that would catain items such as Mean Time Between Failure. Can anyone point me to a resource for this? Thank you, Paul ...more >>

Hi group, this just drives me mad: I need my msde (the 7.0 version) to deferr foreign-key checking until commit time. The problem is this: I need to delete some rows in different tables from my middle tier. I do not know which rows in which table are delted beforhand so sorting the state...more >>

Windows98 machine and when installing MSDE we (our customer) gets an error on DisableNetAccess. I have no idea what they should do and I can't find anything in google with the word disablenetaccess so I'm hoping somebody out there has some info. Below is the relevant info from the log file when...more >>

Dear Microsoft develpers and users, creating an ADO connection using the connection builder is no big problem (once I found out how to use it): Select the provider "SQL Native Client", use as data source ".\SQLExpress", define the rest - and your connection string will look like "Provider=SQLN...more >>

I have an access FE linked to SQL backend. I am just testing the connection of another workstation to the server. when I linked another workstation to the server everything went smooth, however only one table that when I tried to open I got the following message: "ODBC--Connection to 'CRF_B...more >>

Hello, I am using the boor strap to deploy MSDE with my application. after deployment i cannot choose the server from the service manager because it is not there ( localhost ) and also the instance is not created. Can someone help ? Thanks Haim Toledano...more >>

I been trying to read the posts to answer this, but I don't see a straightforward answer. Can MSDE and SQL Express '05 co-exist on the same machine? Thanks, Wayne P. ...more >>

Hi, I recently installed MSDE 2000, by giving the following to setup parameters in the Command Prompt: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\> D:\MSDE2000\Setup.Exe SAPWD="apple" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 /L*v C:\MSDELog.txt...more >>

I've confirmed that MS Access will create an ADP project in MSDE only if the server is set to Mixed (SQL Server and Windows) authentication mode. Trials in Windows Authentication mode failed. This is still hard to believe, I know, but its a reality. To all those who tried to help, my sincere than...more >>

I have managed to confuse myself as to when and how you can set up Primary Keys on an MSDE database. Are Primary Keys only used when you are connected to an MS Access project or can they be used in other places. I come from an MS Access background and am familure with the use of Primary Key...more >>

Am using SQL 2000. Am storing data in image columns, created with NULLS allowed. Requirement has come across to revert (in some user-selected cases) the column back to no data. Have been using the presence of the NULL to check for the absence of the data and this has been successful. Have d...more >>

hi, There is a computer which have been installed MSDE 2000 (Assueme this as "MiniDB"). This should be the Publisher as in my Architecture. The Main Server which is a MS SQL Server 2000 would be the Subscriber(assume that the name is "MainServer"). I want to replicate the data from my "Min...more >>

I have problem on my w2k server post SP4,MSDE SP3 . I start sqlmangr.exe, and do any mouse click on the form and it disappears. Actually, I don't even need to click! Just moving the mouse over the form causes it to disappear sometimes without an error message or anything, but usually I get...more >>

Hi, I am having a problem with IDENTITY_INSERT command with MSDE 2000 (ADO 2.8). (lines below with >>> are code lines. I am using Python, but the syntax should be about the same as VBScript) First, I create an ADO Connection and create my table. >>> c = win32com.client.Dispatch('ADO...more >>

Hi, I'm in the process of upsizing my access database to MSDE. When you embed images in an access DB, the database bloats out of control. I'm wondering if the same problem occurs in MSDE when you embed images. Thanks in advance. ...more >>

I've written some software that listens to meters on a specified port and writes XML files when any of those meters "speak." There are some 200 of them, and each is programmed to "speak" at 10 second intervals, so there's a fair amount of traffic. Now what I've been asked to do is write a reco...more >>

Hello, Is it possible to install MSDE 2000A with local admin rights and then run it with poweruser rights? Or do I have to have local admin rights when I run it as well? Now I have tried to install it with an account that have local admin rights and after that I tried to run it with ano...more >>

Hi. I'm a bit confused and wonder whether someone of you can give me some more information on this. The EULA for MSDE 2000A states that you cannot use MSDE for hosting services. Does anyone know what this mean? I'm running an ASP.Net application and would like to use MSDE as the backend datab...more >>

Hi I am trying to install MSDE 2000 sp3 on a Windows XP that has had a previous installation in the past. The previous installation has been removed, but when I try installing MSDE again from the command prompt, it starts to set up the gives me an error saying installation failed. I have de...more >>

Hello, I have load dates for each row in my database table. I'm trying to build a query that will give me all of the unique years, then all of the unique months for that year, then finally all of the unique days for that month. I'm trying to load a treeview control with the results ...more >>

Hi everyone. I have installed MSDE on Win 200 Pro. everything works fine when i try to connect on the local maschine, but when i try to get a connection from another computer, then he cannot find the server, when i look with enterprise menager the same thing. have any idea? ...more >>

What is the best tool for doing this? I have been using MSDE to create a portal app on my desktop and now want to move the data from the MSDE db locally to the remote server db. I can export the MSDE data but need a way to get it to the remote sever and import it. Enterprise Manager seems to...more >>

Hi everybody I have a system with : WinXP Pro, MSDE 2000, Framework 2.0 beta. On top of it i installed SqlServer 2005 Beta with Mixed Mode. I am using Query Analyzer and Enterperise Manager from SQLServer 2000 to connect to it (manual says I can) but with no success. I tried to log on with wind...more >>

Hello can someone help me out, i need to know if i buy the 5 User Cal license of MS-SQL server, does that mean that only 5 people on the network or through the web can access the database? Is that true? How can i use the SQL Server in the following way: 2-4 users running on a local area networ...more >>

hey, i have a small bussines with share point and msde2000, when i try to create a table in the servername\sharepoint, i get this DDL statement is not allowed, can anyone help wiht that thanks...more >>

Join members of the Microsoft development team as they chat about what's new in SQL Server 2005 Beta 2. One major new feature that's been announced in Beta 2 is data encryption. Come chat about other new features and changes that exist in this highly anticipated beta of the next version of SQL...more >>

Hi: My client machine is XP Pro with SP1 with IIS 5.1 My server machine is Windows 2000 server SP4 with IIS 5.0. Server has the latest MSDE 2000(SP3a, in mixed mode) as well as MS SQL Web Data Admin (webadmin) installed on it. I can use webadmin on the server to access data in MSDE using windo...more >>

I understand for Win 2k and XP installs that a simple re-boot after MSDE installation will start the MSDE service, but for 98/SE/ME, what is required? Does the user have to go to Start Menu and start the service? I do not want to complicate the installation routine by having to determine the ...more >>

I am using VB .NET to convert data from Access to MSDE. While I am transferring table by table, the memory usage of 'sqlsvr' keeps increasing, and also CPU usage is @ 100 % Some Tables have more than 10,000 records. Is there a way to reduce the memory usage or an explaination why would memory ...more >>

I have a db on msde on one server. I"d like to replicate it by restoring a back up on another PC with a newly installed MSDE. I create a shell of the DB I create a user name which my application uses to login with SQL authentication. I give the user db access to the empty-shell to be filled in...more >>

I'm also interested in any white papers, books, etc for using the SQL server engine for commerical purposes I'd like to know about installation, configuration, etc, basically everything one should think about when working a commercial application. Thanks ...more >>

I am trying to create a maintanence plan for a MSDE database using Enterprise Manager. Under my MSDE SQL Server/Management, Database Maintenance Plans icon does not show up. In my three other SQL Servers (1 MSDE, 2 SQL 2000) this icon does show up. And I cannot right click the database and ch...more >>

Hello, I'm usng MSDE2000A (not MSDE2000) The MSDE2000 documentation speak about 5 concurents operations limitation. The "Approriate uses of MSDE Faq" speak about 25 concurents users (means concurents operations?) http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp (see the "Can I u...more >>

Hello, On my Window 2000 machine I was able to install MSDE one time. However, was having trouble actually connecting to the new database server so I though I would reinstall. Well, I have not had a succesful reinstall yet (I was closer the first time around). Now, I am a long ways off from...more >>

A recent MSDN magazine article decribed SQL Server's Reporting Services. Will Reporting Services work on MSDE? TIA! Wayne P. ...more >>

I have installed SQl Server Developers Edition. The Icon appears in the lower right panel of Windows XP. It has a red square indicating that it's stopped. When I try to Start it I get an error message "The service did not start due to logon failure" error 1069 Did I install it incorrectly or w...more >>

I need to put a date into and SQL insert statement. What charater is it that the date needs to be wrapped in? Thanks Lee ...more >>