SqlDbx Forum

SqlDbx

You are not logged in.

#1 2012-07-16 20:57:47

madjoe
Member

how do I query Sybase IQ server?

Hello,

How can I query Sybase IQ server from a script such as Python or Perl using ODBC? I searched on internet but I couldn't find a sample connection string (not even on connectionstrings.com). Could someone provide a sample connection string for this?

the details i have for connection are server name and database schema name. (and username and password).

example using isql is

isql -S PSGSESHR02A_IQ -D tkagoraprd1 -U agora_query -P *****

Above connection works using isql. I need a corresponding connection string using odbc driver and Sybase IQ drivers.

Thanks.

Regards, madjoe

Offline

#2 2012-07-18 16:34:03

sqldbxhelp
Administrator

Re: how do I query Sybase IQ server?

Here's one way to figure out connection string.
Start ODBC Admin
Select File DSN tab
Click Add... and select correct ODBC Driver
Configure and save to file.
Open file and check all the parameters for connection string

Offline

#3 2012-07-30 20:47:25

madjoe
Member

Re: how do I query Sybase IQ server?

Thanks for your response. I tried your approach but couldn't make it work.  But i found the correct connection string from one of our support teams. I am using following connection string now and it works great. thanks.

"Driver={Sybase IQ};UID=username;PWD=*****;ServerName=PSGSESHR01A_IQ;CommLinks=SharedMemory,TCPIP{host=psgseshr01_iq.sg.xyz.com;port=3051}"

Regards,
madjoe

Offline

Board footer

Powered by FluxBB