Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: How to Change OLE Datasource to ODBC Post Reply Post New Topic
Author Message
mcslayton
Newbie
Newbie
Avatar

Joined: 29 Oct 2008
Location: United States
Online Status: Offline
Posts: 1
Quote mcslayton Replybullet Topic: How to Change OLE Datasource to ODBC
    Posted: 29 Oct 2008 at 6:54am
Our installation uses an external app to invoke the Crystal Reports viewer. I do NOT have access to the source to this app.
 
I accidently created a report with Commands for an OLE data source, but unfortunately, the app above requires / uses / permits ONLY ODBC connections. How can I change the report to point to the ODBC connection rather than the OLE connection WITHOUT REDEVELOPING EVERYTHING?
 
I have already tried everything I can think of in the Database Expert to no avail. I lose command-based formulas, etc. after the switch.
 
Please help!
 
Thanks...
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 31 Oct 2008 at 1:47am
Hi
 
Do you have access to Database Expert ,If YES Open the report  then Select the Menu Database then Select Set Datasource Location
 
In the Dialog Box in the Replace With Section Create the new Obdc Connection Once done
 
Highlight the Current Data Source Connection then Highlight Replace with Connection and Click Update.
 
Cheers
Rahul
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.047 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.