Hi,
I want to acces csv files from VC. I have installed a CSV driver http://csvjdbc.sourceforge.net/ into j2ee engine. But when I want to find or browse tables I get an error: "Error -21007 Search for table returned an error. DatabaseMetaData.getTablePrivileges(String,String,String, String[]) unsupported".
Anyone can help me with this problem?
Thanks in advance
Ivo
Hi,
we tried the same a few weeks ago. Except the driver from HXTT no CSV driver was working. I recommend to use the HXTT driver. We use it without any problem.
There is a 30 day trial with 50 request in one session. That means a server restart after 50 requests.
Drivers we tried relique CSV (csvjdbc.sourceforge.net), stels csv and two more.
Here is the website: http://www.hxtt.com
Regards
HXTT has limited usability. so I try jdbc driver you described. and it works fine.
when you configure connection string in your portal, you have to describe as below,
connection URL : jdbc:csv:csvdir?_CSV_Header=true
Driver class path: org.relique.jdbc.csv.CsvDriver
then you will suceed.
Add a comment