Using Win32 functions in Visual FoxPro Image Gallery
functions  • examples  • solutions  • updates  • about •  links   • articles  •  login •
ODBC API
..msdn
SQLAllocEnv
SQLAllocHandle
SQLBindCol
SQLBrowseConnect
SQLConfigDataSource
SQLConnect
SQLCreateDataSource
SQLDataSources
SQLDisconnect
SQLDriverConnect
SQLDrivers
SQLExecDirect
SQLFetch
SQLFreeEnv
SQLFreeHandle
SQLGetConfigMode
SQLGetConnectAttr
SQLGetDiagRec
SQLGetEnvAttr
SQLGetFunctions
SQLGetInfo
SQLGetInstalledDrivers
SQLGetPrivateProfileString
SQLInstallerError
SQLManageDataSources
SQLNativeSql
SQLRowCount
SQLSetConfigMode
SQLSetEnvAttr
SQLTables
Code examples:
Enumerating ODBC Data Sources available on the local computer
Enumerating ODBC Data Sources available on the local computer

User rating: 0/10 (0 votes)
Rate this code sample:
  • ~
More code examples    Listed functions    Add comment     W32 Constants      Translate this page Printer friendly version of this code sample
Versions:
click to open
Before you begin:
The code shows how to use SQLDataSources function to retrieve lists of available Data Sources (either System or User DSNs).

You may be interested in similar example:
  • How to retrieve list of system DSNs (Data Source Name) with parameters

    •  
      Members area. Log in to view this example.
     
      User name:
      Password:
     
     
      Forgot your password?
    		 
      Sign up for
    the Membership
     
     


    User rating: 0/10 (0 votes)
    Rate this code sample:
    • ~
    		3729 bytes  
    Created: 2002-03-05 11:55:05  
    Modified: 2011-12-10 09:20:22  
    Visits in 7 days: 155  
    Listed functions:
    SQLAllocEnv
    SQLAllocHandle
    SQLDataSources
    SQLFreeEnv
    SQLFreeHandle
    SQLGetEnvAttr
    SQLSetEnvAttr
    		Printer friendly API declarations
    My comment:
    Variable mDirection defines whether System, User or both DSNs will be retrieved depending on value assigned:
  • SQL_FETCH_FIRST_SYSTEM
  • SQL_FETCH_FIRST_USER
  • SQL_FETCH_FIRST
    • Word Index links for this example:
    local computer
    enumerating
    data source
    DSN
    Data Source Name
    ODBC Data Source
    ODBC Data Sources
    System DSN
    User DSN
    Translate this page:
      Spanish    Portuguese    German    French    Italian  
    FreeTranslation.com offers instant, free translations of text or web pages.
    User Contributed Notes:
    There are no notes on this subject.

    Log in to post a comment

    functions  • examples  • solutions  • updates  • about •  links   • articles  •  login •
    Copyright © 2001-2013 News2News, Inc. Before reproducing or distributing any data from this site please ask for an approval from its owner. Unless otherwise specified, this page is for your personal and non-commercial use. The information on this page is presented AS IS, meaning that you may use it at your own risk. Microsoft Visual FoxPro and Windows are trade marks of Microsoft Corp. All other trademarks are the property of their respective owners. 

    Privacy policy
    Credits: PHP (4.4.9), an HTML-embedded scripting language, MySQL (5.1.55-log), the Open Source standard SQL database, AceHTML Freeware Version 4, freeware HTML Editor of choice.   Hosted by Korax Online Inc.
    Last Topics Visited (54.234.42.16)
    3 sec.Example: 'How to make a VFP form fading out when released (GDI+ version)'
    Language: 'Visual FoxPro'
    6.42 hrs.
    Function group: 'GDI+ Bitmap'
    9.98 hrs.Example: 'Enumerating Processes -- WinNT'
    13.4 hrs.Example: 'Browsing Windows Known Folders (Special Folders)'
     Function: 'WinHttpOpen'
    14.89 hrs.Function: 'WTSEnumerateSessions'
     Function: 'GdipCreateBitmapFromHICON'
    23.28 hrs.Function: 'LoadResource'
     Example: 'Using GetNearestColor'
    1 day(s)Example: 'Printing text on the client area of the main VFP window'
    Google
    		Advertise here!