Connecting to a database on a server with Sybase Central

Classic Servoy
1

Hi All

We set up some time ago a database on a server (Mac OS X Server 10.4.7) and are able to connect to the repository on that server with Servoy Developer (on a Mac client) and develop (the solution) - no problem here.
But when I try to connect with Sybase Central to that server side repository, I get databases listed except the one I am developing on with Servoy Developer. Now I found that I only get access with Sybase Central to databases which are in the local! (client side) sybase.config side, i. e. if I add the database name to my local sybase.config file, I can access the database on the server!? Of course, on my client Mac, the dbserv9 daemon process doesn’t then start any more, because it is looking for the database file locally (in the database folder) and there is none in this folder, because it’s in the database folder on the server.
I don’t know what’s going on here. How can I correctly connect to a server side database with Sybase Central?

Best regards, Robert

2

Hi Robert,

I’m probably missing something here but I’ve attached a screen shot of the Sybase Central connect screens that I have here. Basically I have three instances of Sybase ASA running on three computers here: a G4, a G5 and a Dell PC. All of these run on the local network. When I click on the ‘Database’ tab in Sybase Central and then the ‘Find’ button this is what I get, namely the three instances of my Servoy Repository running on those three machines. I then choose which one I want and create and/or alter tables on whichever one I chose. Do you not get similar behavior when you do that?

P.S. Actually can’t add the image for some reason. Basically the picture just shows the three instances of Servoy repository running as defined by the IP address of the machine they are running on.

3

Hi John

Nice to hear from you :-) I also get that but when I connect to an instance, which is possible, I get the solutions displayed, except one. i noticed that I only get the soltions displayed which are in my local ./sybase_db/sybase.config file, i. e. the file on the client Mac!, i. e. the developing machine. Very strange to me.

Best regards, Robert

PS: BTW, I also can’t load images any more, do more people have that problem? Then we should report it.

john.allen:
Hi Robert,

I’m probably missing something here but I’ve attached a screen shot of the Sybase Central connect screens that I have here. Basically I have three instances of Sybase ASA running on three computers here: a G4, a G5 and a Dell PC. All of these run on the local network. When I click on the ‘Database’ tab in Sybase Central and then the ‘Find’ button this is what I get, namely the three instances of my Servoy Repository running on those three machines. I then choose which one I want and create and/or alter tables on whichever one I chose. Do you not get similar behavior when you do that?

P.S. Actually can’t add the image for some reason. Basically the picture just shows the three instances of Servoy repository running as defined by the IP address of the machine they are running on.

4

Hi Robert,

Here are couple of things you may want to check out. First, confirm that your server is actually running the Sybase ASA repository database using dbsrv versus dbeng. I believe you can check this in the ./servoy.properties file.

The other thing to do is to try to connect to the database server even if Sybase Central can’t “find” the server. You can do this by clicking on the Advanced tab in the Connect window. Then enter a line like:

CommLinks=tcpip{host=your.machine.name.or.ip.address}

Hope this helps!

David Jonker

5

Hi John

Thanks for your answer. Yes, principally I see the same as you do, but there seems that under certain circumstances, I can’t connect to the server, although I see it, just the solution is not visible?
I came as far as that: If I have the same solution on my PowerBook and on the server, and I want to connect once to server and then to the (local) PB solution, Sybase Central sais I have already connected, which is not true (I have only connected to the solution on the other machine). There seems to be some mismatch there.

Best regards, Robert

john.allen:
Hi Robert,

I’m probably missing something here but I’ve attached a screen shot of the Sybase Central connect screens that I have here. Basically I have three instances of Sybase ASA running on three computers here: a G4, a G5 and a Dell PC. All of these run on the local network. When I click on the ‘Database’ tab in Sybase Central and then the ‘Find’ button this is what I get, namely the three instances of my Servoy Repository running on those three machines. I then choose which one I want and create and/or alter tables on whichever one I chose. Do you not get similar behavior when you do that?

P.S. Actually can’t add the image for some reason. Basically the picture just shows the three instances of Servoy repository running as defined by the IP address of the machine they are running on.

6

Hi Robert,

I’m taking a guess here, but it sounds like Sybase Central is possibly getting confused because the name of the database server on your Servoy Application Server is the same as the Database Server name on your PowerBook.

I’d suggest writing out the machine name and port number that the Servoy Application Server is running on right into the Server Name field in Sybase Central connection dialog. So, for example on my Servoy server I write “djonker-pc.sybase.com:2638” instead of “servoy_repository”

David

Robert Huber:
I came as far as that: If I have the same solution on my PowerBook and on the server, and I want to connect once to server and then to the (local) PB solution, Sybase Central sais I have already connected, which is not true (I have only connected to the solution on the other machine). There seems to be some mismatch there.

7

Hi David

david_jonker:
Hi Robert,

I’m taking a guess here, but it sounds like Sybase Central is possibly getting confused because the name of the database server on your Servoy Application Server is the same as the Database Server name on your PowerBook.

Your guess is correct!

david_jonker:
I’d suggest writing out the machine name and port number that the Servoy Application Server is running on right into the Server Name field in Sybase Central connection dialog. So, for example on my Servoy server I write “djonker-pc.sybase.com:2638” instead of “servoy_repository”

David

I will try that, thanks a lot for the suggestion, that could very well be the case!

Best regards, Robert

Robert Huber:
I came as far as that: If I have the same solution on my PowerBook and on the server, and I want to connect once to server and then to the (local) PB solution, Sybase Central sais I have already connected, which is not true (I have only connected to the solution on the other machine). There seems to be some mismatch there.