Importing Subreports with different Database Names not working

[mgreer]

I'm trying to import several subreports into a main report. I woule like each subreport connects to a different database. Even though I set the logon info correctly the subreports all show data from the first subreport imported. For example:

session("oRpt&quot.Sections.Item("RH&quot.ImportSubreport "C:\Inetpub\

http://wwwroot\VolumeRpt\Reports\client1.rpt",

0, 0
'Now open the subreport. "client" is the name of the subreport.
Set CRSubreport = session("oRpt&quot.OpenSubreport("client1.rpt&quot
' Each table must use SetLogonInfo to logon.
' And logon to the datasource
set crtablesub = CRSubreport.Database.Tables.Item(1)
crtablesub.SetLogonInfo <servername1>, <databaseName1>, <username>, <password>


Session(&quot;oRpt&quot.Sections.Item(&quot;PH&quot.ImportSubreport &quot;C:\Inetpub\

http://wwwroot\VolumeRpt\Reports\client2.rpt&quot;,

0, 0
'Now open the subreport. &quot;client&quot; is the name of the subreport.
Set CRSubreport2 = session(&quot;oRpt&quot.OpenSubreport(&quot;client2.rpt&quot
' Each table must use SetLogonInfo to logon.
' And logon to the datasource
set crtablesub2 = CRSubreport2.Database.Tables.Item(1)
crtablesub2.SetLogonInfo <serverName1>, <databaseName2>, <username>, <password>


When I view the report the second subreport has info from databaseName1 instead of databaseName2? How do I get it to display data from a different database?

NOTE: When I change the second subreport ServerName to a different Server the report works. Each subreport pulls data from the correct db. This only fails when trying to access several databases on the same server.

Any ideas?