#496 [ODBC][OLEDB] Cannot export CUBRID data to SQL Server db with various data type

[Jira Trac]

We have tried to export from CUBRID data to SQL Server by use either trsact-sql queries or SQL Export Data Wizard, it failed for some cases

1) ODBC (using openrowset function):
*Case 1:
test_int (id INT, col_1 INT)
{noformat}
select * from openrowset('MSDASQL',
'driver={CUBRID Driver};server=10.34.64.57;uid=dba;pwd=;db_name=odbc_test;port=33037;fetch_size=100','select * from test_int') as a
{noformat}
Result: retrieve the data successfully

*Case2:
test_varchar (id INT, col_1 VARCHAR)
{noformat}
select * from openrowset('MSDASQL',
'driver={CUBRID Driver};server=10.34.64.57;uid=dba;pwd=;db_name=odbc_test;port=33037;fetch_size=100','select * from test_varchar ') as a
{noformat}
Result: {color:red} Cannot get the current row value of column [MSDASQL].description from OLE DB provider MSDASQL for linked server (null). {color}

2) OLEDB Provider (using SQL Import Export Tool):

test_int (col3 TIME, col8 BIGINT, col13 BIT VARYING, col15 VARCHAR, col17 NCHAR VARYING)
!apis544.JPG!

Summary: The problem may occur when export Cubrid data to SQL Server db in serveral data type, such as VARCHAR, TIME etc.