Check how the report is built in Crystal. In many cases Crystal
appends the dbname to the table in the report. If this is the case, it
will only run against the one database. Remove the dbname prefix and
you should be all set.
Kevin Ridley
[EMAIL PROTECTED]
--- Laxmikant Kesti <[EMAIL PROTECTED]> wrote:
> Hi Friends
>
> I have created an application in PB 6.0. The back
> end can be MS SQL Server 6.5
> or MS Access 7.0. For reports we are using crystal
> report 5.0.
>
> I have created two Data Source Names DSN_Sql and
> DSN_Access for accessing the
> databases in MS SQL Server 6.5 and MS Access
> respectively. I have created a
> report using DSN_Sql dsn. This report is called in
> Powerbuilder ( through OCX
> control).
>
> When a application is running on SQL Server, the
> report shows correct data,
> but if application is running on MS Access database,
> the data is not shown
> properly.
>
> Can anybody help me to find what is the problem.
>
> Laxmikant Kesti
>
>
>
>
> ____________________________________________________________________
> Get free e-mail and a permanent address at
> http://www.netaddress.com/?N=1
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH
> LIST SERVE COMMANDS, ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING
> MESSAGE: help pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
>
_____________________________________________________________
Do You Yahoo!?
Free instant messaging and more at http://messenger.yahoo.com
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
