Change DSN name at runtime using CR 11.5 RDC

[Former Member]

We are trying to change the DSN in a report created using a hardcoded DSN.  At runtime we need to allow the user to select his own DNS and then print a report based on this user selected DSN.  The attached code snippet does not work.  Can you help me figure out how to make this work?

I modeled this code after a VB example found in a book Crystal Reports .Net Programming by Brian Bischof and have implement it in Microsoft C# but also need to make it work in Borland C++ Builder 6.0 which is where the attached code is from.

change_DSN_at_runtime.txt.zip

[former_member183750 · Accepted solution]

Hi David

First, you want to make sure you're on SP 6. See this blog on how to.

Now, it's been a long, long time for me since I looked at RDC and C++ in particular. But here is a doc that may help:

The following is VB, but may also help:

This wiki has links to a few sample apps, unfortunately most of these are VB:

http://wiki.scn.sap.com/wiki/x/WABmBQ

Now rutting around my HD, I found the attaches C++ app from the good ol days and that may be the best resource to have a look at. One you've downloaded the file, unzip it. You will get connectionProperties.txt. Rename that to connectionProperties.zip and extract again. That will get you all the files you need.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter