Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Change OLEDB to ODBC Post Reply Post New Topic
Author Message
itsarath
Newbie
Newbie
Avatar

Joined: 23 Oct 2007
Location: India
Online Status: Offline
Posts: 3
Quote itsarath Replybullet Topic: Change OLEDB to ODBC
    Posted: 02 Mar 2011 at 11:44pm
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


Edited by itsarath - 02 Mar 2011 at 11:46pm
sarath
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 03 Mar 2011 at 3:47am

Edit the report with the subreports.   Go to each subreport and Set Datasource Location for each to point to the new ODBC connection.  Then do the same in the main report.  Sometimes changing the location from the main report doesn't propagate down into the subreports correctly and I think that's what you're experiencing.

-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
itsarath
Newbie
Newbie
Avatar

Joined: 23 Oct 2007
Location: India
Online Status: Offline
Posts: 3
Quote itsarath Replybullet Posted: 03 Mar 2011 at 9:55pm
I updated both sub report and main report. now it is showling error msg like" Error in File E:\BOInstallation\BusinessObjects Enterprise 11.5\Data\procSched\WBWBURTVCLAR2.reportjobserver\~tmp1984681c547e000.rpt: Error in formula <Period hdr>. '"Period: "+ {?param_period}' This field name is not known. Details: errorKind"
 
But the same report using OLEDB connection type it is working.
sarath
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 04 Mar 2011 at 3:28am
That's odd, because it doesn't look like you have a field in the formula - instead you havea  parameter.  Does the parameter still exist with that same name?
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.