When running the setup.exe on Windows 98 and Windows ME, the MSDE installer tries to run C:\Program Files\My Application\DB\Temp\instmsi.exe. Then the installation fails. However the installer works fine for Windows 2000 and XP. The path C:\Program Files\My Application\DB\Temp, is where I pu...more >>

All, I uninstalled my MSDERelA which was working to test a new install routine... When I try to reinstall, the install gets to the "Please wait while install configures MSDE..." and hangs with somewhere between 2-5 seconds remaining (according to the progress bar).... any articles on what's ha...more >>

Hello, We have an application that collects data into and access db. Then the user connects to the internet and the access db syncs with our sql using a vb.net application. We have some issues at times with this vb.net application. I am wondering if we use msde on the client machine and th...more >>

All, looking to distribute MSDE with my ASP.NET app.... looking for two pieces: 1) Is there a way to install MSDE with a DB already attached? I want to install MSDE and then attach a DB, but attaching has to come after a reboot(to start after services restart), and I would rather do it all a...more >>

I have MSSQLServer version 8 installed. I'm using it to code with .NET. I somehow ended up with MSSQLServer using an incorrevt server name when it starts up. It gives me a dropdown box to select the correct servername, but that's annoying. My question is how can I get it to use the correct ...more >>

im getting this error while trying to start SQL server express 2005. provider failure - 0x80041004 Can you please tell me what is the prob ? and how i can fix it asif ...more >>

Is there some site, documentation or information out there that explains how the MSDE install is supposed to work. By that, I mean something explains the process that the MSDE install goes through that would better help me troubleshoot install issues out in the field?. Thank you all....more >>

Anyone can help? I installed MSDE in WIN98 and then upgrade to WINXP home, after that, MSDE failure and i can't reinstall MSDE again, already call microsoft support and try something but no help at all. John --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJ...more >>

I am trying a first time install on a WinME and WinXP machine of MSDE (http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f -bafa-e4b278eb9147&DisplayLang=en) Download and extract works fine but when I try to run setup.exe I am told i need to set a "strong password". I lo...more >>

I am writing a small app for a company using Access (adp) and MSDE. The MSDE is installed on a Small Business Server and I have been told it is a complete standard setup. First question: I know MSDE is running because I recognise the icon in the system tray. Also, locally I can connect to the ...more >>

Hi all ~ I've been able to use the command line listed below to automate a backup. One snag - I'm trying to backup to an alternate server. In my case, my servers are grab-02 (database node) and grab-01 (location of desired backup). I do have shared folders for both folders. How can I...more >>

Is it set it stone that Express does NOT support being a publisher in replication? I've read that you can only be a subscriber with it now. If this is the case, I won't be migrating... what the hell would be the reasoning behind dropping this ability anyways? This makes Express useless to me. ...more >>

I have an MSDE database with a linked SQL server defined in it. Is it possible to create a table in an Access database which is linked to a table in the SQL server by going through the MSDE linked server. I can easily create linked tables in Access to a db defined in MSDE, or SQL Server, but...more >>

Is there a cut down version of Oracle free for Linux like MSDE is for SQL Server? I'm looking for something better than MySQL and Postgres. Thanks in advance, Peter ...more >>

Hi, Does the .net framework take up a connection to MSDE when starting up? We are experiencing the following scenario: Start up computer Start our program that uses MSDE and the .net framework Runs very slow Shut down program on all computers Stop MSDE service and Start again and it runs...more >>

I have a query I run in MSDE that will give me a timeout error message. It reads: "Timeout expired. The time out period elapsed prior to completion of the operation or the server is not responding." I know the server is responding, because the query seems to run anyway, though I'm not su...more >>

I got a message when I type in : setup SAPWD=abc SECURITYCODE=SQL and setup the MSDE, there is an error said "Unable to determine system default collatution." What can I do?...more >>

How to import Excel table to MSDE ...more >>

I am using SQL.DMO with MSDE, I am trying to shrink and truncate the log, the code works, no error message but the log seems to there and didn't change its size oSQLServer.Databases.Item(dbName).TransactionLog.Truncate() oSQLServer.Databases.Item(dbName).Shrink(10, SQLDMO_SHRINK_TYPE.SQLDMOS...more >>

Dear All, I have installed MSDE2000sp3 on a XP Professional with the default instance name equal to the computer name (e.g COMP1). I have created a database in the local server. I want to connect the database by using "localhost" in the connection string(e.g. jdbc:inetdae7:localhost), bu...more >>

Many thx !...more >>

This question is for anybody who has created & sold/distributed an application that uses MSDE as its backend database. I am converting my application which currently uses Access 2000 to MSDE SP3a. I already have the install process together, but I an in a quandry as to what security method to...more >>

I am using MSDE. Currently the size of all the data and system database is 5 gb. I want to know since this is freeware from Microsoft - what is the size limit and how is it enforced. The databases are currently working fine in that they are tested on a remote machine - but I am trying t...more >>

Is there SQL Server Profiler in MSDE and if yes, how can I start it ...more >>

I am installing MSDE from the SQL Server 2000 CD on a W2K Pro environment. No errors in installation. There is no service installed to start SQL Server. Any ideas?...more >>

I've read that MSDE supports up to 8 concurrent users, while WinXP pro supports up to 10 concurrent users. The question is if the limition of users on the XP pc limits also the users logged in an MSDE database. So if there are 8 users working on files on a XP pro pc can 5 more users connect to...more >>

Hi, Is SQL Server 2005 Express the new version of MSDE once it's final? I assume it will have similar restrictions -- 10 connections, etc. Thanks, Sam ...more >>

Does anyone have info on migrating from SQL server 7 to MSDE.Issues concerns...more >>

I'm being working with the Deployment Tookit and experience all issues mention above, I have multiple machines to test on, and every single one at some point gets that behavior. Please, to the authors of the Kit, provide an estimate time for the final release, we need to know if we will n...more >>

I installed MSDE on my XP machine, no errors. How do I connect the MSDE database with SQL Service Manger? I'm not able to stop/start/pause the service, what path do in use in the service manger?...more >>

I installed MSDE on my XP machine, no errors. How do I connect the MSDE database with SQL Service Manger? I'm not able to stop/start/pause the service, what path do in use in the service manger?...more >>

Hi all. Thanks in advance for your help. I've installed the MSDE using Mixed Mode Security. For some reason I can't seem to find away to create users and force them to log in. I'm using Access 2003 to create the database and admin it. Success will look like individual accounts for each pe...more >>

I am trying to upgrade an instance of MSDE on my XP computer using setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=AnAdminLogin UPGRADEPWD=AdminPassword It runs for a while and then looks like it rolls back the installation. I check the event viewer and I see an entry that states ...more >>

Which one can tell me how many user can access to msde server in same time?...more >>

i want to know how many user can access to msde in same time???? ...more >>

The governor appears to "kick-in" when the 9th or 10th workstation starts the application. Basically, performance problems come down to MSDE installed on: Win2000 Server or Win2000 SBS Server - USER cals licencing Win2003 Server or Win2003 SBS Server - SERVER cals licencing The MSDE ...more >>

I am developing a vb.net app and want to distribute MSDE with the app so I thought I'd load it onto my development machine which is running SQL2000 dev. BUT the install fails saying invalid instance name. I read a post saying that you couldn't do this with sql7 because it only supports one ins...more >>

How can I remove index scan to occure in my SPROC's execution plan. I would like to replace them with index seek. ~Alok. ...more >>

I am using MSDE on a network with multiple PCs. One PC has the MSDE Database and client applications connected to the database. The other PCs also have Client applications connected to the database. When one of the Client PCs is logged off and shut down, the Applications on the Database's PC g...more >>

can i have more than 1 login ? ...more >>

When I run the MS Access Project wizard I get a project but am unable to make a new table or view, etc. What gives? Any books on this or a place to go read soemthing? Thanks. ...more >>

I cannot put the very long long text into the fields that have text data type how can I extends the length of this data type? Thanks...more >>

Hi, I have MSDE installed on a Win2K workstation and MSSQL$<bla> and SQLAgent$<bla> services are running fine. I established an ODBC data source on that computer and I could successfully connect to the MSDE through the sa account. Howeverw hen I try the same thing from another computer ...more >>

I know default port of MSSQL is 1433, but how about MSDE?? How to change the port no (if any)?? Million Thanks ...more >>

Hi According to various things I've read, XP SP2 will close off SQL Server ports unless SQL/MSDE SP3 is installed. However, I've installed MSDE 2000a (equivalent to MSDE 2000 SP3a) with XP Pro SP2 and no network machine can see the DB server. I uninstall XP SP2 and the network can see t...more >>

Hi All, I'm installing MSDE 2000 with a custom application (launched using setup.exe, not integrating merge modules) and am having a problem with the service permissions for SQL services. The custom app installer is being build with Installshield Pro 6.3. Everything works fine for admin use...more >>

I have MSDE running on my system and would like to make a new project or import an mdb file. When I attempt to make a new project, I enter the Administrator user name and password and then after hitting next, I get the following error: Connection failed: SQLState:'28000' SQL Server Error 1...more >>

Got some problems installing the MSDE I downloaded it from http://www.microsoft.com/sql/msde/downloads/download.asp and ran the setup with the following command: setup SAPWD="testpw" INSTANCENAME="test" It installs, however, the server is never visible by the SQL Server Service Manag...more >>

I have the following SQL query which works great in MS Access 2000 SELECT DISTINCTROW [tbMenus].[MenuIndex], [tbKeymap].[Key], [tbItems].[Item], [tbItems].[price], [tbKeymap].[ItemIndex], [tbItems].[tax1], [tbItems].[tax2] FROM [tbItems] INNER JOIN ([tbMenus] INNER JOIN [tbKeymap] ON [tbMenu...more >>

Greetings, My question is this: We are running MSDE on one of the machines in the office and using an Access MDB to work with it. We would like to install the same setup on a laptop so people can work on the road, and then synchronize the databases when they connect to our network. What is ...more >>