Print Page | Close Window

Change DSN has no effects Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2022 Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13155 Printed Date: 23 Apr 2025 at 1:09pm Topic: Change DSN has no effects Posted By: pskossu Subject: Change DSN has no effects Date 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?

Print Page | Close Window