Posted by Steve on 02/06/07 22:09

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

• Next in forum: Re: Who Turned off the SQL Server AGENT???!!!!
• Prev in forum: Stored Procedure querying another database
• Thread view: Re: Stored Procedure querying another database

[Reply to this message]