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 proxy table to ASE - issue

2 posts in General Discussion Last posting was on 2012-10-13 18:31:04.0Z
J_Sorin Posted on 2012-10-12 13:33:39.0Z
Sender: 59ea.507810d0.1804289383@sybase.com
From: J_Sorin
Newsgroups: sybase.public.iq
Subject: Sybase IQ proxy table to ASE - issue
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50781c32.5b0c.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 12 Oct 2012 06:33:39 -0700
X-Trace: forums-1-dub 1350048819 172.20.134.41 (12 Oct 2012 06:33:39 -0700)
X-Original-Trace: 12 Oct 2012 06:33:39 -0700, 172.20.134.41
Lines: 41
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4557
Article PK: 246697

Hello everyone,

I'm having issues in creating a proxy table from a db on
Sybase IQ 12.7.0 (jConnect6.0) to one on Sybase ASE 15.0.3
(jConnect 7.0).

When invoking : create existing table ProxyTable at
'ASESERVER.mydb.dbo.Table' it fails with msg : ASA Error
-667: Could not access column information for the table
'mydb.dbo.Table'

The visibility and access permissions from IQ to ASE are
correctly set as :
1. Remote ASE server was added with create SERVER ASESERVER
CLASS 'asejdbc' USING '<ip>:<port>/mydb'. Also remote ASE
server is present in the interfaces file from IQ.
2. The current IQ login was granted connect permission
3. An external login was created in IQ db linking the
current login to one in ASE which is owner of 'mydb'
database.

Any other actions that include remote access work fine such
as :
1. Creating a proxy table (without existing ) : create table
ProxyTable2(id int) at 'ASESERVER.mydb.dbo.Table2'
2. Creating remote stored procedures
3. Sending native syntax to remote server using FORWARD TO
'select * from Table'

I've tried to implement my solution by creating the proxy
table without "existing", such that both tables were created
at the same time, but when I populate the table in ASE it
grows very very much in size (in comparison to an identical
table created from ASE).

If anyone has any hints regarding why the creation of the
proxy table fails please provide feedback.


Thanks,
Sorin


J_Sorin Posted on 2012-10-13 18:31:04.0Z
Sender: e4a.5079b31d.1804289383@sybase.com
From: J_Sorin
Newsgroups: sybase.public.iq
Subject: Re: Sybase IQ proxy table to ASE - issue
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5079b368.e55.1681692777@sybase.com>
References: <50781c32.5b0c.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 13 Oct 2012 11:31:04 -0700
X-Trace: forums-1-dub 1350153064 172.20.134.41 (13 Oct 2012 11:31:04 -0700)
X-Original-Trace: 13 Oct 2012 11:31:04 -0700, 172.20.134.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4559
Article PK: 246699

I've figured it out eventually, it was from from JConnect
driver. Something was not compatible between version 7 from
IQ and version 6 from ASE.

Solution : Added the procs from Jconnect 6 to ASE by
manually running the content from file
/opt/sybaseiq/jConnect-6_0/sp/sql_server15.0.sql, where
/opt/sybaseiq was my instalation folder for the IQ server.
You need to run the content on the sybase ASE master db.

jConnect driver version can be checked in ase by calling
sp_version