I installed SQL Server Express edition 2005 in my Windows XP sp 2. I enabled
TCP/named pipes settings in SQL Server Surface Area Configuration.
I am trying to access from other XP Clients. I got the following error.
An error has occurred while establishing a connection to the ...

I'm sorry, I've been searching for information that I need but I was in the
middle of the sea.  Please point me to the right direction of where should I
post my question. Sorry......
We are using SQL Server 2000. At design table view at SQL Server Enterprise

I have a few apps that are based on and required MSDE instances.
I would like to load SQL Express on the same box as those MSDE instances
reside.
Any issues I might encounter?

I want to enumerate the list of MSDE instances on LAN using VB6.I
cannot use SQLDMO or SMO library.
I am using NetServerEnum API but it displays only SQL servers and
default MSDE instance.

I'm migrating our app from VS2003/MSDE2000 to VS2005/SQLexpress. Generally no
problems, but the backup of database always fails.
The backup command is
"BACKUP DATABASE icespy5 TO DISK='C:\testbackup'"

Is this generally being used for sql express specific questions or is there
a separate newsgroup?
Thanks,
Keith

I have two applications that need to run on a user login (power user rights)
.  One application is a commercial app that installed it's named instance
(that runs fine with user rights); another is a "home-brewed" app (not by me)
that (I believe) uses the default instance.  This ...

I wondered if MSDE and PHP allowed for Unicode character sets (such as by
using
the UTF-8 standard)?
Would this also require changes to the MSDE tables/fields or global settings?

i want to catch the error messages and take the control
in delphi, i can do it like this
try
  --- statements

I am trying to build a install program that will deploy the MSDE2000 silent,
with the configurations I would like.
But I can't find a parameter that can set the server to use local system
account, and not the deafult of the user installing the engine.

I've installed MSDE 2000 on a laptop using a admin account. I then logon
using a user account. Now MSDE isn't started, and as I don't have admin
privileges I cannot access services etc.
If I am logged on as both user and admin (switching between the accounts)

Can you setup within MSDE a script to be run automatically at 12:01 each
night.... The script is very simple...
such as "UPDATE Item Set SaleType = 0 where SaleEndDate < getdate()" Right
now is run this script vi osql and a schedule batch job.

Quick question on MSDE maximum connections. If you use MSDE on several and
the MSDE on each computers is pointing to one PCs MSDE, does that mean they
are always connected regardless if the software you are using is requesting
data or not? Meaning if you have 5 PCs pointing to ...

On PC workinq one MSDE-7. I can not deploy the MSDE-2000 this PC. This not
work?
               Thanks
                                   Ferenc

On calling the source attached below to drop sql database, I get the
following error randomly,
"Cannot detach the database 'DBNAME' because it is currently in use.
[Microsoft OLE DB Provider for SQL Server]"