[unixODBC-support] Solaris Package

Nick Gorham nick.gorham at easysoft.com
Fri Nov 16 09:40:39 GMT 2007


Iwashita, Hirofumi wrote:

>Hi Experts,
>
>Thank you for your good assistance. This problem solved but new problem
>occurs.
>The isql cannot read the csv file.
>  
>

I just tried it here with the 2.2.13pre code and it seems ok. You should 
be aware that the driver uses the first row to give the column names. So 
this file

col1,col2
aaa,bbb

Gives

+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select * from YYY
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 
aaa                                                                                                                                                                                                                                                            
| 
bbb                                                                                                                                                                                                                                                            
|
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 
col1                                                                                                                                                                                                                                                           
| 
col2                                                                                                                                                                                                                                                           
|
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
SQLRowCount returns 1
1 rows fetched


Reming me of your exact platform and I will try later to see if thats 
the cause.

-- 
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org




More information about the unixODBC-support mailing list