If I'm using the PreparedStatement API, I can execute a sproc ala:
   {CALL MySproc (?, ?, ?)}
However, this syntax does not work with a standard Statement. i.e. this
won't work:

We have a group of computers that are having problems connecting to our SQL
Server Database...
When they pull down the "Which SQL Server do you want to connect to?" box,
it shows the server twice.  If they select one, then the application fails,

I've just dropped a new Windows 2003 SP1 server with SQL Server 2000 SP4 in
my hosted center.  That server replaces an older Windows 2000 based server
running SQL Server 2000 SP3.  I have a firewall-firewall VPN setup between my
office network and the data centre.  I also have ...

While i think this is a pretty common error, i'm pulling my hair out
to try and figure out how to get around it / fix it...i believe this
is what is stopping Visual Studio.NET from connecting to SQL
Server...but if it isn't it is still something that shouldn't be

I cannot connect to our SQL Server 2005 Beta 2 database server from my
machine.  This is the error I get:
"A connection was successfully established with the server, but then an
error occurred during the login process. (provider: TCP Provider, error: 0 -

Hey All,
More fun and games with SQL Server 2005.
Mike: thanks for your help before on the Beta.  I was able to uninstall and
regain connectivity.  I didn't have to wipe the box, but came close!!  

I have a table with a few columns, and one of the non-PK columns is indexed
and defined as nullable. Most of my selects happen on this column, but I
notice that as the no. of rows in this table increase, the time for selects
keeps going up. This happens while accessing this table ...

Has anyone seen similar behavior?
The following error " Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections.
What is the definition of a "connection"?    For example, if I create a
connection pool of 5 connections in an application, does that count as 5
against the 25?

Hi, we have an application that is sending a large number of insert
statements (>5000) through ODBC to a SQL Server 2000 database. Apparently
this is causing the transaction log for that database to fill up which then
causes the web site that depends on that database to crash. We ...

Hi friends
I installed sql2000 dev edition on XP professional.i created a login in
sql.but whenver try to login to sql it says "this login is not associated
with trusted connection" and i cant login!!

I am not even sure I can do what I am hoping but, I need to debug a complex
sql query. I was hoping to be able to load it in profiler and step through
it. oddly, right off the bat it errors out telling me the table I am
referencing is not found in the database master, which is ...

I have a new SQL Server 2000 64-bit with Windows 2003 DataCenter.
I have loaded Oracle 9i client and the Oracle Provider for OLE DB on this
server.
I am trying to set up a SQL Server 2000 linked server with the Oracle

can anyone help me, i just need to confirm if the SQLServer driver for JDBC
supports Automatic Encoding Conversion?? THX!

I am trying to connect to a SQL Beta Database from Mapinfo using Integrated
Windows authenication, but I am getting error:
Connection failed:
SQLState: '08001'