初学数据库,SQLConnect调用总是出错,查了一下发现一个跟我类似情况的
文章链接:http://bbs.csdn.net/topics/390017214,但是题主也没说解决了没有,我按照评论里说的做了可是还是出错。数据源也配置且测试成功,数据库用的oracle12g。
代码如下:
#include<stdlib.h>
#include<stdio.h>
#include<windows.h>
#include<sql.h>
#include<sqlext.h>
#include<Sqltypes.h>
//using System.Data.Sqlclient
/*#include<odbcinst.h >
#include <odbcss.h>
#pragma comment(lib,"odbc32.lib")*/
#define SNO_LEN 30
#define NAME_LEN 50
#define DEPART_LEN 100
#define SGENDER_LEN 5
int main(){
SQLHENV oraclehenv;
SQLHDBC oraclehdbc;
SQLHSTMT oraclehstmt;
SQLRETURN ret;
SQLCHAR sName[NAME_LEN], sDepart[DEPART_LEN], sGender[SGENDER_LEN], sSno[SNO_LEN];
//SQLCHAR oracleName[] = "Oracle", stmt[] = "INSERT INTO STUDENT (SNO,SNAME,SSEX,SAGE,SDEPT)VALUES(?,?,?,?,?)";
SQLINTEGER sAge;
SQLINTEGER cbAge = 0, cbSno = SQL_NTS, cbGender = SQL_NTS, cbName = SQL_NTS, cbDepart = SQL_NTS;
/*初始化环境*/
ret = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &oraclehenv);
ret = SQLSetEnvAttr(oraclehenv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
/*建立连接*/
ret = SQLAllocHandle(SQL_HANDLE_DBC, oraclehenv, &oraclehdbc);
ret = SQLConnect(oraclehdbc, (SQLCHAR*)"Oracle", SQL_NTS, (SQLCHAR*)"c##admin", SQL_NTS, (SQLCHAR*)"admin", SQL_NTS);
if (!SQL_SUCCEEDED(ret))
{
printf("数据库连接失败!\n");
system("pause");
return -1;
}
/*初始化语句句柄*/
ret = SQLAllocHandle(SQL_HANDLE_STMT, oraclehdbc, &oraclehstmt);
ret = SQLExecDirect(oraclehstmt, (SQLCHAR*)"SELCET * FROM STUDENT", SQL_NTS);
if (ret==SQL_SUCCESS||ret==SQL_SUCCESS_WITH_INFO)
{
ret = SQLBindCol(oraclehstmt, 1, SQL_C_CHAR, sSno, SNO_LEN, &cbSno);
ret = SQLBindCol(oraclehstmt, 2, SQL_C_CHAR, sName, NAME_LEN, &cbName);
ret = SQLBindCol(oraclehstmt, 3, SQL_C_CHAR, sGender, SGENDER_LEN, &cbGender);
ret = SQLBindCol(oraclehstmt, 4, SQL_C_LONG, &sAge, 0, &cbAge);
ret = SQLBindCol(oraclehstmt, 5, SQL_C_CHAR, sDepart, DEPART_LEN, &cbDepart);
//printf("%s,%s,%s,%d,%s\n", cbSno, cbName, cbGender, cbAge, cbDepart);
}
while ((ret = SQLFetch(oraclehstmt)) != SQL_NO_DATA_FOUND)
{
if (ret == SQL_ERROR)
printf("Fetch error\n");
else
printf("%s,%s,%s,%d,%s\n", cbSno, cbName, cbGender, cbAge, cbDepart);
}
SQLFreeHandle(SQL_HANDLE_STMT, oraclehstmt);
SQLDisconnect(oraclehdbc);
SQLFreeHandle(SQL_HANDLE_DBC, oraclehdbc);
SQLFreeHandle(SQL_HANDLE_STMT, oraclehenv);
system("pause");
return 0;
}