Get count of datasource and their types

[kulkarni]

Am working on application using sdk program that fetches count of datasources on a server and the count of different types of datasources like - ODBC, MS Sql Server, Oracle, DB2, Poewrplay Cube etc

I am able to get the datasource count but not able to figure how to get types of datasource.  Not sure what propenum I need to be using to get this.

Any one knows how to fetch this information (datasource type)?  Thank you.

[lindero]

hi,

first of all you need the datasource connection object. The datascource does not know which kind of datasource type it is. Maybe this helps.

regards

[kulkarni]

I am using this in my searchpath - //dataSource/*

This fetches all the datasource connection under all the datasources.  I am able to get the connection string.  Please see the attachment.  It is from my debugging mode in .Net

There are 2 distinct screenshots in the attachment.  Each of them show various property associated with the datasource Connection.  None of them tells us the datasource type!

Thanks.

[kulkarni]

I am unable to attach the jpeg file!