Can I query an RDC object for DBMS name?

[tpeters1]

I want to interogate the RDC object for the report database type. In other words, I want to know if the report was created with tables stored in Oracle, SQL Server, or Access, etc. Is there a convenient property containing that information? If not, how may I obtain it inconveniently?

I did find some old code that uses a CRAXDRT table property named "DecriptiveName". The mispelling is intentional. I can't seem to find the equivilent CR10 property.

VB6 and CR10.

 

[vidru]

DecriptiveName is still available to you in CR10, it's just hidden. I don't think it will give you exactly what you're looking for anyway.

The same can also be done like this:
Report.Database.Tables(1).ConnectionProperties("PreQEServerType")

I don't know of any property that stores the specific type of database.

-dave

 

[tpeters1]

I tried this:

myReport.Database.Tables(1).ConnectionProperties("PreQEServerType")

and this:
myReportTable.PreQEServertype

both throw errors.

 

[Turkbear]

Hi,
What are the errors?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[tpeters1]

myReport.Database.Tables(1).ConnectionProperties("PreQEServerType")
throws subscript out of range error

myReportTable.PreQEServertype
throws method or data member not found

 

[vidru]

My guess is that PreQEServerType must only exist if the report was originally created in a version prior to CR 9.

-dave