Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Components
VB Components Issues specific to components in VB.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Components 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 November 6th, 2007, 05:17 AM
Registered User
Join Date: Nov 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default CRYSTAL REPORT 9 Changing Connection Properties

I'm using crystal report and vb6. how can i change the connection properties of the crystal report in vb6?

In my crystal report i used stored procedure to create the report. What if i change my database name how can i change the properties in vb6 so i wouldn't change the crystal report anymore. im using ms sql server.

this is my code...

Global crxReport As CRAXDRT.Report

    With crxReport.Database.Tables

        For intCount = 1 To .Count
            .Item(intCount).ConnectionProperties.Item("Data Source") = sServer
            .Item(intCount).ConnectionProperties.Item("Initial Catalog") = sDBName_
            .Item(intCount).ConnectionProperties.Item("User Id") = sUserName
            .Item(intCount).ConnectionProperties.Item("passwor d") = sPassword

    End With

the reports are working fine but if i change my database name it doesn't work anymore...

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Database location for crystal report swarnapy VB How-To 0 August 27th, 2006 11:37 PM
Crystal Report Changing Orientation garrysmith68 Beginning VB 6 0 June 6th, 2006 06:42 AM
changing Password dynamically in crystal report irfanthegame Crystal Reports 0 October 7th, 2005 06:59 AM
Changing Crystal report display dynamically Sujith Manuel Crystal Reports 0 December 17th, 2004 01:59 AM
Changing source table of crystal report at runtime bhavanipodipireddy Crystal Reports 1 January 16th, 2004 08:35 AM

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