Wednesday, March 7, 2012

Incompability between MSSQL2000 SERVER 64 AND 32 BITS

eirs,
I'm using a "MSSQL2000 64 Bits" version, but I need to make some
distributed queries in the "MSSQL2000 32 bits" version. Do you know if there
is any incompatibility between these versions related to the using of the
linked server?
When I try to run a query from SQL 32 bits to 64 bits I have a sucess on
that execution, but when I try to execute query from 64 bits server I have
the message below:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to complete
this operation could not be found on the server (they were supplied with the
ODBC setup disk for the SQL Server driver). Please contact your system
administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
returned 0x80004005:]This is a multi-part message in MIME format.
--=_NextPart_000_042C_01C4E169.899D9C80
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
Linked Servers use xp .dll's. These are incompatible with the 64-bit OS.
When you call it on the 32-bit box, the .dll's run and the 64-bit responds
to the query.
The 64-bit BOL explains this.
Sincerely,
Anthony Thomas
"Wagner" <Wagner@.discussions.microsoft.com> wrote in message
news:102CA674-9EC2-4E53-ACEC-BB3A01EEC2F1@.microsoft.com...
eirs,
I'm using a "MSSQL2000 64 Bits" version, but I need to make some
distributed queries in the "MSSQL2000 32 bits" version. Do you know if
there
is any incompatibility between these versions related to the using of the
linked server?
When I try to run a query from SQL 32 bits to 64 bits I have a sucess on
that execution, but when I try to execute query from 64 bits server I have
the message below:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to
complete
this operation could not be found on the server (they were supplied with
the
ODBC setup disk for the SQL Server driver). Please contact your system
administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
returned 0x80004005:]
--=_NextPart_000_042C_01C4E169.899D9C80
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Linked Servers use xp .dll's. =These are incompatible with the 64-bit OS. When you call it on the 32-bit =box, the .dll's run and the 64-bit responds to the query.
The 64-bit BOL explains =this.
Sincerely,
Anthony Thomas
--
"Wagner" wrote in message news:102=CA674-9EC2-4E53-ACEC-BB3A01EEC2F1@.microsoft.com...eirs,I'm = using a "MSSQL2000 64 Bits" version, but I need to make some distributed queries in the "MSSQL2000 32 bits" version. Do you =know if there is any incompatibility between these versions related to the =using of the linked server?When I try to run a query from SQL 32 =bits to 64 bits I have a sucess on that execution, but when I try to execute =query from 64 bits server I have the message below:Server: Msg 7399, =Level 16, State 1, Line 1OLE DB provider 'SQLOLEDB' reported an =error. [OLE/DB provider returned message: Unspecified error][OLE/DB =provider returned message: The stored procedure required to complete this =operation could not be found on the server (they were supplied with the ODBC =setup disk for the SQL Server driver). Please contact your system administrator.]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset returned 0x80004005:]

--=_NextPart_000_042C_01C4E169.899D9C80--

No comments:

Post a Comment