jdbc:ODBC error: Column not found

Classic Servoy
1

I get an SQL error message when creating a new form and selecting any of the tables on my SQL Anywhere 9 local server. I’m using an ODBC connection, and have turned off “driver not capable” errors. I can however create a new table on that server using the repository. The error text is

java.sql.SQLException: Column not found
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Column not found Column not found

2

problem solved, I was using Sun’s jdbc:odbc bridge, used ianywhere.ml.jdbcodbc.IDriver instead and it worked fine.