Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: SQL Command - Set Datasource Location Post Reply Post New Topic
Author Message
aneeshjk
Newbie
Newbie


Joined: 29 Oct 2010
Online Status: Offline
Posts: 4
Quote aneeshjk Replybullet Topic: SQL Command - Set Datasource Location
    Posted: 01 Nov 2010 at 7:52pm
Hi,
 
I got some cyrstal reports where it runs in MS-SQL server, where I want to replicate the same reports in Oracle DB. These reports use Command Object where the SQL queries are embedded. The Reports use OLEDB connection.
                   I have modified these queries in Oracle syntax , tried to update in the 'Set DataSource Location'. I tried to keep the updated queries under 'Add Command' of 'Replace with' section. After which I tried to click the 'Update' Button, the new Oracle connection haven't replaced the existing SQL Server connection.
 
 I don't want to change the structure of the report,  just wanted to change only the data source- from SQL Server to Oracle source and also keep the updated Oracle query in the SQL Command. My other concern is - Will the fields that were referred in the Design will be retained once the data source is changed ?
 
Can anyone help me in this how to resolve it?
 
Thanks in advance,
Aneesh
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 05 Nov 2010 at 4:01am
Which version of Crystal are you using?  When you Set Location, make sure you have the database/connection name selected in both parts of the screen, not the command name.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
aneeshjk
Newbie
Newbie


Joined: 29 Oct 2010
Online Status: Offline
Posts: 4
Quote aneeshjk Replybullet Posted: 05 Nov 2010 at 10:01pm
I am using CR v11 . I tried the above option and also updated the query in 'Add Command' under the new connection, but the new connection wasn't able to reflect in the report.

Let me know the steps if you come across in migrating from SQL Server to Oracle using Command Object.

Thanks,
Aneesh
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.031 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.