I have set up system dsn's with an sql server driver on windows 2000 to use
SQL Server Authentication (NOT Windows Authentication) on a number of client
PC's.  When I use these to connect to an sql server database (which allows
mixed mode authentication) via excel, I get the ...

I've recently moved a database from mssql2000 on an NT Server machine
to mssql2000 running on a Win 2003 Server machine.
Now, when I try to use Access 2002 to Link an sql table, the Access
wizard isn't showing any of the sql tables. In fact, it only shows a

After an install of visual stiudo team 2005 beta 2 I can no longer connect
to any SQL Server in my enterprise manager (But showes SQL Server running)
and I get a connection error when I try to edit an SP from query analyzer.
this is the error I see in both places.

I have a problem to find out every NtUserName in my SP that take
information from Sysprocesses. Some NtUserName columns ary empty and I have
much hard work to discover who's that guy connect in my Database.
I think to match another utility throught xp_cmdshell to run an get

first excuse my bad english, I am french.
I think with older access version we can access to btrieve
files via ODBC but now I have not found a such driver for
actuate version and I have no more first access version ;

I've created a "Text" Linked Server via Jet OLEDB. Everything works great
when testing from the server itself, but when trying to query the
linked-server from any workstation fails with this message:
Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.

In a profiler how to find out if a particular transaction is an XA
transaction or an non-XA transaction.
Thanks In Advnace!

A query is taking more than 2 minutes to fetch 51 rows using
SelectMethod=cursor, when I change that to SelectMethod=direct I get the
results split seccond.  So in the system only the SelectMethod has been
changed nothing else.

I'm esperiencing a problem within a notebook where I have to run a web
application (I use a TomCat Catalina server). This notebook isn't connect in
a network and don't have a network card in it.
I've set TCP protocol within MSDE via SVRNETCN but I can't run my

I'm using the last version of JDBC driver, and the following query is
returning duplicate values:
SELECT DISTINCT COMPANY_ID C1 FROM COMPANY_WORKERS
By if i make de following query, it works:

We encounter the 'Protocol Error in TDS Stream' error in Excel that connect
to SQL Server 2000 (SP3) with MS Query. We later found that this occurs when
the user select too many fields from the MS Query Designer.
Interestingly, we later found that this can be fixed by enlarging ...

Hello. I have recently installed a second PC and it is connected via a LAN.
I have SQL Server 2000 installed on my main PC but I wanted to access the
SQL databases in the server from the other PC. Main PC running XP Pro, other
PC running 98SE. I have installed the client tools on ...

I need some help!
We're correcting some security things on our SQL server and now when I try
to establish an ODBC connection, I can no longer choose the default database
for the connection from the drop down list.

I have a very urgent to solve issue with my SQL Server.
I have SQL Server 2000 installed on my server and a lot of application
working with the existing databases. These application stop recognazing the
name of the SQL Server yesterday (the name is CentralServer) so no one works

After doing an disaster recovery test the sql services aren't running.
When i open the enterprise manager the instance is there but no databases.
All databases are recovered from tape
How can i solve this in proper way?