Posted by mkarbarz@gmail.com on 02/06/07 22:35

On Feb 6, 5:09 pm, "Steve" <morrisz...@hotmail.com> wrote:
> On Feb 6, 1:25 pm, "mkarb...@gmail.com" <mkarb...@gmail.com> wrote:
>
> > Hello,
>
> > I need to come up with a stored procedure that will allow me to read
> > data from another database. The database I need to read the data from
> > is a UniData residing on a Unix server. The stored procedure needs to
> > reside on my sql 2005 server. The task is very simple in Access as we
> > have ODBC connections set up to the UniData via Informix (or IBM)
> > UniData ODBC drivers. I can easily combine my UniData and Sql Server
> > tables from within access. However, I can't seem to find a way to
> > replicate the same behavior in MS SQL Stored Procedure without the use
> > of Access. Is that even possible?
>
> > Thanks,
>
> > Marek
>
> Linked server or OPENROWSET
> In SQL Server 2005 Books Online see the topic: Distributed Queries

I started playing around with the linked server and I got it to the
point where I can see the tables from UniData, but when I try to query
it using LINKEDSERVERNAME...TABLE I get 'Invalid schema or catalog
specified for provider 'MSDASQL'." error. When I try to specify
schema using LINKEDSERVERNAME.SCHEMA.TABLE I get 'Invalid object name
LINKEDSERVERNAME.SCHEMA.TABLE'; do you know why these errors occur
and how to get around them?

[Back to original message]