error whicle creating repository in CSADMIN

[Former Member]

Dear Experts,

I have installed content server 6.40 .While installation i did chose only sap content server and options for maxdb database instance , Cache server were not selected . We are havin win server 2003 as OS and IIS is runing.

After successful installation i treid to create repositroy in CSADMIN but getting following error .

HTTP error: 500 (Internal Server Error) "CreateTab ContentStorage, connect

error SQLConnect failed, [Microsoft][ODBC Driver Manager] Data s

Message no. CMS025

Diagnosis

Error in accessing via HTTP

500 (Internal Server Error)

"CreateTab ContentStorage, connect error SQLConnect failed,

[Microsoft][ODBC Driver Manager] Data s

Thanks,

Rushikesh

[Former Member]

Hi,

Suggest you to check Note 1293399 - looks like the drivers are not registered correctly or the DB might be down.

Also, content server 640 should be set on MaxDB <=7.6.

Regards,

Srikishan

[Former Member]

Issue resolved

[former_member255281]

HI.

I have same problem.

Can I know how you can solve the problem?

Thanks.

Edited by: Bong Su Ko on Jan 12, 2012 2:56 AM

[Former Member]

Hi,

check the below steps..

Solution

You can subsequently install the ODBC driver 'sqlod32.dll' using the tool 'odbcreg.exe' in the \pgm directory of the SAP DB installation (usually c:\sapdb\<DBNAME>\db\pgm).

The call syntax is as follows:

odbcreg LiveCache -i -p <complete path to sqlod32.dll>
(Note: The path you have to enter specifies the directory in which the Dll lies, it does not specify the DII itself.)

For example:
odbcreg LiveCache -i -p c:\sapdb\<DBNAME>\db\pgm

Note: As of SAP DB Version 7.3.00 Build 33, you are required to register to another path. The example would then be as follows:

odbcreg LiveCache -i -p c:\sapdb\programs\pgm

The LiveCache ODBC driver should then be registered in the Control Panel -> ODBC Drivers -> Driver tab.