Print Page | Close Window

SQL Command - Set Datasource Location

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11572
Printed Date: 03 May 2025 at 2:32am


Topic: SQL Command - Set Datasource Location
Posted By: aneeshjk
Subject: SQL Command - Set Datasource Location
Date 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


Replies:
Posted By: hilfy
Date 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
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: aneeshjk
Date 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


Print Page | Close Window