Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 12th, 2007, 06:25 AM
Nii Nii is offline
Registered User
 
Join Date: Jul 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Nii
Default Alter Crystal Report9.0 DSN in VB6.0

Hi All,
I want to alter the ff DSN settings for Crystal9.0 files in visual basic6.0 at run time .
Database,Password,User Id.
Currently I have the ff snippet which doesnt work,it brings the details in the database with which i created the files

For Each crxDatabaseTable In SourceReport.Database.Tables

lstrLocation = crxDatabaseTable.Location
crxDatabaseTable.ConnectionProperties.DeleteAll
crxDatabaseTable.ConnectionProperties.Add "Integrated Security ", 0
crxDatabaseTable.ConnectionProperties.Add "DSN", "DSN"
crxDatabaseTable.ConnectionProperties.Add "Database","Database"
crxDatabaseTable.ConnectionProperties.Add "User ID", "User Id"
crxDatabaseTable.ConnectionProperties.Add "Password", "Password"
crxDatabaseTable.ConnectionProperties.Add "Owner", "dbo"
crxDatabaseTable.ConnectionProperties.Add "Table Schema", "dbo"
crxDatabaseTable.ConnectionProperties.Add "Table Owner", "dbo"

lstrLocation = "Initial Catalog" & "." & "dbo"
'crxDatabaseTable.Location = lstrLocation
Next crxDatabaseTable

Nii Darko Darkoh





Similar Threads
Thread Thread Starter Forum Replies Last Post
crystal report9 with password protected MSACCESS zrtv Beginning VB 6 4 April 22nd, 2009 03:23 PM
connect VB6 with Cystal report9 nishab345 VB How-To 1 May 30th, 2007 11:51 PM
Crystal report9 and VB6 vaneza VB How-To 1 June 29th, 2005 11:34 PM
Crystal Reprot without DSN ashu_from_india Crystal Reports 2 May 7th, 2005 07:51 AM
Application DSN and Session DSN ssampanthar Classic ASP Databases 0 January 6th, 2005 01:23 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.