RE: Error using OPENROWSET

From: "anonymous_user@xxxxxxxxxxxxxxxxxxxxxxx" <anonymous_user@xxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 10 Jan 2007 09:40:07 GMT

I have the following statement:

INSERT INTO MailHouse2.dbo.ClientUseCode
(ClientID, CountyFips, UseCode)
SELECT *
FROM OPENROWSET('SQLOLEDB.1','Provider=sqloledb.1;Data
Source=(localhost);Initial Catalog=MailHouse;uid=uid;pwd=pwd;',
'select 1 as ClientID,u.countyfipsid as CountyFips, u.usecodeid as
UseCode
from usecode u
inner join univusecodemap m on u.usecodepk=m.usecodefk
inner join compusecode c on u.usecodeid=c.usecode')

I know the inner select works because I've run it on the Mailhouse
(SQL2000) instance. However, when I run the entire query above from the
MailHouse2 (SQL2005) instance, I get the following error:

OLE DB provider "SQLNCLI" for linked server "(null)" returned message
"Deferred prepare could not be completed.".

Can someone help PLEASE?

Prev by Date: Re: Error using OPENROWSET
Next by Date: Playing w/queries
Previous by thread: Re: Error using OPENROWSET
Next by thread: MDX newbie question please
Index(es):
- Date
- Thread

Relevant Pages

Error using OPENROWSET
... (ClientID, CountyFips, UseCode) ... inner join univusecodemap m on u.usecodepk=m.usecodefk ... I know the inner select works because I've run it on the Mailhouse ...
(microsoft.public.sqlserver.datamining)
Re: Error using OPENROWSET
... (ClientID, CountyFips, UseCode) ... inner join univusecodemap m on u.usecodepk=m.usecodefk ... I know the inner select works because I've run it on the Mailhouse ...
(microsoft.public.sqlserver.datamining)