Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using DSN as data source 1

Status
Not open for further replies.

2969

IS-IT--Management
Oct 18, 2001
107
US
hi
i have this crystal rpt which uses a DSN connection but if i change the path of the DSN by going thru control panel, the crystal rpt still shows the old path in the set location. How can i change the path, i have tried refreshing, shutting down the computer, verify the database etc..

thx
 
i have tried using the set location also but the DSN still shows connected to the old path. I found out a workaround by making another connection with a different name but pointing to the new location. But the short coming is that everytie ihave to change datasource, i have to make a new DSN.

thx
 
Change the DSN, then do a set location, this will repoint the report to the correct datasource. It must be in that order.

If you believe that the DSN is not changing, verify this by pointing at something completely different. I've never had the set location NOT work, so this is a unique situation for me.

-k kai@informeddatadecisions.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top