Multiple ODBC datasources

[sahja]

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

 

[focwizard]

Sahja,

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 ,$