connection with Free-hand sql

[naga5566]

Hi all,
Appreciate if any body could help me.
I have a report based on FRee hand sql.
Its working fine.i published it to Corp docs.
When it is run by other user on other machine by retreiving from corp docs,it gives connection error.My question is when i publish my report does nt the connection export to repository or corp docs.
Please help me out.
Thanks
Naga

 

[skrandel]

Freehand SQL reports only use Shared or Personal connections. Those connections are stored on your desktop in the PDAC.lsi (Personal Data Access Connections) and SDAC.lsi (Shared Data Access Connections) files.

So, the answer is no, the connections are not stored with the report.

You could build a report using a universe. Then you could change the SQL to use your Free-hand SQL. You are basically fooling the report to use your SQL instead of the universe generated code.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[naga5566]

I think Steve ,you did not get m y point.
I have a report which uses FreeHand Sql.I published it to Infoview.My question is when other users want to run that report on their machines,it raises connection err0r.So do i need to create a ODBC connectuion on every machine which runs my report ?This has nothing to do with the universe.
Thanks
Naga

 

[nimmy99]

Yes You have to.

 

[Sridharan]

Naga,

If you want to avoid such errors in future and also to cut down on maintenance I would suggest you to implement Steve's Idea of using an Universe and change the SQL to use yours.

Regards,
Sri