Print Page | Close Window

how i can change OLEDB connection properties?

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=2394
Printed Date: 17 Apr 2025 at 3:49pm


Topic: how i can change OLEDB connection properties?
Posted By: mohamed_salafi8
Subject: how i can change OLEDB connection properties?
Date Posted: 21 Feb 2008 at 12:37am
I have a report for printing data from MSSQL database.
For connecting to database i'm using OLEDB Provider for SQL Server. In designer my report working Ok. But at runtime i should change the server name and/or username, password or database. So i can't change server name.
Always if i use other Server, i have connection failed.
At runtime i'm using Delphi 7 and CR VCL for Delphi 7. For
changing connection parameters i'm use the Connect property. Also this problem occured in sample application which shipped with CR VCL.
Please, tell me: how i can change OLEDB connection properties?


Replies:
Posted By: hilfy
Date Posted: 22 Feb 2008 at 7:56am
Unfortunately it's been years since I've had to call Crystal from Delphi and that was back in Delphi 5, so I'm afraid I'm not going to be much help here.
 
I'm not sure you're going to be able to find someone here with that information as this forum is mostly centered on Microsoft technology.  Your best bet is probably going to be to go to the Crystal Developer forums at http://diamond.businessobjects.com/ - http://diamond.businessobjects.com/ .
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window