Informix to MS SQL Server 1

[rgbanse]

I'm new to SQL Server. In MS Access I would ODBC link to our Informix DB tables and do my thing from there. Is there a way to link Informix into SQL Server as you would do in Access or is there an alternate method.
thx
RGB

 

[tlbroadbent]

You can link many different data sources in SQL Server. You'll probably need to download an OLEDB driver from Informix. I don't think one is supplied with SQL Server.

Check the following SQL BOL topics and MS Articles for more information. Most is general and not specific to Informix. However, most should apply.

TOPICS:
sp_addlinkedserver
sp_addlinkedsrvlogin
Configuring Linked Servers
Establishing Security for Linked Servers

ARTICLES:
Accessing Heterogeneous Data with Microsoft SQL Server 7.0

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/heterodata.asp

Creating a Heterogeneous Query with Microsoft SQL Server 7.0

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/sqlinkserv.asp

Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[rgbanse]

Terry,
thanks a bunch - I'll start working through this
More than likely will be back at ya
thx
Jerry