SQL Server Connection to Red Brick
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!!
Networks
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!!
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
by frankus
by frankus
This discussion is closed to new replies.
Sort by Trending