odbc and bcp

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