How to connect to OmniVista's sql database

Post Reply
hamstercnw

How to connect to OmniVista's sql database

Post by hamstercnw »

Start Sybase central and open "Adaptive Server" and select Services. Right click "nmc50" and address the "Configuration" tab.

Copy the servername string after "-n" in the "Parameters:" field. It probably ends with "_4760". You need this and also your hosts IP.

Now, Go to File menu and Connect.
Supply user and password in the "Identification" tab.
Supply Server name, [hostname]_4760, Database name and Database file is nmc5 and uncheck both "Start database automatically" and

"Stop database after last disconnect" in the "Database" tab.
Enter these connection parameters in "Advanced" tab. [IP] is your hosts ip address.
"CommLinks=tcpip(HOST=[IP];PORT=30011)"
Last edited by hamstercnw on 21 Jan 2008 04:37, edited 1 time in total.
JHades

Re: How to connect to OmniVista's sql database

Post by JHades »

a better way is to create an ODBC link and connect through that link in Interactive SQL
luckyme2

Re: How to connect to OmniVista's sql database

Post by luckyme2 »

if you start isql from within the server, you only have to enter login and password and you will be connected to the database.
kinga

Re: How to connect to OmniVista's sql database

Post by kinga »

I am looking at connecting to the 4760 database so that I can create my own reports in Qlikview.
I have read the previos posts in this thread. but I think I need a bit more guidance.

Can anyone tell me exaclty how to create an odbc link to my 4760?
Post Reply

Return to “OmniVista 4760”