No Connection with RDC and mutiple Databases

[HowyD]

Hallo all there,

I'm implementing an App using VB6 and CR 8.5 (with RDC). In this app there is the need to get Data form different Databases.
No I've created a Report getting the Data nativly from 4 Access2000- and SQL7-Tables. To avoid installing additional SQL-Server-Software on the Clients I switched the SQL-Table to SQL-OleDB Provider. Now I get the error Message "No supported" by the ReportViewer.
Here is the Code-Snippet to connect to the Server:

Call crdLocation.Database.Tables(3).SetLogOnInfo(strServer, strDbName, strUserId, strPwd)
crdLocation.Database.Tables(3).Location = strDbName & ".dbo.tabItem"[code][/color]

What went wrong or is there something more to do???

 

[HowyD]

Hey there,

I recently made some tries and I found that connecting native to Access and SQL7 in the same RDC-Report with linking this tables works fine.
So now I wanted to use OleDB-Providers to do this. What I found is that the first DB(-Table) (regardless if it's SQL7 or Access) will be opened - any other not.

Where is the problem - what's to do?

Needing urgently help!!!!