SQL 2005 and Linked Server for DB2
- From: "Krisnamourt via SQLMonster.com" <u21487@uwe>
- Date: Thu, 27 Sep 2007 12:24:29 GMT
I'm upgrating SQL2000 to SQL2005 and some drives for DB2 access don´t work
any more.
The SQL2000 use Microsoft OLE DB provider for ODBC(MSDASQL) that work fine
and can't disactivate it.
At SQL 2005, this drive send this message:
Server: Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" has not been registered.
The SQL2005 is installed at 64-bits Failover Cluster, SP2, build 3161 -
Windows 2003 R2.
The other problem is about the drive Microsoft OLEDB provider for DB2
(DB2OLEDB).
This work fine at SQL2000, but at SQL2005 Failover cluster, another message
appear:
Server: Msg 7308, Level 16, State 1, Line 1
OLE DB provider 'DB2OLEDB' cannot be used for distributed queries because the
provider is configured to run in single-threaded apartment mode.
I read some foruns about DSN for 32 bits and 64 bits stored separately.
Well, I need some help about real necessity to configure both drives (MSDASQL
and DB2OLEDB) to work fine at SQL2005 64bits or great problems about
accebility between high and low end application(SQL and DB2).
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-setup/200709/1
.
- Follow-Ups:
- Re: SQL 2005 and Linked Server for DB2
- From: Krisnamourt via SQLMonster.com
- Re: SQL 2005 and Linked Server for DB2
- From: Shailesh Khanal
- Re: SQL 2005 and Linked Server for DB2
- Prev by Date: Re: Problem attaching Northwind traders sample database in SQL Server 2005
- Next by Date: SQL 2005 setup
- Previous by thread: SQL 2005
- Next by thread: Re: SQL 2005 and Linked Server for DB2
- Index(es):
Relevant Pages
|
