I want to create a link between SQL Server and DB2(IBM
AS400). I'v used those paramters:
EXEC sp_addlinkedserver
  @server='DB2',

Could you give me a list of advantages using OLEDB in stead of ODBC? Is
there an idea of getting good informations how to handle OLEDB?
My problem is by using ODBC  for a WebApplication the
system often is blocked. I hope the system gets

I'm running ms sql server 2000 with service pack 3 and
jdbc driver (service pack 3 too). But i still encounter
this error: [Microsoft][SQL Server 2000 Driver for JDBC]
Unhandled token type: COLINFO

I have a SQL 2000 database and I'm using Access 2003 to gain access to the
tables.  All cells contain #Deleted.
What am I doing wrong?
TIA

I am currently porting some software to support SQL Server.
The software will act as a client and I'm having no problem
with that.
My problem is that I currently build and test my application

Hi all -
I need a way to detect a dead connection.
I realize there has been a problem with SQL_ATTR_CONNECTION_DEAD , so
I use

I have SQL Server 2000 SP3a installed on Windows 2003 server.
Client is Windows XP machine. Up to today I have no problems connecting to
SQL Server - my Windows ID is assigned as SQL administrator.
This morning I installed Windows XP SP2. I logged in to windowx XP using my

Receiving the following error:
Message: SQL Server does not exist or access denied.
Source: .Net SqlClient Data Provider
 at System.Data.SqlClient.ConnectionPool.GetConnection

I was able to successfully create a linked server to AS400 box without
any problem. But now, due to some reason the following query does not
return any data (0 rows)
Select * from openQuery(CWBIS800, 'select * from lib.tb where cmln =

We have the following problem:
Separate application server and database server.  Both
Windows 2003.  On both MSDTC 2.8 installed. Bith in same
domain.  Both in same network segment.

I have a java program that run on SQL Server 8.00.760 and
original JDBC drive is no problem, but after apply the SQL
Server SP3a 8.00.818, when execute a long sql script will
got error (Invalid buffer received from client.. Error:

I have a relatively simple application that is for my own
use (not distributed on an enterprise-wide basis).  As I
don't have an IT staff, I'm using a rudimentary Java
front-end (v1.3.1) and a Microsoft Access backend.

hi, i am having a difficult time trying to connect to my
SQL server with the odbc drivers. i have it set to named
pipes right now and when i try to switch back to tcp/ip, i
come up with the above error, and says user 'null'. not

I am connecting to a SQL Server database from ASP pages.  
The web site and SQL Server are on two different
machines.  The web server is running 2000 server.  
Everything works fine.

Has anybody, anywhere figured out a way to use a trusted connection (Windows
authentication) with OPENROWSET?  The first two queries below used to work
just fine because they use SQL authentication.  The four queries after that
are various sad, sad (and unworking) attempts I've made ...