Re: can't get an answer to a crystal rpt question re database connection - Cor, Herfried, Armin, Ken Tucker?

From: Bernie Yaeger (berniey_at_cherwellinc.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 14:52:02 -0500

Hi Jorge,

Tx for your help; I think I'm in the right direction now.

Bernie

"Jorge Cavalheiro" <anonymous@discussions.microsoft.com> wrote in message
news:115601c3fb88$1a8a9680$a401280a@phx.gbl...
> As addenda to what i say.
>
> All MS SQL Servers have a Master database.
>
> You can use the following command :
> <code>
> Use Master
> exec sp_databases
> </code>
> That will return all databases on the server and there
> size.
>
> You still need to have the database admin password on
> your client to run this.
>
> Kind Regards
> Jorge Cavalheiro
>
>
> >-----Original Message-----
> >Hello Bernie
> >
> >You can use the SQL-DMO ListAvailableSQLServers to
> >retrieve all SQL servers on your client. If there's only
> >one then use that one if not ask the user which one to
> >use.
> >
> >And when you define the ConnectionInfo of the report you
> >can use .ServerName = <your variable>
> >
> >Kind Regards
> >Jorge Cavalheiro
> >
> >
> >>-----Original Message-----
> >>I can't believe that there aren't lots of developers
> who:
> >>
> >>1. create a crystal report that connects to sql server
> >>2. calls the report using the crystalreportviewer
> >control to view it and
> >>then, if appropriate, print it
> >>3. tries to deploy that report to the client's
> >database, but now it calls
> >>for a different database name
> >>
> >>Yet I can't get an answer to the question:
> >>I have developed numerous reports in an app (Windows
> >Database App) that is
> >>soon to go into production. When I built each report,
> >CR connected to sql
> >>server on my development platform. The connection
> >string is different than
> >>it will be at my client.
> >>
> >>How can I change the connection string so that it
> >recognizes my client's
> >>server instead of mine for each of these reports?
> >>
> >>Of course, I could install a version of crystal on the
> >client and rebuild
> >>the reports there, but that seems a terrible pain - and
> >for every customer
> >>with sql server? I've written to crystal and I get
> >links to unhelpful kbase
> >>articles.
> >>
> >>Thanks for any help.
> >>
> >>Bernie Yaeger
> >>
> >>
> >>.
> >>
> >.
> >

Relevant Pages