Connecting to Sybase error...

Classic Servoy
1

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

2

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

3

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

4

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

5

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.

6

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