failing to connect to Ianywhere remote db

Classic Servoy
1

Hi,

setup:
Servoy Server running on W2Kpro
Ianywhere running on same machine
Developer running on OSX
changed succesfully the repository pointing to the W2K machine

Now trying to connect to another DB running on W2K machine. DB is called R2L is running on port 49152 as indicated by Ianywhere.
Using this connection string:

jdbc:sybase:Tds:10.0.1.10:49152?ServiceName=R2L&CHARSET=utf8

gives Cannot setup server and in Details: java.sql.SQLException:JZ0C0: Connection is already closed.

Anybody an idea on what’s going on ?

TIA

2

Have you set the correct characterset in either the db andor the connection string?

The characterstring in the connectionsting is dat of unicode. I experienced that the default setup of ianywhere (mac os) is latin. What happens if you leave the characterset bit away?

3

I don’t think it has to do with the charset. Used on the local developer I can connect to the db. I’m thinking now it has to do with making a “networked” db in ASA. I’m looking into it on how one creates a networked DB in ASA?

Any suggestion welcome since I need this thing working today :(

TIA

4

I am certainly not an expert but what you want to do doesn’t ring me a bell. I hope this works. Do you have the right driver? Have you checked that setting I suggested?

5

Problem Solved :D :D

Everything in Servoy was correct but I needed to start the DB as a networked db, not as a local DB.

Now the real work will start …

Thanks Marcel for looking into the prob

6

great news…