CreateTab ContentStorage, connect error SQLConnect failed

[Former Member]

Hello All,

I am trying to create a content repository for our Content Server in transaction CSADMIN but am getting the following error message:

HTTP error: 500 (Internal Server Error)

"CreateTab ContentStorage, connect error

SQLConnect failed, [Microsoft][ODB Driver

Manager] Data s

The Database is Online, the 'SAPDB: UCS' service is running and the SAP_Content_Server IIS is running. I can see no error messages in the logs.

Anyone know what the cause of this error could be?

Thanks

[Former Member]

I was able to resolve this by registering the ODBC driver, sqlod32.dll as described in note 301352

[Former Member]

Thanks for answering your own question for others to see James. Did you award yourself points?

Follow on question for you; did you use the word Livecache in the statement? I'm not familiar with ODBC so don't want to break anything.

This is the statement from note 301352. I'm installing Content Server, not LiveCache:

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

Thanks,

David

[Former Member]

And now to answer my own question. Yes, just issue the command in note 301352 to register the driver and it worked.

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

Note that in CSADMIN the parameter 'driver' in the Settings tab is LiveCache. You could probably play around with that and change it but I just issued the command exactly as in the note.