can I install 2 separate apps from 2 separate vendors on the same machine, if they both use MSDE? If so, is it simply installing a separate instance for the 2nd install? Thanks. Greg. r3gbrewer@health.nb.ca ...more >>

help! i need to set up a replication all i have is osql cmd utility. i have looke for exambles and can not find any my database will replicate to a sqlce...more >>

Hello, I am having a problem with installing MSDE on one of the Win2K client machines. The MSDE setup runs to about 90% installation (progress bar shows at least) and then seems like focus goes away from the setup progress bar and then progress bar shows uninstalling (it does not say its unin...more >>

Can I restore a sql server 2000 database to msde from a bak file ? if so how ? ...more >>

Hi there, I currently have a MSDE Server running with a number of databases on which i would like to backup daily and weekly at a certain time. Is there anyway of doing this?? At the moment ive just been using a simple line of code and executing when i remeber to, but an automated system wo...more >>

Hi everybody: I want upgrade a MSDE 7.0 to MSDE 2000. When I use sql2kdesksp3.exe I get the error "The instance name specified is invalid". Could someone help about what I'm doing in a wrong way?? Thank's in advance ...more >>

Hello!! Can you advice me some free MSDE tools (like database manager, query interface...) that can be found over web? Thanks in advance for your help!! Ambros Moreno From Almeria (Spain) ...more >>

Hi All I have been following Mario Szpuszta's excellent article on MSDN "The MSDE Deployment Toolkit (RC)in Action"(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdedepl.asp) to build a package which can install MSDE (if required) and then install my database and...more >>

need some help with getting this stored procedure working. I'm trying to import excel spreadsheet into an existing table getting error message of syntax near "*" =========================================== CREATE PROCEDURE [dbo].importExcel AS --Create linked server EXEC sp_addlinkeds...more >>

Hi, What exactly does the 5 user(s) license of MSDE means? "sa" is a user and i can have only 4 more users, does that means total 5 users license? Or its the number of users connected to MSDE at any given point of time? Reetesh. ...more >>

except Gunes. to install a new instance,such as "LeighSword",everythink is OK when you have installed a Default instance. we have not trouble in install produce(because i have spends a lots time to reseach it) so what is the problem i have got? the MSDE can able to connect using the OSQL.e...more >>

I am trying to install MSDE but requires a restart or manual work to start the server. Is there any way we can start the server automatically as soon as the MSDE intallion is finished ? Thanks Bobby ...more >>

During installation of MSDE I get the message "The instance name specified is invalid" Any ideas? Thanks Yannis ...more >>

Hi, Quick question for the experts out there: I have MSDE installed on a remote server and I access the data via Access(ADP). I now want someone else to access one perticular DB on the server. I have created a new user/role and eveything no problem. But, how do I only allow the user to vi...more >>

Hi, i want connect to PC with MSDE 2000 from pocket pc, i try connection but nothing. From Pocket PC to Sql server is OK From Pocket PC to MSDE 2000 not! I think that my connection string not good, i use : Dim cn As New SqlConnection("Pwd=mypassword;User ID=sa;Initial Catalog=Demo;Dat...more >>

the SQL server using the same database engine as the MSDE, so SQL Server2005 also is a garbage too! People who can tell how to get an Orcale desktop version? ...more >>

Hi My problem is that I have a MSDE database in one server and I want to move it to an SQL Server in another server. Can anyone tell me what procedure do I have to follow? Thanks in advance ...more >>

I've installed MDAC 2.8 - then, successfully installed MSDE. However, I start the SQLAgent Service - also the instance service - - but SQLAgent never recognizes the new instance - Any ideas? ...more >>

hi, is it way to create ONE trigger for insert,update,delete which can apply for all tables? is it a trick with stored procedures? There is two field in every table: "last modified" and "created" datetime fields. I want a trigger what set the values automatically... ...more >>

how can I import excel files into msde 2000 ...more >>

Hi everybody! I'm trying to install Sql 2000 Enterprise Edition on a Windows 2003 Standard Edition and it tells me that I need SQL 2000 with sp3. What do I have to do?. I have sp3 but I can't install it before install Sql. Can you help me? Thanks in advance ...more >>

Hi, Sorry if this questions appears so wierd, but I read through the MSDE website to have a clear answer with no use. The question is: There are two copies of MSDE 2000 to download. One's name ends with "Release A" and it's volume is about 42 mb (MSDE2000A). The other is without "Relase ...more >>

I have two PC running Windows XP Pro in Workgroup Mode. They both in mixed authentication mode with blank sa password. The usernames on each machine are the same and they have no password. The problem I have is with merge replication. The replication fails with the message "Login failed for...more >>

Every time I start my computer the connection of the SQL Server Service Manager is lost. How to solve this? Thanks, Peter. ...more >>

Hi I have a clients msde that appears to crash upon any type of connection requiring a restart of the computer.. Cleanup/reinstalling allows the service to stay up for about 15min before begining the same crash issue. Client is on windows XP sp2 - I was going to extract the mdac 2.8sp1 out ...more >>

Hello. I have to run many sql scripts each day. Sometimes I'll have 100+ scripts to run. The scripts always come in a folder numbered in the order they need to be run (001 - ScriptA, 002 - ScriptB, etc.). I've been running them all manaully one by one so that I can look for errors in the re...more >>

This morning, I installed VB.NET, MSDE and the web data administration tool. I have a little bit of experience with all of the above, but hadn't got everything installed on a new computer until today. Problem is that when I open the web data administration tool, I get an Internet Explorer wi...more >>

Can a view be created in msde 2000 ? ...more >>

Will the MS JDBC driver work with MSDE 2000? Larry ...more >>

MSDE prints a message that it is running a stored procedure along with the procedure name and arguments. This is generally followed by additional information including the fact that it has completed the stored procedure execution. When I run a stored procedure that inserts data into a...more >>

Can anyone tell me how I can backup / restore individual tables? At the moment I have been backing up the msde database on the development machine and restoring it onto the web server in order to transfer data. But I have now reached the point where the data on the web server no longer match...more >>

I can install instances of MSDE without any problem. But for some reasons the password (or the instance) get corrupted after I try to upsize a table from MS Access to an existing database in MSDE (I'll stop doing this). But now I have multiple instances which I would like to clean up. Doe...more >>

I just wanted to make sure there is no limitation here, since I have cascaded deletes in my table relationships. Thanks Norton ...more >>

Can anyone tell me how I can use a global varible as a selection criteria in a Query? I previously had a query which I ran in MSAcces with the jet engine which had in the criterial line a reference to a function which returned the value of a global variable. I have now moved to Access 200...more >>

I just had an application ported/rewritten from VFP to .net and in order to give users access to it in a Terminal Services deployment (in a one server setting) , ALL USERS MUST BE ADDED TO THE ADMINISTRATORS GROUP!!!!! My developer told me this is necessary, and is not a big deal. HUH???!!! ...more >>

I have installed MSDE in WinXP Professional SP2, and already enabled the TCP/IP protocol in SQL Server Network Utility. However, I find that it is failure to connect the database by calling the IP Address even I test it locally (use sa/window authorization) , but it is ok by calling the computer...more >>

Without having read the manual (just assuming it should work), I have a problem with MSDE and using the Enterprise Manager to create a database maintenance plan. I have a desktop machine with SQL2K(sp3) and a portable with MSDE (msderela.exe). I am testing (developing) an application that s...more >>

Hi: I'm converting an application written in Clipper in the early 1990's to use SQL 2000 server. One of the tables is quite large (128 fields) and has many "memo" fields which I'm converting to varchars. I created an empty database using the enterprise manager and began the process of im...more >>

Hi, I am new to msde and i want to istall it i try to install it using this command line: setup SAPWD="test" What is SAPWD and for wate porpuse? After this kind of installation can i start writing database application using msde? What good tools can i use to create a database for this msde? ...more >>

I've got a SQL Server database. Nearly finished. It's going to go on a single non networked machine. One day somebody might get access to it over ADSL (probably TS), but for now it's a single user no lan. The machine will actually be running the MSDE. Windows XP Home. I'm quite happy, for ...more >>

I've been looking into this all day and haven't gotten anywhere. I'm using InstallShield to install a .Net application, the application uses MSDE as its database. I've added InstallShield's MSDE object to the install, works fine sometimes but most of the time I get the following error message w...more >>

I've been looking into this all day and haven't gotten anywhere. I'm using InstallShield to install a .Net application, the application uses MSDE as its database. I've added InstallShield's MSDE object to the install, works fine sometimes but most of the time I get the following error message w...more >>

Any utilities out there for migrating an MSDE database to Oracle (9i)? I'm familiar with Oracle's Migration Workbench, which creates the schema and migrates the data, but haven't located a plug-in for MSDE. I haven't been brave enough to see if their plug-in for SQL/2000 will work....more >>

I've tried installing the full MSDERelA, and it runs, giving a "Gathering Required Information". It then promptly disappears, and nothing further happens. The KB has a similar error happening with RTM, but I am trying to do a fresh install....more >>

Hi, We are having a dedicated machine (with a fix IP) running SQl2000 and it is supposed to be the master database. And we are having 4 clients XP machine running MSDE (without fix IP), and we would like to have a merge replication to sync. data from / to the client / server. Coz data will b...more >>

Dear NG, After suffering with Crystal Reports for a bit, I came across a book on SQL Server Reporting Services. It seems to do a lot of what I need to get done. I have been developing an application with MSDE rather than the full blown SQL Server. While I could transfer my development to ...more >>

is there an easy way to transfer a database from one msde to another msde (on a second computer) thanks so much markus ...more >>

We have an ASP page which executes a stored procedure this works fine on windows 2000 server/SQL 2000 server. We are trying to use the same page locally on WinXP SP2/MSDE 2000A and we seem to be experiencing a strange problem. When run locally the asp complains that it cannot find the stored ...more >>

Hi All, I can connect to my MSDE server by logging in as SA from the command line but not through the ODBC manager utility in windows. I need to setup system DSNs for a few applications but can't because they require I use SQL authentication. When I reach that step in the ODBC manager I typ...more >>

Hi! I've installed a SBS 2K3 server, and everything seem to rock ok. If I not misunderstood the whole concept, MSDE 2000 is shipped with the server OS, ok? I've also installed Veritas BE ver. 9.1 Standard for SBS and the antivirus software Panda Enerprise Secure. Both applications seem to reg...more >>