Error in ISQL

[Former Member]

Hi Experts,

When i enter isql command in my redhat linux server show the message like

not able to login isql server,what to do? how to solve this problem?

Regards,

Dinesh Kumar S.

[Former Member · Accepted solution]

Hi,

Issue has been solved,

Try,

isql64

Regards,

Dinesh Kumar S.

[hans-juergen_schwindke]

Hi,

you have to create a DSN (Data Source Name) and refer to this.This DSN contains the connection parameters. Isql needs to know where it can connect to:

A datasource looks like this:

[HDB]

servernode=hanaserver.xyz.com:30015

Driver=/usr/sap/hdbclient/libodbcHDB.so

serverdb=HDB

UID=SYSTEM

PWD=manager

The datasource is stored in a file called .odbc.ini (don't miss the first dot in front of odbc). For my application this file is located in the home directory of the application.

Then you can call isql like this:

isql HDB SYSTEM manager

Best regards,

Juergen

[Former Member]

Hi Hans-Juergen Schwindke,

Thanks for replay.

I am new for redhat linux how to find DSN in my system its already have or not how to know?

Regards,

Dinesh Kumar S.

[hans-juergen_schwindke]

Hi,

you have to go to your home directory / the home directory of the application with the cd command:

cd

then you should have a look on the content of the directory. There you should find a file named .odbc.ini

ls -a

Anyhow maybe the .odbc.ini file is located somewhere else on your system. In this case you can use the find command (switch to root user and go to directory /):

find / -name ".odbc.ini"

Please make sure that the find will really find the file. So create a sample file first and search for this one

(

touch /tmp/.abc

find / -name ".abc"

--> now the command should find the file .abc

)

Best regards

Juergen

[Former Member]

Hi,

Thank for replay, .odbc.ini file is already there? next what to do?

Regards

Dinesh Kumar S.

[hans-juergen_schwindke]

Hi,

now you should analyze the .odb.ini file.

It should look a bit like this:

[HDB]

servernode=hanaserver.xyz.com:30015

Driver=/usr/sap/hdbclient/libodbcHDB.so

serverdb=HDB

UID=SYSTEM

PWD=manager

In square brackets you have the name. This name must be used for setting up the connection. Additionally you can / have to specify the username and password. If these are not given when executing isql, then the values from the datasource are taken. All in all it looks like this:

isql   name_of_the_source   user_name   password

And based on my dsn from above:

isql HDB SYSTEM manager

Btw. such DSNs depend on the database you want to connect. Above example is for HANA; the following is for SAP IQ:

[SIQ]

Userid=DWH

Password=mypasswd

DatabaseName=siq

ServerName=siq

CommLinks=tcpip{host=12.13.14.15;port=2638}

Driver=libdbodbc9.so

Best regards,

Juergen

[Former Member]

HI,

thanks for replay,how to analyze .odbc.ini file in my another server working fine check it nothing in .odbc.ini file but its working in this new server  .odbc.ini also same nothing inside.odbc.ini file where set dsn inside the .odbc.ini or any other place guid me

Regards,

Dinesh Kumar S.

[hans-juergen_schwindke]

Hi,

you can search for .odbc.ini on the server where it is working. Maybe the file is located somewhere else (and found be setting an evironment variable or config file, ... these are only guesses as I always use the solution I provided).

Best regards,

Juergen

[Former Member]

Hi,

I am not able to connect isql show this error?

Regards,

Dinesh Kumar S.