cancel
Showing results for 
Search instead for 
Did you mean: 

Change OLEDB to ODBC

Former Member
0 Kudos

Hi,

I created reports using Crystal XI (version 11.0) and database sql server 2005 using oledb connection. After report created i deployed in CMC.

Now i want to change to ODBC connection type.

Report which does not have subreports are working fine while using ODBC connection type.

Reports which have subreports getting error like

"

Error in File E:\BOInstallation\BusinessObjects Enterprise 11.5\Data\procSched\WBWBURPVCLAR3.reportjobserver\~tmp124c67edef37980.rpt: The request could not be submitted for background processing".

By using OLEDB connection it is working fine.

Can any one help me on this

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Why are you changing the data source? ODBC is just another layer on top of the client. SQL Server uses OLE DB as the client engine.

I don't see any advantage of doing this. Can you explain why you want to?

Thank you

Don

Former Member
0 Kudos

Hi,

By changing oledb to odbc we can change the servers from development server to production server without changing server details in the report.

we change the database name in ODBC driver itself where we put the db server name. No need to update the reports.

0 Kudos

That's what the CMC allows you to do.

Moving your post to the BOE forum. this isn't a Cr issue.

Former Member
0 Kudos

HI.

Are you created the ODBC in BOE Server?

Regards, Jaime

Former Member
0 Kudos

I created in BO Server also