I have a problem with a newly installed system where I can't seem to login
from a client. The SQL Server is set up for mixed authentication, and I can
login locally (using the Managment Studio). I have checked the the event
log, which verifies that the SQL Server indeed has ...

I dont know if this is the best place to ask this question...
Is there a DLL etc, to allow connection to a MSSQL 2000 and 2005, from a
simple C application, preferably via TCP port 135?
I dont want an overly complex COM etc, solution. Just something which

I am trying to connect to SQL2005 server, and the script is written in ASP.
I am trying to figure out why I am getting this error as below;
  Microsoft VBScript runtime error '800a0005'
  Invalid procedure call or argument: 'Mid'

Can MS Query be used to update data within a database?
I have tried replacing SELECT with UPDATE but no luck...
Thanks
Richard

My users are getting this error intermittently, they can be connected fine &
then this pops up.  Users close the error box & then can move on. We are on
SQL server 2000, running 3rd party software. I can not recreate the error,
since it happens sporadically, so I have to capture ...

I am working on a new project where we would like to eliminate processes that
involve bulk loading data extracted from an Oracle 10g database into a SQL
Server 2005 database.  The extracts come in the form of Excel worksheets.  
Can I get the data from the Oracle DB directly, ...

I am finding that the adaptive buffering returns rows at the same rate as
the server side cursor.  It may improve client memory footprint on large
resultsets but I cannot seem to get performance up to the level of a similar
app written in .NET using SqlDataReader classes.  The ...

I'm using the latest SQL Server 2005  and  jdbc driver. (both downloaded
this week 7/15/05)
I'm trying to insert xml data into an xml column and am getting this error:
com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would

According Internal/External audit and security purpose, in our production
SQL instance, I changed sa password about three weeks ago.
Its working fine until this morning, when I try to use sa login to SQL, I
got following error message:

I created an ODBC connection with the Microsoft ODBC for Oracle driver and
successfully connected to Oracle from Microsoft Access by creating a pass
through query.  Can I use this connection from within SQL Server 2000 to
issue a Select statement and pull data from an Oracle ...

We have an old access database which someone is trying to connect to from a
linked server in SQL2005. In SQL2000 this worked with no issue however I
cannot now find a ole db provider which will allow me to connect to this db.
Is this possible anymore or does the fact that it is ...

For some reason Microsoft's ODBC driver for MS Access reports an index
for every foreign key that exists on a table.
For example, consider the two tables.
create table parent(id integer primary key)

I'm running some queries in multiple (like ~100) threads using plain JDBC and
MS JDBC driver.
What I'm observing is that most threads are waiting for
java.util.logging.Logger class monitor trying to enter

Hi
I have program with a SQL connection on my computer works fine and when
I  connect remotely on the another computer it works
but when I start program from the remote computer it doesnt work

Periodically I'll have these errors in SQL 2k5. Error: 18456, Severity: 14,
State: 27. After a while, they'll stop. What is causing these errors? Why
don't they occurr with every connection attempt?
The database used in the connection is a mirrored database. I do not know