ODBC data base with the VC++

[gnanapoongothai]

i Am programming to establish connectivity to Mysql server and when setting the attribute to the environment handle the error is invalid valueptr to the attribute.
And also the connection handle is not allocated in version 3.I need help from u ppl.

and also say the sequence , i am totall confused with MSDN.
and here is my code

ret = SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&envr);
 
 
 if(ret == SQL_SUCCESS  || ret == SQL_SUCCESS_WITH_INFO)
 {
 ret = SQLAllocHandle(SQL_HANDLE_DBC,envr,&hdbc);
 }
 
//if(ret == SQL_SUCCESS  || ret == SQL_SUCCESS_WITH_INFO)
 {
     ret = SQLSetEnvAttr(envr,SQL_ATTR_ODBC_VERSION,prt,20);
 }
  ret = SQLGetDiagRec(SQL_HANDLE_ENV,envr,1,sqlstate,&nativeerror,msg,100,&msglen);
 
 //if(ret == SQL_SUCCESS  || ret == SQL_SUCCESS_WITH_INFO)
{
    ret = SQLSetConnectAttr(&hdbc,SQL_ATTR_LOGIN_TIMEOUT,0,0);
}
 ret = SQLGetDiagRec(SQL_HANDLE_DBC,&hdbc,1,sqlstate,&nativeerror,msg,100,&msglen);
 
 
//if(ret == SQL_SUCCESS  || ret == SQL_SUCCESS_WITH_INFO)
{
    ret = SQLConnect(hdbc,(SQLCHAR*)"pmu",SQL_NTS,(SQLCHAR*)"root",SQL_NTS,(SQLCHAR*)"root",SQL_NTS);
}
 ret = SQLGetDiagRec(SQL_HANDLE_DBC,&hdbc,1,sqlstate,&nativeerror,msg,100,&msglen);
 
 
 
 if(ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO)
 {
 ret = SQLAllocHandle(SQL_HANDLE_STMT,hdbc,&hline);
 }
 if(ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO)
 {
     ret = SQLSetStmtAttr(hline,SQL_ATTR_ROW_BIND_TYPE,sizeof(Ia12),0);
     ret = SQLSetStmtAttr(hline,SQL_ATTR_ROW_ARRAY_SIZE,10,0);

[sicarie]

gnanapoongothai-

You are a member of this community, and as such, are expected to follow the Posting Guidelines in such things as using code tags. Thanks.