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 >>

I am attempting to install MSDE 2000A on a new PC using command prompt. My command prompt line is as follows: C:\MSDERelA:\ setup SAPWD = "test" INSTANCENAME = "DBASE1" When I hit enter, a "Windows Installer" window appears. I have installed entreprise manager on the PC and tried re...more >>