1

When using jconn3.jar to connect to Sybase IQ database, and execute LOAD TABLE ...CLIENT FILE statement in Statement.execute(...) method.

Got error: SQL Anywhere Error -1006140: I/O Error on file c:/aa

But in Sybase's Interactive SQL client, this command run correctly and table data can loaded from c:/aa file successfully.

What's the reason? how to fix this?

Thank you.

Danny Beckett
  • 20,529
  • 24
  • 107
  • 134
whunmr
  • 2,435
  • 2
  • 22
  • 35

1 Answers1

2

Finally came to the solution: use the iAnywhere JDBC driver (but it is not a Type 4 "Pure Java" driver ).

http://www.sybase.com/detail?id=1037304

whunmr
  • 2,435
  • 2
  • 22
  • 35
  • 1
    Whunmr, I ran into the same issue. After reading your post I switched over to the iAnywhere JDBC Driver. I am on Windows so I configured an ODBC Data Source for DBODBC11.dll. In my java project I am using jodbc.jar from SQL Anywhere 11. My connection string is pretty simple. "jdbc:ianywhere:DSN=dw". I can get a connection, but I now get the following error: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'LOAD'. Any Ideas? What exactly did you have to do in order to get this to work? Thanks! – Jon Oct 07 '11 at 00:23
  • Try not to use ODBC data source, Connect to SybaseIQ directly through the iAnywhere JDBC driver. – whunmr Dec 17 '11 at 15:26