Friday, March 9, 2012

server vs Advantage Local Server

I'm trying to define a linked server (from within SQL Server 2005
Express) to an Advantage Local Server.
Using OpenQuery, I get error message:
Cannot create an instance of OLE DB provider 'Advantage.OLEDB' for
linked server 'LStest'
A linked server to an Advantage Database Server (remote) works fine. Is
there a way to make it works locally?
Thanks a lot in advance for help,SQL Server Standard works fine...
"rcloutie" wrote:
> I'm trying to define a linked server (from within SQL Server 2005
> Express) to an Advantage Local Server.
> Using OpenQuery, I get error message:
> Cannot create an instance of OLE DB provider 'Advantage.OLEDB' for
> linked server 'LStest'
> A linked server to an Advantage Database Server (remote) works fine. Is
> there a way to make it works locally?
> Thanks a lot in advance for help,
>

No comments:

Post a Comment