ODBC connectivity with SYBASE IQ

[former_member946388]

Hi, We just deployed Sybase in our organisation, and want to create odbc connectivity with the database. Below is the Sybase version. Please guide about the odbc connectivity procedure in linux

Also share the link to the trial version client and drivers

Sysbase IQ version : SAP IQ/16.0.0.808/141110/P/sp08.20/Enterprise Linux64

[lyna_tang]

Hi Asad,

Either you can connect to IQ using this command line by specifying host and port:

dbisql -c "eng=netview10_w1;uid=nethouse,pwd= ... ; links=tcpip{host=11.70.80.1;port=22988}" -nogui

or you can connect to IQ using the ODBC DSN as follows:

dbisql -c "dsn=netviewodbc"

Regards,

Lyna

[former_member946388]

Dear Mark,

Thanks for the response. I've downloaded the Client package "IQNC160011_0-20011248.TGZ" with the help of support id. After installation when i'm trying to connect with the data base then getting below error. The database is on other server. Any support will be appreciated

below is the details of my .profile file

below is the .odbc.ini file

Regards,

Asad

[markmumy]

I would strongly recommend that you upgrade your version. If you just deployed SAP IQ, you should have downloaded a much more current version. This version is no longer supported and hasn't been for some time. I would strongly suggest moving to IQ 16.1 SP02 or SP03.

This SAP Note covers our release dates and end of support: https://launchpad.support.sap.com/#/notes/2355295

There are no trial versions of the client and drivers. All drivers are free to download so long as you are current on support. Simply connect to our software download portal with a valid support account. From there you will have access to all software that your sales and support contract allows, including all drivers and connectivity tools.

On Linux, you would use a file based ODBC definition. The manuals cover this using the iqdsn command here: iqdsn Database Administration Utility

Alternatively, you could simply create a file called .odbc.ini in your home directory with contents similar to this:

[ODBC Data Sources]
iqdb=SQLAnywhere 17.0

[iqdb]
UID=username
PWD=password
DatabaseName=iqdemo
ServerName=IQENGINE
CommLinks=tcpip{verify=no;host=localhost;Port=2638}
Driver=/home/sap/IQ16/IQ-16_1/lib64/libdbodbc17.so

Mark