What is the usual manner to detect if my ODBC connection (based on a DSN) is connected to an instance of SQL Server (including a specific version of SQL Server such as 2005), as opposed to other RDBMSes such as Oracle, DB2, etc? Are we talking SQLGetInfo and SQL_DBMS_NAME, SQL_DBMS_VER? Can this information be obtained prior to the SQLConnect( ), because some ODBC attributes need to be set before the connection is established (eg. MARS, PRESERVE_CURSORS)?
