I have Node1 (Win2K Sp4) with SQL2000 Database And Node2 (XP SP2) with COM+
components connecting to SQL Server Database on Node1. After installing SP2
for XP on Node2 my apps don't run they produce this error:
<description>New transaction cannot enlist in the specified ...

Hi Gurus,
Is there any way which I can know the number of connections to SQL Server
2000?
Thanks.

Please help .... How execute such queries "-- ? "
Dim con As New Connection
con.Open "Provider=Sybase.ASEOLEDBProvider.2;Persist Security
Info=True;Mode=ReadWrite;User ID=Savtchin;Data Source=SYBASE12;Initial

Trying to get5 SSL work between SQL server and Query Analyzer. I have enabled
encryption on the Query Analyzer client and installed a certificate on SQL
server,
When I connect from QA, i get a message saying "Encrytion not supported on

Is there a way to find out the source IP address of a database connection?
In trace there are only netbios names available, while I need to log the IP
addresses that connect to the database.
Thx,

I try to create SP from ADO. Open connection and excecute queries.
con.Execute "SET QUOTED_IDENTIFIER OFF "
con.Execute "SET ansinull ON"
con.Execute TextProc

  I noticed an interesting behaviour. When the autoCommit is turned off, I am not able to use the same connection handle to create multiple Statement/PreparedStatement handles.It goes into Manual Transaction Mode and says cannot clone connections.
Is this a bug?? Can someone give ...

I am trying to speed up database operations of an application.  The
app is separated from the SQL Server database by a WAN and they talk
through ODBC.
Operations are as slow as cold molasses.

Utilized FrontPage 2003 Database Wizard to create an online feedback form.
The Submission form indicates that everything transferred smoothly to the
database. BUT.
When I ask to see the results online or edit the database content I receive

Hi, please help me!
I'm connecting to my database using...
Database_ConnectionString = "Provider=Microsoft.JET.OLEDB.4.0;Data
Source="&server.mappath("/db/db127/store.mdb")

I have a large Java application connecting to SQL Server 2000 through
the JDBC driver, however I have an intermittent problem when executing
queries. Seemingly at random, i receive the following error:
[Microsoft][SQLServer 2000 Driver for JDBC]Statements that produce

I am using JDBC to connect to SQL Server 2000.  In Java, I close my
statement and connection objects, but when I do a select @@connections in
query analyzer, the connection I opened is still there.  Can anyone tell me
if there are issues with the MSFT JDBC driver SP2 closing SQL ...

I have a problem with restore db (can not obtain exclusice access to db)
the question is:
how to obtain exclusive access to database using jdbc driver ?
how to log off all users and prerform restore ?

I am trying to restore a database from a different server to my server and
also with a different name.
But it gives me an error.
ODBC-SQLState 42000

I have had an ODBC link between Access and Oracle at work for some time
now which has worked without problem. The other day, one of our
technicians came to change the name of my machine. Despite my best
efforts, I could not keep him off my machine and sure enough, my ODBC