Hi,
The sun.jdbc.odbc.JdbcOdbcDriver seems to not work very well with the odbc database (divalto proprieritary stuff) I have.
I can see the list of tables but I can’t access to the table.
So I’d like to try another odbc driver on servoy side. Where I can get different drivers than the sun.jdbc.odbc.JdbcOdbcDriver.
Thanks
the best way, is to make a linked server (with ODBC) in Sybase.
Than connect Servoy to the Sybase.
This even works with Microsoft Acces files.
Thanks for the tip, but I can’t manage to use it.
Did you add something to sybase, an odbc driver ?
How to configure sybase for it ?
You have to dowload Ianywhere 9.02 from the Sybase website (which is free for developers) In that package you will find Sybase Central, a tool to work with Sybase Ianywhere database.
Look into the manuals and search for Remote Server.
rightclick in Sybase Central, under Remote Server, to define a remote server and the wizard will help you setting it up!
Thanks a lot HJK.
It worked !
unfortunately it’s very, very slow
Moreover I have some “forbidden characters” issue, so I can’t search
what DB are you using to connect to??
We have some live servers connecting to ACCESS and it rapidly fast!
Unfortunately, it’s a crappy proprieratary database called divalto. I’m sure the problems are due to that, but they’re still annoying.
Maybe it’s a cahrset issue, is there a location where I acn try other charsets ?
don’t know, look into the manuals!