Using Win32 functions in Visual FoxPro Image Gallery
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 drivers available on the local computer
Establishing connection using the SQLDriverConnect
Obtaining list of tables stored in an ODBC Data Source
Retrieveing general information about the driver and data source associated with an ODBC connection
Testing an ODBC connection for supporting specific functionality
Using SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server)
Using vendor-neutral SQL constructs
Using SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server)

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
Before you begin:
Actually this code presents just a first step. Hopefully I will add more lines to it soon.
 
  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:
  • ~
1378 bytes  
Created: 2002-03-20 21:17:09  
Modified: 2011-12-10 09:20:22  
Visits in 7 days: 31  
Listed functions:
SQLAllocEnv
SQLAllocHandle
SQLBrowseConnect
SQLFreeEnv
SQLFreeHandle
Printer friendly API declarations
My comment:
Not all ODBC drivers support this functionality: SQL Server, Oracle, you name more.
Unsupported by ODBC drivers for MS Access, Visual FoxPro, MySQL.

Typical return from this function:
SERVER:Server={Server1,Server2,Server3};UID:Login ID=?;PWD:Password=?;*APP:AppName=?;*WSID:WorkStation ID=?
Word Index links for this example:
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.


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 (107.22.25.119)
3 sec.Example: 'Changing pitch and speed of a wave file'
13.62 min.Function: 'SHQueryRecycleBin'
Function group: 'Shell Functions'
13.7 min.Example: 'Adding user-defined items to the Control Menu of VFP form (requires VFP9)'
53.15 min.Example: 'Displaying standard progress dialog box when copying files'
53.2 min.Function: 'OpenClipboard'
1.87 hrs.Example: 'Retrieving file information for the VFP executable running'
2.4 hrs.Function: 'GetProfileString'
 Example: 'GDI+: sending image of FoxPro form to printer'
 Function: 'GetWindowTextLength'
3.51 hrs.Example: 'Placing a button on the VFP form as a new child window'
Google
Advertise here!