I am using 'SQLServer 2000 Driver for JDBC'  in my java application. My SQL
Server is running in Windows XP pc. I dont had  any problem before install
WindowsXP Service Pack 2. But when i have installed WinXP SP2 my application
can not connected to SQL Server. I have disabled ...

I'm trying to test an SP with SQL Query Analyser from my client db an
it gives me this error :
[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission
denied on object 'sp_sdidebug', database 'master', owner 'dbo'.

In installed SQL Server under my Win2003 Server userID, specifying NT
authentication.  Then I down loaded MS JDBC, which requires Mixed mode
authentication, so I modifyed SQL Server to that.  Now in Query analyzer, I
can log in to the db using windows authentication, but my user ID ...

I have a VB6-application that opens a ADO connection to a sql server
database at startup. Everything is ok, as long as there is not much database
work to do. As soon as I start a calculation that works a lot in the
database (reads and writes in appr. 10 tables),  it takes about 1 ...

Okay, I've got the raw data table created, and a trigger on
it, and record concatenating, but I can't get around the
datetime conversion problem.  Can you see anything I'm
doing wrong on any of these?

Needs some help, I recently recieved an evaluation copy of SQL Server2000
and I have installed it on a WindowsXPsp2 machine. I have updated to SQL
Server to
service pack3 and installed .net as well. I am still having connection

I'm a newbie at SQL Server connections. I've contracted for a SQL 2000
database with my hosting ISP but have Client Network Utility and Enterprise
Manager from SQL Server 7 which was loaded during my install of Visual
Studio .NET 2003.

We are developing an application that has SQL server as a back end. As a
front end we are using an Access 2002 .mdb file in which we have ODBC links
to the SQL Server tables. I think it is better to create all front end
objects (forms, reports, etc.) in an Access project. I ...

We are using stored procedures that execute multiple selects stacking the
results in a single resultset. In ADO, you use the next record set method to
move from one set to the next. Is there anyway to do this through JDBC?
Its an urgent issue blocking our development cycle. So any ...

Please help me.
Recently I have been getting the following error more and more often:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
General error: Invalid file dsn 'C:\Program Files\Common Files\ODBC\Data

I hope anyone can help me here with a Problem between my Microsoft SQL
Server 2000 SP 3 and an Oracle 8 Server. I have to copy records from a Oracle
table (3.000.000 records by now) to a SQL Server table (8.000.000 records by
now) daily (somthing like an incremental backup). The ...

Is there a possibility to enumerate all available sql servers in pure java.
At this time i execute osl -L and interprete the result.
Process p = runTime.exec("osql -L");
Computers without a msde or sql server installed do not have the osql

We have a production server that's cpu is throttled, and requests are timing
out. After running the get_waitstats sp, OLEDB is at the top of the list in
wait type (99%).
How do I determine which spid is involved in an oledb wait type?

the following error occurs when connected to a  sql server hosted in a win
2k3 .
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist

I just installed MSDE 2005 (or, rather, whatever it's called now) on my
machine.  I'm trying to connect to it using Enterprise Manager, but I
keep getting Unable to connect/connection refused messages.
I've tried giving it my machine name, the word (local), localhost,