|
|||||
|
|
|||||
| function | SQLAllocConnect | ||||
| Sample Code | Related Syntax | Other Library Functions |
|
Library: ODBC
Include: omodbc.xin |
Returns: Numeric
An SQL return code. The following values may be returned:
|
define external counter function SQLAllocConnect
( read-only SQL_handle_type EnvironmentHandle,
read-only SQL_handle_type ConnectionHandle )
Allocates an SQL connection handle within the environment identified by EnvironmentHandle. This function has been superseded by SQLAllocHandle in ODBC 3.0.
Input arguments:
The following code demonstrates how to use SQLAllocConnect to allocate a connection handle within the identified environment.
local SQL_Handle_type EnvironmentHandle
local SQL_Handle_type ConnectionHandle
local SQL_Vector_type Vector
local counter CounterSizeInBytes initial {4}
local counter RetCode
set RetCode to SQLAllocHandle
( SQL_HANDLE_ENV, SQL_NULL_HANDLE, EnvironmentHandle )
output "Allocating environment handle - "
do when RetCode != SQL_SUCCESS
output "failed%n"
halt with 1
else
output "passed%n"
done
SQLSetVectorSize( Vector, CounterSizeInBytes )
SQLSetVectorAsCounter( Vector, SQL_OV_ODBC2 )
set RetCode to SQLSetEnvAttr
( EnvironmentHandle,
SQL_ATTR_ODBC_VERSION,
Vector,
CounterSizeInBytes,
SQL_INTEGER )
output "Setting environment attribute - "
do when RetCode != SQL_SUCCESS
output "failed%n"
halt with 1
else
output "passed%n"
done
set RetCode to SQLAllocConnect(EnvironmentHandle, ConnectionHandle)
output "Allocating connection handle - "
do when RetCode != SQL_SUCCESS
output "failed%n"
halt with 1
else
output "passed%n"
done
set RetCode to SQLFreeConnect(ConnectionHandle)
output "Freeing connection handle resources - "
do when RetCode != SQL_SUCCESS
output "failed%n"
halt with 1
else
output "passed%n"
done
set RetCode to SQLFreeEnv(EnvironmentHandle)
output "Freeing environment handle resources - "
do when RetCode != SQL_SUCCESS
output "failed%n"
halt with 1
else
output "passed%n"
done
| ---- |
