69,369
社区成员
发帖
与我相关
我的任务
分享
SQLHENV henv = SQL_NULL_HENV;
SQLHDBC hdbc = SQL_NULL_HDBC;
SQLHSTMT hstmt = SQL_NULL_HSTMT;
SQLRETURN retcode;
SQLCHAR Servername[] = "Test";
SQLCHAR Username[] = "sa";
SQLCHAR Password[] = "123465";
SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0);
SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
SQLConnect(hdbc, Servername, SQL_NTS, Username, SQL_NTS, Password, SQL_NTS);
#ifndef _ADO_SQL_H_
#define _ADO_SQL_H_
#ifndef ADO_API
#ifdef __cplusplus
#define ADO_API extern "C" __declspec(dllimport)
#else
#define ADO_API __declspec(dllimport)
#endif
#else
#undef ADO_API
#ifdef __cplusplus
#define ADO_API extern "C" __declspec(dllexport)
#else
#define ADO_API __declspec(dllexport)
#endif
#endif
#ifndef STDCALL
#define STDCALL __stdcall
#endif
#ifndef Bool
#define Bool int
#endif
#ifndef True
#define True 1
#endif
#ifndef False
#define False 0
#endif
struct ADOConn;
#define ADO_FIELD_NAME_LEN 64
#define ADO_FIELD_VALUE_LEN (8 * 1024)
struct ADOFieldInfo
{
char name[ADO_FIELD_NAME_LEN];
char value[ADO_FIELD_VALUE_LEN];
};
typedef void (STDCALL* ADOQueryCallback)(const struct ADOFieldInfo* info, int fieldCount, void* user);
ADO_API Bool STDCALL ADO_Initialize();
ADO_API void STDCALL ADO_Uninitialize();
ADO_API struct ADOConn* STDCALL ADO_CreateConnection(const char* connString);
ADO_API void STDCALL ADO_DestroyConnection(struct ADOConn* conn);
ADO_API Bool STDCALL ADO_Exec(struct ADOConn* conn, const char* sql);
ADO_API void STDCALL ADO_Query(struct ADOConn* conn, const char* sql, ADOQueryCallback cb, void* user);
#endif
SQLHENV henv = SQL_NULL_HENV;
SQLHDBC hdbc = SQL_NULL_HDBC;
SQLHSTMT hstmt = SQL_NULL_HSTMT;
SQLRETURN retcode;
SQLCHAR Servername[] = "Test";
SQLCHAR Username[] = "sa";
SQLCHAR Password[] = "123465";
SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0);
SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
SQLConnect(hdbc, Servername, SQL_NTS, Username, SQL_NTS, Password, SQL_NTS);
[/quote]
问题1,是的。IP是要固定的,或者是接近固定的(用域名,域名后面是集群。)
问题2,自己看吧~那样有意思。