Connect SQL 2005 to another database?

I'm trying to connect my SQL server to a Progress database. I have the DSN setup but I don't have a clue how to get to it or the database I'm trying to access. All I want to do is be able to view all the tables in SQL from the Progress database so I can build reports. I can't imagine this is too difficult but right now it is for me. Any help is greatly appreciated.
Thanks,
Tony Sheehan
Tony
Linked Servers?
"Tony" <tsheehan@.tji-holdings.com> wrote in message news:%23qeeAlMbIHA.1168@.TK2MSFTNGP02.phx.gbl...
I'm trying to connect my SQL server to a Progress database. I have the DSN setup but I don't have a clue how to get to it or the database I'm trying to access. All I want to do is be able to view all the tables in SQL from the Progress database so I can build reports. I can't imagine this is too difficult but right now it is for me. Any help is greatly appreciated.
Thanks,
Tony Sheehan
|||Hi Uri,
Thanks for the idea. I managed to speak with someone yesterday that mentioned this and this is the answer I was looking for. Thank you for your reply.
Tony
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:eg8bdBVbIHA.3696@.TK2MSFTNGP03.phx.gbl...
Tony
Linked Servers?
"Tony" <tsheehan@.tji-holdings.com> wrote in message news:%23qeeAlMbIHA.1168@.TK2MSFTNGP02.phx.gbl...
I'm trying to connect my SQL server to a Progress database. I have the DSN setup but I don't have a clue how to get to it or the database I'm trying to access. All I want to do is be able to view all the tables in SQL from the Progress database so I can build reports. I can't imagine this is too difficult but right now it is for me. Any help is greatly appreciated.
Thanks,
Tony Sheehan