Hi I am fairly new to using WebFocus and have written a report that requires accessing two different ODBC datasources. One is a MS Access database the other is a database on a data warehouse. I first access the MS Access database and create a hold file then have to access the data warehouse join the holdfile and a file from the warehouse and run a report. The procedure runs until it tries to access the warehouse and I get a message saying I am not logon to the warehouse. Ho do I logoff from the first ODBC data source and logon to the second one within the procedue so I don't have to do it manually??? Thanks
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.