ACCESSING PROGRESS DATABASE FROM SQL SERVER

[bd0606]

I've just installed SQL Server 2000 and I would like to connect it to my Progress Database. I try using the security option and adding a new linked server. But I can't use my ODBC connection (using the Merant SQL92 driver).
I'm sure my ODBC connection is good because I use it in Crystal Reports 9.0 and some Access Database.

Sorry for my poor english and thanks all

 

[sguslan]

Are there any errors reported ? ________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[bd0606]

Thank you for your answer. I found the solution. I use the security option and i have create a linked server ( i'm not sure of my translation ...). The only problem I had is the "string connection". It's not clear in the ODBC connection, so I have to use a udl file