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:
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 vendor-neutral SQL constructs
SQLConnect
..msdn    Add comment     W32 Constants      Translate this page
SQLConnect establishes connections to a driver and a data source.
Code examples:
Obtaining list of tables stored in an ODBC Data Source
Retrieveing general information about the driver and data source associated with an ODBC connection
Establishing connection using the SQLDriverConnect
Testing an ODBC connection for supporting specific functionality
Using vendor-neutral SQL constructs
Declaration:
SQLRETURN SQLConnect(
    SQLHDBC     ConnectionHandle,
    SQLCHAR *   ServerName,
    SQLSMALLINT NameLength1,
    SQLCHAR *   UserName,
    SQLSMALLINT NameLength2,
    SQLCHAR *   Authentication,
    SQLSMALLINT NameLength3);
FoxPro declaration:
DECLARE SHORT SQLConnect IN odbc32 AS SQLConnect32;
    INTEGER ConnectionHandle,;
    STRING  ServerName,;
    INTEGER NameLength1,;
    STRING  UserName,;
    INTEGER NameLength2,;
    STRING  Authentication,;
    INTEGER NameLength3

Parameters:
ConnectionHandle
[Input]
Connection handle.

ServerName
[Input]
Data source name.

NameLength1
[Input]
Length of *ServerName.

UserName
[Input]
User identifier.

NameLength2
[Input]
Length of *UserName.

Authentication
[Input]
Authentication string (typically the password).

NameLength3
[Input]
Length of *Authentication.
Return value:
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.
My comment:
SQLAllocHandle with a HandleType of SQL_HANDLE_DBC is called to allocate a connection.

When the application calls SQLDisconnect to disconnect, the connection is returned to the connection pool and is available for reuse.

I guess I should not explain why this function is declared with an alias.
Word Index links for the SQLConnect :
Translate this page:
  Spanish    Portuguese    German    French    Italian  
FreeTranslation.com offers instant, free translations of text or web pages.
Created: 2002-03-13 19:13:14
Modified: 2002-03-13 19:20:32
Visited in last 7 days: 30
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.38), the Open Source standard SQL database, AceHTML Freeware Version 4, freeware HTML Editor of choice.   Hosted by Korax Online Inc.
Last Topics Visited (54.198.2.110)
13 sec.
Function group: 'Color'
24 sec.
Function group: 'Icon'
36 sec.Function: 'DragFinish'
Function group: 'Shell Functions'
50 sec.Example: 'How to enumerate, add and delete shares on the local computer (WinNT/XP)'
1.03 min.Function: 'CeCreateProcess'
Function group: 'Remote Application Programming (RAPI)'
1.23 min.Example: 'Disconnecting USB Mass Storage Device programmatically'
1.47 min.Function: 'CeSetFilePointer'
Function group: 'Remote Application Programming (RAPI)'
1.9 min.
Function group: 'Time'
2.13 min.Function: 'NetWkstaGetInfo'
Function group: 'Network Management'
2.32 min.Function: 'StrToIntEx'
Function group: 'String'
Google
Advertise here!