Currently have an assignment to use stored procedures to retrieve pre-calculated data from the Database. I have created the local connection to the database, I have rights from supervisor to call stored procedures, and I'm getting the desired result sets for the assignment, however I'm looking to see on how to do an InfoView deployment. I understand that InfoView only runs secure connections, and with Freehand SQL (That is how I call and pass parameters to the stored procedure) uses a local shared connection. If there is anyone that has done a successful deployment please advise.
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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Deployment of Stored Procedures for BO
- Thread starter webi2002
- Start date
Sure. Local connection info is stored in the PDAC and SDAC files in your LocData directory.
Just copy those files to the same location on the WebI server. Steve Krandel
BASE Consulting Group
Just copy those files to the same location on the WebI server. Steve Krandel
BASE Consulting Group
- Thread starter
- #3
Point taken, and as an added bonus, once the locdata files are passed to each WebI server, does this mean that Zabo users will be able to refresh the reports from their machines? or would we have to pass the same files to those users?
Thanks.
Thanks.
- Thread starter
- #4
Not sure. The solution I gave you is for Windows. Steve Krandel
BASE Consulting Group
BASE Consulting Group
ZABO cannot be used to refresh Freehand SQL or Stored Procedures. Steve Krandel
BASE Consulting Group
BASE Consulting Group
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip