Devart Forums

Hi Devart team,

Is any way to get ODBC DSN information using UniDAC with ODBC Provider?
How can I get
- Name of ODBC driver
- ODBC SQL_SERVER_NAME value
- ODBC SQL_DATABASE_NAME value
- ODBC SQL_USER_NAME value
- ODBC SQL_DBMS_NAME value
- ODBC SQL_DBMS_VER value
used for DSN?

I tried to search in the documentation and forums with no success.

Pavel

Currently you can use UniConnection.ServerVersion and UniConnection.ServerVersionFull properties to get information about the name and version of the database server. We'll consider adding the functionality to TODBCUniProvider for getting such information.

MaximG,

Thank you for the reply.
Can you clarify which ODBC properties are currently used to construct the UniConnection.ServerVersionFull value?

Currently, the value of ServerVersionFull is obtained by concatenating the attributes SQL_DBMS_NAME + ' ' + SQL_DBMS_VER

MaximG,

Thank you for the clarification.
I will extract data needed from the ServerVersionFull for now.