Hi all,

I am trying to write a bulk copy utility through the ODBC interface. So far, I am able to export table information to a data file in native format by using bcp_init and bcp_exec. However, I can't seem to import data from the data file into a table. The failure seems to occur at the first stage, where I specify DB_IN for bcp_init. I am new to ODBC/bcp programming, so any help would be greatly appreciated. Here is the snippet of c++ code that the program doesn't seem to like:

Code:
int TbBulkCopy_import(SQLHANDLE hdbc){
	RETCODE   cliRC = SUCCEED;
	long cRows;	//number of rows bulk processed
	LPCSTR szTable;	//tablename
	LPCSTR szDataFile;	//datafilename
	LPCSTR szFormatFile;	//formatfilename
	INT direction;	//direction of bulkcopy
	int rc = 0;	//for DBC_HANDLE_CHECK to return

	//szTable = "f_sw.doctaba";
	szTable = "f_sw.test_table";
	szDataFile = "doctaba.dat";
	//szFormatFile = "doctaba.fmt";
	/* DB_OUT:	table -> datafile */
	/* DB_IN: datafile -> table */
	direction = DB_IN;

	/* initialize bulk copy */
	cliRC = bcp_init(hdbc,
					szTable,
					szDataFile,
					NULL,
					direction);

	if(cliRC != SUCCEED){
		printf("\nbcp_init(hdbc) Failed\n\n");
		return(9);
	}
...
}
Thanks,
trile