# Alternate odbc driver

**URL:** <https://forum.servoy.com/t/alternate-odbc-driver/7606>\
**Category:** Classic Servoy\
**Created:** [June 1, 2007, 8:21am UTC](https://forum.servoy.com/t/alternate-odbc-driver/7606 "2007-06-01T08:21:59Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vince](https://avatars.discourse-cdn.com/v4/letter/v/b5e925/32.png) [@Vince](https://forum.servoy.com/u/Vince)\
**Post date:** [June 1, 2007, 8:21am UTC](https://forum.servoy.com/t/alternate-odbc-driver/7606/1 "2007-06-01T08:21:59Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\
**Post date:** [June 1, 2007, 4:00pm UTC](https://forum.servoy.com/t/alternate-odbc-driver/7606/2 "2007-06-01T16:00:44Z")

</div>

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.

![:D]( "Very Happy")

---

<div class="post-metadata">

**Author:** ![Vince](https://avatars.discourse-cdn.com/v4/letter/v/b5e925/32.png) [@Vince](https://forum.servoy.com/u/Vince)\
**Post date:** [June 4, 2007, 2:39pm UTC](https://forum.servoy.com/t/alternate-odbc-driver/7606/3 "2007-06-04T14:39:48Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\
**Post date:** [June 4, 2007, 2:47pm UTC](https://forum.servoy.com/t/alternate-odbc-driver/7606/4 "2007-06-04T14:47:41Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Vince](https://avatars.discourse-cdn.com/v4/letter/v/b5e925/32.png) [@Vince](https://forum.servoy.com/u/Vince)\
**Post date:** [June 4, 2007, 3:43pm UTC](https://forum.servoy.com/t/alternate-odbc-driver/7606/5 "2007-06-04T15:43:22Z")

</div>

Thanks a lot HJK.  
It worked !  
unfortunately it’s very, very slow

---

<div class="post-metadata">

**Author:** ![Vince](https://avatars.discourse-cdn.com/v4/letter/v/b5e925/32.png) [@Vince](https://forum.servoy.com/u/Vince)\
**Post date:** [June 4, 2007, 4:12pm UTC](https://forum.servoy.com/t/alternate-odbc-driver/7606/6 "2007-06-04T16:12:05Z")

</div>

Moreover I have some “forbidden characters” issue, so I can’t search

---

<div class="post-metadata">

**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\
**Post date:** [June 4, 2007, 4:35pm UTC](https://forum.servoy.com/t/alternate-odbc-driver/7606/7 "2007-06-04T16:35:43Z")

</div>

what DB are you using to connect to??  
We have some live servers connecting to ACCESS and it rapidly fast!

---

<div class="post-metadata">

**Author:** ![Vince](https://avatars.discourse-cdn.com/v4/letter/v/b5e925/32.png) [@Vince](https://forum.servoy.com/u/Vince)\
**Post date:** [June 4, 2007, 4:44pm UTC](https://forum.servoy.com/t/alternate-odbc-driver/7606/8 "2007-06-04T16:44:34Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\
**Post date:** [June 4, 2007, 4:45pm UTC](https://forum.servoy.com/t/alternate-odbc-driver/7606/9 "2007-06-04T16:45:23Z")

</div>

don’t know, look into the manuals!
