Multiple ODBC datasources
Multiple ODBC datasources
(OP)
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
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
RE: Multiple ODBC datasources
Here's some info from the documentation CD:
You can define multiple SQL SQLODBC SET USER commands in the EDA Server profile in order to access multiple ODBC data sources. For example,
SQL SQLODBC SET USER sourcename1/userid1,password1
SQL SQLODBC SET USER sourcename2/userid2,password2
When multiple ODBC data sources are accessed simultaneously, the EDA Metadata Access File, which indicates where the ODBC data source is, must contain the SERVER= parameter. For example,
SEGNAME = EXCLFILE, TABLENAME = C:\ODBCDATA\EDA.EDATABLE,SERVER = sourcename, KEYS = 0 ,$