<larclap@yahoo.com> wrote in message
news:1166172019.412378.158340@l12g2000cwl.googlegroups.com...
>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?
>

<larclap@yahoo.com> wrote in message
news:1166172019.412378.158340@l12g2000cwl.googlegroups.com...
>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?
>

>
> 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?