Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase IQ to Oracle via ODBC - help please

4 posts in General Discussion Last posting was on 2012-02-25 17:19:10.0Z
Liezl Posted on 2012-01-17 13:24:44.0Z
Sender: fc3.4f156454.1804289383@sybase.com
From: Liezl
Newsgroups: sybase.public.iq
Subject: Sybase IQ to Oracle via ODBC - help please
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f15769c.1401.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 17 Jan 2012 05:24:44 -0800
X-Trace: forums-1-dub 1326806684 172.20.134.41 (17 Jan 2012 05:24:44 -0800)
X-Original-Trace: 17 Jan 2012 05:24:44 -0800, 172.20.134.41
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4446
Article PK: 246587

Hello,

We are now attempting to create a connection to Sybase IQ
from
Oracle on Linux.
Somehow we can’t get it to work.
We want to use the IQ 15.2 64 bit driver?

Does anyone have an example of how to set-up this ODBC
connection on LINUX between ORACLE and Sybase IQ?

Do I have to refer to the libdboraodbc11_r.so or
libdbodbc11.so when connecting to IQ from Oracle?
This is a production environment, what else needs to be set?

The /etc/odbc.ini looks like this:

[ProdIQ]
Driver=
=/sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
Userid= XXXXXXXX
Password= XXXXXXXX
EngineName= ProdIQ
CommLinks= "tcpip(host=.....:2638)"
AutoStop=no
DatabaseName= ProdIQ
DatabaseFile= /ProdIQ_server/db/iq/ProdIQ.db

/etc/odbcinst.ini

[SybaseIQ]
Description = Adaptive server IQ (Sybase)
Driver =
/sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
UsageCount = 1


The .odbc.ini in the IQ installation directory looks like:

[ProdIQ]
Driver=/sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
ServerName=ProdIQ
CommLinks=tcpip(HOST=......:2638),shmem
UID=xxxx
PWD=xxxxxx
DatabaseName=ProdIQ

This last one seems to successfully connect with isql


IQRules Posted on 2012-01-17 16:38:32.0Z
From: IQRules <iqrules@noname.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:9.0) Gecko/20111222 Thunderbird/9.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.iq
Subject: Re: Sybase IQ to Oracle via ODBC - help please
References: <4f15769c.1401.1681692777@sybase.com>
In-Reply-To: <4f15769c.1401.1681692777@sybase.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f15a408$1@forums-1-dub>
Date: 17 Jan 2012 08:38:32 -0800
X-Trace: forums-1-dub 1326818312 10.22.241.152 (17 Jan 2012 08:38:32 -0800)
X-Original-Trace: 17 Jan 2012 08:38:32 -0800, vip152.sybase.com
Lines: 52
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4447
Article PK: 246586

Can you use JDBC here?

On 1/17/2012 8:24 AM, Liezl wrote:
> Hello,
>
> We are now attempting to create a connection to Sybase IQ
> from
> Oracle on Linux.
> Somehow we canÂ’t get it to work.
> We want to use the IQ 15.2 64 bit driver?
>
> Does anyone have an example of how to set-up this ODBC
> connection on LINUX between ORACLE and Sybase IQ?
>
> Do I have to refer to the libdboraodbc11_r.so or
> libdbodbc11.so when connecting to IQ from Oracle?
> This is a production environment, what else needs to be set?
>
> The /etc/odbc.ini looks like this:
>
> [ProdIQ]
> Driver=
> =/sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
> Userid= XXXXXXXX
> Password= XXXXXXXX
> EngineName= ProdIQ
> CommLinks= "tcpip(host=.....:2638)"
> AutoStop=no
> DatabaseName= ProdIQ
> DatabaseFile= /ProdIQ_server/db/iq/ProdIQ.db
>
> /etc/odbcinst.ini
>
> [SybaseIQ]
> Description = Adaptive server IQ (Sybase)
> Driver =
> /sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
> UsageCount = 1
>
>
> The .odbc.ini in the IQ installation directory looks like:
>
> [ProdIQ]
> Driver=/sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
> ServerName=ProdIQ
> CommLinks=tcpip(HOST=......:2638),shmem
> UID=xxxx
> PWD=xxxxxx
> DatabaseName=ProdIQ
>
> This last one seems to successfully connect with isql


Rob V Posted on 2012-01-18 21:07:19.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:9.0) Gecko/20111222 Thunderbird/9.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.iq
Subject: Re: Sybase IQ to Oracle via ODBC - help please
References: <4f15769c.1401.1681692777@sybase.com>
In-Reply-To: <4f15769c.1401.1681692777@sybase.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f173487$1@forums-1-dub>
Date: 18 Jan 2012 13:07:19 -0800
X-Trace: forums-1-dub 1326920839 10.22.241.152 (18 Jan 2012 13:07:19 -0800)
X-Original-Trace: 18 Jan 2012 13:07:19 -0800, vip152.sybase.com
Lines: 71
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4448
Article PK: 246588

You may want to have a look at the instructions at
www.sypron.nl/iq_ase_odbc.html. Even though these are for IQ-to-ASE, you
may get ideas that could help you forward (or then, maybe not...).

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide" (new!)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------

On 17-Jan-2012 14:24, Liezl wrote:
> Hello,
>
> We are now attempting to create a connection to Sybase IQ
> from
> Oracle on Linux.
> Somehow we canÂ’t get it to work.
> We want to use the IQ 15.2 64 bit driver?
>
> Does anyone have an example of how to set-up this ODBC
> connection on LINUX between ORACLE and Sybase IQ?
>
> Do I have to refer to the libdboraodbc11_r.so or
> libdbodbc11.so when connecting to IQ from Oracle?
> This is a production environment, what else needs to be set?
>
> The /etc/odbc.ini looks like this:
>
> [ProdIQ]
> Driver=
> =/sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
> Userid= XXXXXXXX
> Password= XXXXXXXX
> EngineName= ProdIQ
> CommLinks= "tcpip(host=.....:2638)"
> AutoStop=no
> DatabaseName= ProdIQ
> DatabaseFile= /ProdIQ_server/db/iq/ProdIQ.db
>
> /etc/odbcinst.ini
>
> [SybaseIQ]
> Description = Adaptive server IQ (Sybase)
> Driver =
> /sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
> UsageCount = 1
>
>
> The .odbc.ini in the IQ installation directory looks like:
>
> [ProdIQ]
> Driver=/sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
> ServerName=ProdIQ
> CommLinks=tcpip(HOST=......:2638),shmem
> UID=xxxx
> PWD=xxxxxx
> DatabaseName=ProdIQ
>
> This last one seems to successfully connect with isql


NJS Posted on 2012-02-25 17:19:10.0Z
From: NJS <NJS@optonline.net>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.iq
Subject: Re: Sybase IQ to Oracle via ODBC - help please
References: <4f15769c.1401.1681692777@sybase.com> <4f173487$1@forums-1-dub>
In-Reply-To: <4f173487$1@forums-1-dub>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f49180e@forums-1-dub>
Date: 25 Feb 2012 09:19:10 -0800
X-Trace: forums-1-dub 1330190350 10.22.241.152 (25 Feb 2012 09:19:10 -0800)
X-Original-Trace: 25 Feb 2012 09:19:10 -0800, vip152.sybase.com
Lines: 86
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4467
Article PK: 246609

Interesting note on IQ-Ase-odbc but I am wondering whether we can use
it for (oracle, Db2, MSSQL).

Currently, I use ECDA 15.0 to connect IQ to DB2 and strangely there are
no performance tuning possible on DCA (like packetsize, larger
shared-mem usage, more cores/engines etc..), so it runs awefully slow to
pull a simple "select * from table" out of DB2, which DB2 runs
super-fact locally.

Hoping to try the IQ/CIS route via datadirect ODBC to see if it speeds
things up.

On 1/18/2012 4:07 PM, Rob V wrote:
> You may want to have a look at the instructions at
> www.sypron.nl/iq_ase_odbc.html. Even though these are for IQ-to-ASE, you
> may get ideas that could help you forward (or then, maybe not...).
>
> Rob V.
> -----------------------------------------------------------------
> Rob Verschoor
>
> Certified Professional DBA for Sybase ASE, IQ, Replication Server
>
> Author of Sybase books (order online at www.sypron.nl/shop):
> "Tips, Tricks & Recipes for Sybase ASE"
> "The Complete Sybase IQ Quick Reference Guide" (new!)
> "The Complete Sybase ASE Quick Reference Guide"
> "The Complete Sybase Replication Server Quick Reference Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
> Sypron B.V., The Netherlands | Chamber of Commerce 27138666
> -----------------------------------------------------------------
>
>
> On 17-Jan-2012 14:24, Liezl wrote:
>> Hello,
>>
>> We are now attempting to create a connection to Sybase IQ
>> from
>> Oracle on Linux.
>> Somehow we canÂ’t get it to work.
>> We want to use the IQ 15.2 64 bit driver?
>>
>> Does anyone have an example of how to set-up this ODBC
>> connection on LINUX between ORACLE and Sybase IQ?
>>
>> Do I have to refer to the libdboraodbc11_r.so or
>> libdbodbc11.so when connecting to IQ from Oracle?
>> This is a production environment, what else needs to be set?
>>
>> The /etc/odbc.ini looks like this:
>>
>> [ProdIQ]
>> Driver=
>> =/sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
>> Userid= XXXXXXXX
>> Password= XXXXXXXX
>> EngineName= ProdIQ
>> CommLinks= "tcpip(host=.....:2638)"
>> AutoStop=no
>> DatabaseName= ProdIQ
>> DatabaseFile= /ProdIQ_server/db/iq/ProdIQ.db
>>
>> /etc/odbcinst.ini
>>
>> [SybaseIQ]
>> Description = Adaptive server IQ (Sybase)
>> Driver =
>> /sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
>> UsageCount = 1
>>
>>
>> The .odbc.ini in the IQ installation directory looks like:
>>
>> [ProdIQ]
>> Driver=/sybase_client/iq_15/IQ-15_2/lib64/libdbodbc11.so
>> ServerName=ProdIQ
>> CommLinks=tcpip(HOST=......:2638),shmem
>> UID=xxxx
>> PWD=xxxxxx
>> DatabaseName=ProdIQ
>>
>> This last one seems to successfully connect with isql
>