Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Change DSN has no effects Post Reply Post New Topic
Author Message
pskossu
Newbie
Newbie


Joined: 09 May 2011
Location: Finland
Online Status: Offline
Posts: 1
Quote pskossu Replybullet Topic: Change DSN has no effects
    Posted: 09 May 2011 at 9:29pm
I'm using cr XI with iSeries access For DB2 ODBC driver.
Problem:
I have two dsn-files, named XXYYKE.dsn and XXYY.dsn
In dsn-files  are differend  databases (XXKEFI and XXFI) and user id's.


Report is created with XXYYKE.dsn.
If i run script where all tables and all subreports tables
dsn is changed with ".SetDataSource"  from XXYYKE.dsn to XXYY.dsn.


Before chancing rpt.SQLQueryString shows  ... "from" "SB565655"."XXKEFI" ...
After dsn is changed rpt.SQLQueryString shows "from" "SB565655"."XXKEFI" ...

I allways get data from database XXKEFI what is defined in XXYYKE.dsn.
Where is the problem?
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.