Conecting to 4760 Sybase ASA Database

suvasimon · Post by **suvasimon** » 16 Jan 2007 23:19

I have a 4760 here, but we can't generate the reports we need with the in-built report generator. I would like to be able to connect to the underlying Sybase ASA DB and do SELECTs directly (read-only access is all we want), how do I do that?

I tried connecting using JDBC, but I'm not sure what the port number or indeed the username/password.

Any suggestions?

Post by **frank** » 16 Jan 2007 23:57

It's possible. I wrote a documentation that I never published for that. I will try to look for it tomorrow.

suvasimon · Post by **suvasimon** » 21 Jan 2007 22:28

I would really appreciate that, thanks!

mboyra · Post by **mboyra** » 14 Feb 2007 06:00

Hi,

I've read this post, and I'm also interested in accesing the OmniVista DataBase to be able to deal with CDRs using our Report Application.

Frank, did you publish that documentation somewhere?

Thanks in advance

Egidio · Post by **Egidio** » 11 Apr 2007 09:04

frank wrote:It's possible. I wrote a documentation that I never published for that. I will try to look for it tomorrow.

Hi Frank,

I would also be interested in this documentation.
Do you send it on pm or how do you pass it on?
It would be really great for I never got to feel at home with OV reports,
but I like sql.

Thanks a lot

Egidio

JHades · Post by **JHades** » 11 Apr 2007 10:49

Same interest over here. I tried to connect to the Sybase Db via the network, but I haven't had any success until now.

JHades · Post by **JHades** » 13 Apr 2007 03:56

Does anyone has an idea how to connect to the Sybase Db from a remote pc.?

I've tried it using ODBC but from some reason ODBC can't connect to the server. In the Sybase Central I can get the information of the service which is running on the server, but I get no connection.

Same story from SQL Anywhere on the remote pc. I have even installed the 4760Client on the remote pc. But I keep getting the message "Could not connect to the database - database server not found"

I have used the DNS-name and the ip-address of the server, but no success.

It would be very useful to connect to the underlying Db as some of the people around here are crazy about statistics on all kind of things.

Egidio · Post by **Egidio** » 13 Apr 2007 04:16

Hi JHades,

I am just over the very same problem and this is how far I got:

in Sybase Central / Services I find "nmc50"
under Properties / Configuration after "-n NameOfTheServer" follows fielname path\nmc5.db
and "-x tcpip(Port=xxxxx)

Setting up of ODBC (Sybase Cetral Utilities: Open ODBC Administrator):
Add "someName"
Login UserID = dba
Password "as you hopefully remember"
Database = NameOfTheServer (found in Configuration see above)
Databasename = nmc5 that is the filename as follows after Servername without path and .db

No further entries needed.

I could test this connection within ODBC Administrator, = ok.
But I could not use Sybase Interactive SQL to get to the data.

I could however get to the data with SQLbrowser from http://www.kge.de/SQLBrowser.html (only in German!)

At the moment I am busy trying to get at it from another PC also, but did not yet succed.

I hope you can get a bit further with this.
As soon as I find a way, how to get at it from another PC I shall put it here also.

JHades · Post by **JHades** » 13 Apr 2007 05:24

Doesn't work for me. I have tried it a thousand times, and I've done it again today, keep getting the message 'Server not found'.

Now I tried to create a remote server in Sybase Central on the server. So I created an System-DSN, but now I got the message "Request to start/stop the database denied". It's no problem ro create an user-DSN on the server. But when I try to do it remotely, I can't find the database server.

A serious challenge .....

Egidio · Post by **Egidio** » 13 Apr 2007 05:25

small addition:
As I could now consult the system tables of the database I saw that dba has most probably no right to connect from remote. And dba is not allowed to change this.