Multiple ODBC datasources

sahja · May 22, 2002

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 · May 30, 2002

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

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!

Multiple ODBC datasources

sahja

Technical User

focwizard

Vendor

Similar threads

Part and Inventory Search

Sponsor