# Connecting to Sybase error...

**URL:** <https://forum.servoy.com/t/connecting-to-sybase-error/2499>\
**Category:** Classic Servoy\
**Created:** [August 18, 2004, 1:53am UTC](https://forum.servoy.com/t/connecting-to-sybase-error/2499 "2004-08-18T01:53:22Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Providence1](https://avatars.discourse-cdn.com/v4/letter/p/f14d63/32.png) [@Providence1](https://forum.servoy.com/u/Providence1)\
**Post date:** [August 18, 2004, 1:53am UTC](https://forum.servoy.com/t/connecting-to-sybase-error/2499/1 "2004-08-18T01:53:22Z")

</div>

I’m getting the following error and have no idea what it means:

java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect

I get it while trying to connect to a server I created in iAnywhere from the DE Servers tab of the Application Preferences in Servoy Developer.

User name: dba  
password: sql  
Database Server URL: jdbc:sybase:Tds:localhost:2638?ServiceName=CONTACT\_MGMT.DB\>&CHARSET=utf8  
Driver: com.sybase.jdbc2.jdbc.SybDriver  
Catalog:   
Schema:

Any ideas? Does Servoy Server have to be launched? Tried it with and without.

Thanks in advance!

Providence

---

<div class="post-metadata">

**Author:** ![automazione](https://avatars.discourse-cdn.com/v4/letter/a/8797f3/32.png) [@automazione](https://forum.servoy.com/u/automazione)\
**Post date:** [August 18, 2004, 11:14am UTC](https://forum.servoy.com/t/connecting-to-sybase-error/2499/2 "2004-08-18T11:14:33Z")

</div>

Did you added the database name in the ‘sybase.config’ located in sysbase\_db directory of your servoy installation path?

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [August 18, 2004, 1:58pm UTC](https://forum.servoy.com/t/connecting-to-sybase-error/2499/3 "2004-08-18T13:58:28Z")

</div>

> Providence1:  
> I’m getting the following error and have no idea what it means:  
> User name: dba  
> password: sql  
> Database Server URL: jdbc:sybase:Tds:localhost:2638?ServiceName=CONTACT\_MGMT.DB\>&CHARSET=utf8

there’s a typo in your URL as well: remove the \> behind the database name:

Database Server URL: jdbc:sybase:Tds:localhost:2638?ServiceName=CONTACT\_MGMT&CHARSET=utf8

---

<div class="post-metadata">

**Author:** ![Providence1](https://avatars.discourse-cdn.com/v4/letter/p/f14d63/32.png) [@Providence1](https://forum.servoy.com/u/Providence1)\
**Post date:** [August 18, 2004, 5:51pm UTC](https://forum.servoy.com/t/connecting-to-sybase-error/2499/4 "2004-08-18T17:51:50Z")

</div>

automazione:

I have checked the sybase.config file twice, once with Notepad once with WordPad. Although it doesn’t list it’s “.extension” after the edit in normal windoze detailed view, it is indeed edited propertly:

database/contact\_mgmt.db

jaleman:

I caught that “\>” after I posted and I still get the same error.

java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect

jdbc:sybase:Tds:localhost:2638?ServiceName=CONTACT\_MGMT&CHARSET=utf8

Any other ideas?

Does all of this just work on a Mac? (as all things do).

Thanks in advance (wish we were on the same time zone!)

Providence

---

<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:** [August 18, 2004, 7:14pm UTC](https://forum.servoy.com/t/connecting-to-sybase-error/2499/5 "2004-08-18T19:14:33Z")

</div>

You say, that you have made the db in Ianywhere?

if you start SYbase Central, and connect to servoy\_repository.  
do you see, that the db is running? can you acces the db?

Which version of Ianywhere are you using? 9.0.0 or 9.0.1?  
which version of Servoy are you using?

I think you have made the db with 9.0.1 and trying to acces it with an older version of Servoy.

---

<div class="post-metadata">

**Author:** ![Providence1](https://avatars.discourse-cdn.com/v4/letter/p/f14d63/32.png) [@Providence1](https://forum.servoy.com/u/Providence1)\
**Post date:** [August 19, 2004, 1:28am UTC](https://forum.servoy.com/t/connecting-to-sybase-error/2499/6 "2004-08-19T01:28:00Z")

</div>

I’m using Servoy 2.04

I was using iAnywhere 9.0 even though I upgraded to 9.01.

Bob C. helped out. Some files did not get copied into the sybase\_db folder in the servoy folder in Program Files properly.

Copied them from the Win32 folder in the SQL Anywhere 9 Folder in Sybase.

dbeng9.exe  
dbinit.exe  
dblgen9.dll  
dblib9.dll  
dbserv9.dll  
dbsrv9.exe  
dbunic9.dll

Regards,

JM