Joined: 09 May 2011
Location: Finland
Online Status: Offline
Posts: 1
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?
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