Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

How To Retrieving a List of All ODBC Data Sources


View products that this article applies to.

This article was previously published under Q119064

↑ Back to the top


Summary

The Open Database Connectivity (ODBC) API contains a function called SQLDataSources() which can be used to retrieve information about data sources which are available to an application. Below is a sample function which fills a CStringList with the names of all available ODBC data sources.

Sample Code

   #include <afxcoll.h>    //Needed for CStringList MFC class.
   #include "odbcinst.h"
   #include "sql.h"
   #include "sqlext.h"

   // NOTE: in 16-bit Visual C++ link with odbcinst.lib
   //       in 32-bit Visual C++ 2.x link with odbccp32.lib
   //       in 32-bit Visual C++ 4.x no need to change link options

   #define MAX_DSN_LENGTH 30
   #define MAX_DSN_DESC_LENGTH 300

   BOOL GetODBCDataSourceNames(CStringList * pList)
   {
       HENV hEnv;
       char szDSN[MAX_DSN_LENGTH];
       SWORD cbDSN;
       UCHAR szDescription[MAX_DSN_DESC_LENGTH];
       SWORD cbDescription;
       RETCODE retcode;

       ASSERT(pList->IsEmpty());
       if (SQLAllocEnv(&hEnv)!=SQL_SUCCESS)
           return FALSE;

       while (retcode=SQLDataSources(hEnv, SQL_FETCH_NEXT,
                    (UCHAR FAR *) &szDSN, MAX_DSN_LENGTH, &cbDSN,
                    (UCHAR FAR *) &szDescription,MAX_DSN_DESC_LENGTH,
                     &cbDescription) != SQL_NO_DATA_FOUND
                    &&retcode!=SQL_ERROR)

          {
               pList->AddTail(szDSN);
          }

       SQLFreeEnv(hEnv);
       if (retcode==SQL_ERROR)
         return FALSE;

       return TRUE;
   }
				

↑ Back to the top


Keywords: kbprogramming, kbcode, kbdatabase, kbhowto, KB119064

↑ Back to the top

Article Info
Article ID : 119064
Revision : 5
Created on : 11/21/2006
Published on : 11/21/2006
Exists online : False
Views : 529