| Rob Dob 2005-10-30, 8:23 pm |
| I have a MFC VC7.1++ program using VS2003, and also using the MSDE2000 for
some reason my import is now failing and I cannot figure out why, before
today this first statement use to successfully process. The return value of
retcode now is 0, it use to be retcode = 1 I have looked up the
documentation and see confusing information at least to me as to what an
acceptable retcode should be, I even read of a macro SQL_SUCEEDED which
will accept both 1 and 0, but when I use this then it just steps thorugh me
code with no error, yet does NOT import the data into the table I wish.
SQLHENV henv = SQL_NULL_HENV;
HDBC hdbc1 = SQL_NULL_HDBC;
RETCODE retcode;
SDWORD cRows;
// Allocate the ODBC environment and save handle.
retcode = SQLAllocHandle (SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
if ( (retcode != SUCCEED) )
return;
}
Also I am calling retcode = bcp_init(hdbc1, "tempemailholder",
fdlg.GetPathName(),"c:\\BCPERROR.out", DB_IN)
retcode = 0 and no error file "c:\\BCPERROR" is created...
any help would be appreciated...
thanks
|