![]() ![]() The user might not have select privileges on one or more tables returned by the SQLTables() function. SQL_ACCESSIBLE_TABLES: Indicates if the user has SELECT privileges on all table names returned by SQLTables(). Some procedures executed by the SQLProcedures() function might be executed by the application. SQL_ACCESSIBLE_PROCEDURES: Indicates if procedures returned by SQLProcedures() can be executed by the application. The following table lists the information returned by EDB-ODBC about the EDB Postgres Advanced Server connection.ĮDB_ODBC/EDB Postgres Advanced Server returns SQLGetInfo() returns SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE. SQLGetInfo() writes information in one of the following formats: ![]() If the returned value is a fixed size, string_length is ignored, and the size of the requested value isn't provided by SQLGetInfo(). If the size of the returned value exceeds buffer_len, the information is truncated and NULL terminated. The first call retrieves the number of bytes required to hold the value. SQLGetInfo() writes the size of the requested value in this integer.Ī typical usage is to call SQLGetInfo() with a NULL info_pointer to obtain the length of the requested value, allocate the required number of bytes, and then call SQLGetInfo() again (providing the address of the newly allocated buffer) to obtain the actual value. String_length_pointer - A pointer to an SQLSMALLINT value. buffer_len is used only if the requested value is returned in the form of a character string. If the returned value is a fixed size, buffer_len is ignored. If info_pointer is NULL, buffer_len is ignored. ![]() If the info_type argument is SQL_DRIVER_HDESC or SQL_DRIVER_HSTMT, the info_pointer argument is both Input and Output.īuffer_len - The length of the allocated memory buffer pointed to by info_pointer. Info_pointer - A pointer to a memory buffer to hold the retrieved value. Info_type - The type of information SQLGetInfo() is retrieving. SQLSMALLINT * string_length_pointer // Output ) You must have an open connection to call SQLGetInfo(), unless you specify SQL_ODBC_VER as the info_type. The ODBC SQLGetInfo() function returns information about the EDB-ODBC driver and EDB Postgres Advanced Server. Use the SQLSetStmtAttr() function to set statement attributes.Use the SQLSetEnvAttr() function to set environment attributes.Use the SQLSetConnectAttr() function to set connection attributes.You can also use ODBC functions to set attributes of the objects that you use to interface with ODBC: SQLGetStmtAttr() returns information about the attributes specific to an individual statement.SQLGetConnectAttr() returns information about attributes specific to an individual connection.SQLGetEnvAttr() returns information about ODBC environment attributes.SQLGetInfo() returns information about the EDB-ODBC driver and EDB Postgres Advanced Server.You can use ODBC functions to query ODBC for specific information about the various attributes of the connection between EDB-ODBC and the server. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |