Liveware Publishing Support Forum

In a report using a single MSSQL7 ODBC datasource I need to__ add another datasource to access other tables, my data source/__database dropdown box in the joins window is empty, I can see__the tables in the original but can not add an extra datasource/__database.__I have been doing this for years in Arpeggio 2 and am worried it__may be a limitation of version 9 RRSQL.____I have also had problems with the report viewer causing a Dr watson if you cancel out or just plain finish with it.____Am on WIN2000 SVPK 1 And deliver reports to many WKstations__of all windows types.____Any Ideas__

Version 9 does have some restrictions using SQL Server.____The README states:__SQL Server7/2000__·Auto SQL reports are limited to selecting tables from the current login database.__·If you need to join tables across databases, you can create a User SQL report or can within you database build a View table that references tables from a different database.__·If you are opening reports that were created against earlier versions of SQL Server, you may incorrectly receive the error _Data source not found and no default specified_. To resolve this problem, edit your c:windowsRSW.INI file and add the line:__UseQEConnect=1__to the [Database] section. You will need to add a [Database] section if it is not already present in the file. Then save the file and restart R&R.__·Data from Unicode field types (nchar, nvarchar, ntext) will appear as empty when the report is executed. Support for these field types will be added in subsequent update.__-----------------------------------------------____Kathleen__R&R Support