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:
Using SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server)
SQLBrowseConnect
..msdn    Add comment     W32 Constants      Translate this page
SQLBrowseConnect supports an iterative method of discovering and enumerating the attributes and attribute values required to connect to a data source. Each call to SQLBrowseConnect returns successive levels of attributes and attribute values.
Code examples:
Using SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server)
Declaration:
SQLRETURN SQLBrowseConnect(
    SQLHDBC       ConnectionHandle,
    SQLCHAR *     InConnectionString,
    SQLSMALLINT   StringLength1,
    SQLCHAR *     OutConnectionString,
    SQLSMALLINT   BufferLength,
    SQLSMALLINT * StringLength2Ptr);
FoxPro declaration:
DECLARE SHORT SQLBrowseConnect IN odbc32;
    INTEGER   ConnectionHandle,;
    STRING    InConnectionString,;
    INTEGER   StringLength1,;
    STRING  @ OutConnectionString,;
    INTEGER   BufferLength,;
    INTEGER @ StringLength2Ptr
Parameters:
ConnectionHandle
[Input]
Connection handle.

InConnectionString
[Input]
Browse request connection string (see "InConnectionString Argument" in "Comments").

StringLength1
[Input]
Length of *InConnectionString.

OutConnectionString
[Output]
Pointer to a buffer in which to return the browse result connection string.

BufferLength
[Input]
Length of the *OutConnectionString buffer.

StringLength2Ptr
[Output]
The total number of bytes available to return in *OutConnectionString.
Return value:
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NEED_DATA, SQL_ERROR, or SQL_INVALID_HANDLE.
My comment:
SQLBrowseConnect requires an allocated connection. The driver may establish a connection with the data source during the browsing process.

On each call to SQLBrowseConnect, the application specifies the connection attribute values in the browse request connection string. The driver returns successive levels of attributes and attribute values in the browse result connection string; it returns SQL_NEED_DATA (99) as long as there are connection attributes that have not yet been enumerated in the browse request connection string.
Word Index links for the SQLBrowseConnect :
Translate this page:
  Spanish    Portuguese    German    French    Italian  
FreeTranslation.com offers instant, free translations of text or web pages.
Created: 2002-03-20 21:33:53
Modified: 2002-03-20 21:39:32
Visited in last 7 days: 18
User Contributed Notes:
There are no notes on this subject.


Copyright 2001-2017 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.6.37), the Open Source standard SQL database, AceHTML Freeware Version 4, freeware HTML Editor of choice.   Hosted by Korax Online Inc.
Last Topics Visited (54.166.199.178)
10 sec.Function: 'GdipTranslateMatrix'
21 sec.Function: 'SetFileTime'
32 sec.Function: 'SetThreadPriority'
42 sec.Function: 'NetScheduleJobAdd'
54 sec.Function: 'ToAscii'
1.1 min.Function: 'DrawFrameControl'
1.27 min.
Function group: 'Shell Lightweight Utility APIs -- string functions'
1.45 min.Function: 'CreateDC'
1.65 min.Function: 'EnumForms'
1.88 min.Function: 'GetPrintProcessorDirectory'
Google
Advertise here!