Adapt existing QaaWS from MS SQL to Oracle DB

[Former Member]

Hey there,

I have searched for an answer on the Web but cannot find one, so perhaps you can help me:

I am adapting an existing Query as a Web Service from an MS SQL Server to an Oracle DB. After entering the default parameter value for the Query, an error message pops up:

"A database error occured. The database error text is: (CS) "DBDriver failed to load : C:\BOE\BusinessObjects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\dbd_oci.dll (The specified module could not be found.)" . (WIS 10901)"

I checked for this file, but it is there and checked WebIntelligence to connect to the Oracle DB and that works fine.

Do you have any suggestions/ideas?

Thanks you in advance,

Nils May

[Former Member · Accepted solution]

Hi,

Could to edit the QaaWS and again map it to the Universe using Oracle DB.

Hope this helps.

[Former Member · Accepted solution]

Hi..Saifuddin, can you describe more detail? i have the same problem. kindly help.

Regards n thanks

[Former Member · Accepted solution]

Hi,

You can try the following:

1. First check the Universe connection and make sure it is connected to right DB. Oracle or SQL Server.

2. Copy the existing QaaWS and again select the Universe which is connected to correct DB.

3. If that doesn't work, create a new QaaWS.

4. If using parameter, specify parameter and verify data.

Hope this helps.