Advanced Database Setup for RoboHelp Server 8

[tuls_garg]

By default RoboHelp Server 8 gets installed with MS Access as the database which is suitable for internal use or in a development environment.
But for production environment, users should use Microsoft SQL Server/Oracle/SQL Server Express.
Steps to configure oracle/sql server as database –
1) Launch the Config Manager and select File > Open Context and select the context for which you want to configure the database.
2) Select radio button "Oracle 9i or higher/Microsoft SQL Server/SQL Server Express Edition".
3) Create a system DSN using ODBC administrator. To do so, click on the “ODBC Admin” button. This will launch the “ODBC Data Source Administrator”. Click on the “System DSN” tab and then click on “Add” button and select the driver type depending on the kind of database your are using. Then give the Database server details and the user name and password to connect to the database. Press OK.
4) Now select this newly created DSN from the “Select DSN” drop down.
5) In the username, password fields, specify the username and password used to create the DSN.
6) Click “Save”.
7) You can verify if RoboHelp Server has all the information to connect to the database by clicking “Test Connection”. If connection details are OK, it should show a dialog box saying “Successfully connected to database”.
8) Close Config Manager using File>Exit.

Tulika.
RoboHelp Server Team.
Adobe Systems.

[cpalmgren]

Tulika,

We have been dealing with an issue with Roboserver not searching content. We have gone months trying to fix it and weeks with Adobe tech support. It is critical we get this running. Comments from other threads give me hope you can help. The project works. At one time the server did as well. The files we sent in to Adobe worked fine on their server. We built a new server yesterday, installed the software per instructions, and used new machines to publish the data. Still the Advanced search does not work.

Anything you could do would be appreciated.

Charles

[Guest]

What do you mean by Advanced Search? You replied to a post regarding setting up DSN to connect to a SQL DB.  Please clarify what you are wanting.

JC

[cpalmgren]

It is unclear of our true issues. I may have been slightly off the

best thread. I'm getting desperate to fix this.

We have been fighting with the roboserver for months following Forums

and help files.

For weeks we have been trying to get Adobe support to help but they

insist on the long way and as of yet have not been able to help.

We can get the search to work as HTML but not the advanced search from

the server. "Sorry, we were unable to find a good answer for your

question." is all we can ever get.

I saw the "Advanced Database Setup for RoboHelp Server 8" and thought

it may be relevant.

If I am on the wrong thread we can ask to delete the question but I

hope you can help.

Thanks

Charles