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

From: Jorge Cavalheiro (anonymous_at_discussions.microsoft.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 02:14:07 -0800

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

  • Re: Insert Error: Column name or number of supplied values does no
    ... I did use a log file which gets the following: ... As to running interactively, if you don't mean using the database wizard, I ... > table structures are different between your prod and dev SQL Servers. ... > Can you run the DTS package interactively and see on which table you are ...
    (microsoft.public.sqlserver.dts)
  • Re: Error 15022: The specified user name is already aliased.
    ... Issues When a Database Is Moved Between SQL Servers ... > permit role it shows that the user has a dbo role. ...
    (microsoft.public.sqlserver.security)
  • Re: Alternative to Dynamic SQL?
    ... SQL servers are fully locked down. ... We have a single user per database. ... each query is usually tied to a method. ... DBA....and Tony was the developer and Tony wanted a pagination query, ...
    (microsoft.public.sqlserver.programming)
  • Re: Move System and User database
    ... Andrew, Thanks for your reply! ... will the sa password be moved to the new server if system database ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.server)
  • RE: updated numbers in report
    ... for making an input to the database. ... textbox will be located alongside with the combobox where the belonging ... belonging query for the report. ... ElapsedTime([Date First Time Onboard], ...
    (microsoft.public.access.dataaccess.pages)