I have a database which contains records each of which has a datetime field.  
The database machine is set up as GMT.  I access this data from a different
machine which is running in a different timezone (EST for example).  The
value returned by the database appears to be offset ...

Dear All,
I have installed MSDE2000sp3 on a XP Professional with the
default instance name equal to the computer name (e.g
COMP1). I have created a database in the local server. I

My firm will soon need to join the domain of our global firm. Currently I
have 4 SQL Servers in my old domain with replication setup. I have setup a
test server and I  have found that clients within the old domain have no
access to the SQL Server in the new domain, but clients in ...

Hi, I am developing DTS that extract data from Oracle via
Linked server. I'm using MS OLE DB for Oracle.
The following error message prompted when I query to
selected tables (12 tables out of 40+ tables) in Oracle.

I have an asp page that writes to an ntext field in SQL Server 2000.
All was going well until I had to put in a section of text greater than 8000
bytes.
Then I got a timeout error and the update wouldn't go through.

I am running SQL Server 2000 Developer (with Service Pack 3a) on
Windows XP Professional.  After installing Windows XP Service Pack 2,
I can no longer connect to SQL Server.  From Enterprise Manager, the
error shows up in a dialog when I click on the

Will there be a compatibility issue between my client ODBC
version 2000.80.194 and the SQL server 2003.

after executing a Stored procedure that returns about 10 strings I get a
"String data, right truncation" error in ODBC.  how do I know which string
was too long?
Leon

Is it possible to use a SQL Server stored procedure as a datasource for MS
Word mail merge? If yes then how?

I am hoping to import a file exported from mainframe (packed decimal) into a
SQL Server database.  Is it possible and if so, what is the best way to
accomplish this?
Thanks in advance.

SQL 7.0/NT 4.0
We have a C++ application using an ODBC call "SQLConnect"
to a SQL server which works just fine unless there's a
problem, e.g., SQL server goes down or something similar

I have a small domain, one web server one sql server.  
The web server has client tools installed on it.  I have
applied sp3 to both machines.  This afternoon, I
installed Analysis services on the web machine and reran

When calling a stored procedure in sql server passing just the Stored
Procedure name, my stored procedure name works correctly.  Below is
the String I use when performing Connection.prepareCall(String)
       {CALL sp_name (?,?,?)}

1) I'm using MS Sql Server 2000 JDBC driver at WSAD5.1.1.  
2) When I try to update the database in my DAO by using:
ps.executeUpdate();
3) Server throws the exception:

Experiencing 2 different errors before being able to connect to the database.
This happened 2 times, 7 days apart, and the problem was resolved by
selecting OK thru the errors and allowing the program (Access) to connect.
1st error occurs twice and the  2nd error, which is an ...