Question How to connect between SQL and Progress DB?

[qadvietnam]

Hi all,

I have 2 servers: Linux server and Windows server
I am using Progress database 10.0B04 for my production enviroments. (Linux server)
I use SQL server 2008 (Windows server)

I can create ODBC agent on Windows, and can test success connect but when we try to open SQL server, and create "Linked Servers" on the left hand of SQL management panel, We can not create it. Pls see image as below for more detail:

Can anyone can give me high recommend how I can config success connect between SQL and Progress DB?

Give me any guide documentation for reference if yes

Thanks,
QAD Vietnam

 

[RealHeavyDude]

You can use the ODBC driver that comes with your runtime installation. In order to have them installed you must either do a full installation or selected them when you do a customized installation. The typical installation won't install them.
Furthermore it is recommended to set up the database accordingly for a secondary login broker dedidcated to SQL clients:
http://knowledgebase.progress.com/articles/Article/P7843
Plus, you need to set up the SQL security if you've not already done so - it is not setup out-of-the-box:
http://knowledgebase.progress.com/articles/Article/20143
Heavy Regards, RealHeavyDude.

 

[qadvietnam]

RealHeavyDude.

Thanks for your kindly ans
Let me try to test it now

Regards,
QAD Vietnam

 

[qadvietnam]

I can fix this issue with uncheck link option in SQL

Thanks all support,
QAD Vietnam