SqlDbx
You are not logged in.
Pages: 1
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
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
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
Pages: 1