Discussion Locked

SQL Server Connection to Red Brick

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to access a table in a Red Brick (Informix) Warehouse database from a stored procedure in MS SQL Server 7.0.
I have no problem connecting from Access 97
Help!!

3 replies

by roc180

I believe there is a driver for Red Brick. Use the driver to create a linked server to the Red Brick database and then you can access the tables from within your stored procedure. Check help under sp_addLinkedServer.

Good Luck

Neal Martinelli

This discussion is closed to new replies.