Hi,

 

I am having an issue trying to connect to two internal SQL databases with a single database_connection_params.conf file and a single database_sql_queries.xml file.  Since the "dbname" field in the query specifies the Zoho Reports database, how do you tell the query which internal database to use?  I am wondering if I need to use the $id$ tag to associate query to internal database, but if so I am unsure of the format.

 

I have a workaround which is to replicate the entire ZohoReports folder once for each database I connect to, but that doesn't seem like the best way to accomplish this.

 

database_connection_params.conf

# $Id$
DBTYPE=sqlserver
HOSTNAME=Server

PORT=1433
USERNAME=user
PASSWORD=password

DBNAME=SalesDB
MDBFILENAME=
SQLITEFILENAME=

 

DBTYPE=sqlserver
HOSTNAME=Server

 

 

database_sql_queries.xml

<!-- $Id$ -->

<Queries>
   
      <Query dbname="DB1_Name_in_Zoho_Reports" tablename="TableA" importtype="UPDATEADD" matchingcols="ColumnA" selectcols="" skiptop="">

      SELECT Company FROM SalesList

   </Query>

      SELECT Company FROM SalesList

      </Query>

</Queries>

 

Thank you.