Changing ODBC Source at runtime

[CTLreports]

Is it possible to change the data source at runtime through code?

Ryan Boyd
CTL Reporting
Bentonville, AR
ryan.boyd@ctlusa.net
p4 2Ghz, 512 MB RAM, Crystal Reports Professional 8.5

 

[LV]

Yes it's possible. Here is a couple links to Seagate KB articles (depending on what application you call the report from):

http://support.crystaldecisions.com/library/kbase/articles/c2008324.asp

http://support.crystaldecisions.com/library/kbase/articles/c2007576.asp

Or just go to

http://support.crystaldecisions.com/library/kbase.asp

and enter keyword SetLogOnInfo.

There is also sample code at

http://support.crystaldecisions.com/updates/

 

[oguraja]

Can you tell me how we can change the datsource ie Dsn at runtime using delphi 6 and Crystal report 8.5.

From these links i can find the solution for vb.

-Raja

 

[LV]

Never worked with Delphi, sorry.

 

[CTLreports]

I run the crystal report through a program called LIMS and LIMS changes the data source to an earlier version of an INFORMIX driver... I don't know what ASP is or run anything with Visual Basic. Is there a way WITHIN crystal to change the ODBC Driver on the fly or at runtime??