Proxy table mapping an ASE Table
I try to create an IX proxy tablwe wich mapps a ASE table.
I created an remote server with JDBC class bur when I try to
do a connection I receive the following error message:
1> forward to remoteServer sp_who
Msg 11206, Level 16, State 0:
ASA Error -656: Unable to connect to server 'remoteServer':
No suitable driver
(1 row affected)
What is wrong ? Thanks in advance for any hints.
...Proxy tables between ASE 11.5.1 and ASE 12
We are in HP-UX 11 and have two servers, one in ASE 12 and other in ASE
11.5.1. This servers need to share data via proxy tables.
Does somebody know if it is possible to use proxy tables in ASE 12
referencing tables in ASE 11.5.1 and viceversa?
Thanks a lot.
Roberto Espitia wrote:
> We are in HP-UX 11 and have two servers, one in ASE 12 and other in ASE
> 11.5.1. This servers need to share data via proxy tables.
> Does somebody know if it is possible to use proxy tables in ASE 12
> referencing tables in ASE 11.5.1 and viceversa?
It should work....Proxy Tables ASE
I want to create proxy tables in ASE; the physical tables are in ASA.
I have a problem creating a proxy table in ASE. The error message is
something like "could not connect to remote server". I have some questions:
* How to configure the remote server in ASE to connect an ASA database?
* How to configure ASA environment?
...Proxy table ASE
I'm trying to insert 600000 rows from sybase IQ (linux) into a proxy table in
sybase ASE (windows NT), but it takes over 15 minutes.
I've also done the same select in the IQ table, and the performance seems to be
quite good, it took something like 10 seconds.
But when I make a insert from IQ into a ASE proxy table with 600000 rows (and
something like 30 columns) it took like 15 minutes to finish. Is this normal?
There is anything I can do to improve IQ performance (something to be
Thanks in advance
---== Posted via the PFCGuide Web Newsreade...Working with ASA, ASE and proxy tables.
I am trying to create proxy tables on ASE from tables on an ASA 6.02
server. I am able to load proxy tables in ASE from ASA if ASE in on a
different servers. But when they are on the same server I get an unable
to connect error.
I am running on NT 4 sp4, ASE 11.9.2 with CIS, and ASA 6.02. Why can
I load the proxy tables onto a Unix ASE server but not the NT. Could
both ASA 6.02 and ASE 11.9.2 be using slightly different versions of
Open Server and Open Client?. Do they install any of the same dlls in
the windows system directory? Has anyone ever tried this configuration
an...problem with proxy table of ASe to IQ
I try to create a proxy table in an ASE pointing to a table
in IQ, all teh set ups are Ok, iq server is known in ASE:
connect to iq_server
disconnect from iq_server
Exited passthru mode from server 'stckrec'.
When I create the follwoing proxy table it fails with
CREATE EXISTING TABLE IQ_StockRecordRaw( C1 varchar(1000))
EXTERNAL TABLE at "iq_server.iqdb.dbo.StockrecordRaw"
Msg 11216, Level 16, State 13:
Server 'SRV15', Line 1:
Internal Ct-Lib/Cs-Lib error 67241508: 'ct_send(): protocol
intern...ase 15.5 proxy Table
Hi all ,
for Sybase technician,
with ASE 12.5 (win2000) , the statement 'select @var = col from proxyTable
where ....' inside the stored proc give always 0 (zero) rows.
...Proxy tables in ASE 12.5
Is it possible to have ASE proxy table to ASIQ in PDesigner
Thanks in advance,
Jo=?ISO-8859-1?B?428=?= Sim=?ISO-8859-1?B?9WVz?= wrote...
> Hi everyone.
> Is it possible to have ASE proxy table to ASIQ in PDesigner
> Thanks in advance,
> Jo=e3o Sim=f5es
On the Options tab for the table select "External table" option.
Jim Egan [TeamSybase]
Sybase product enhancement requests:
...sql sent to proxy table
is there any way I can get a log of the sql sent to a proxy
table when I submit a query (using ASA version 126.96.36.19998)?
eg. get it (ISQL or anything) to write to the ODBC log?
I get an error (ICOBOL ODBC DRIVER] Expected lexical element
not found: SET ) on an update query and need to know why. I
have no problems running the same update query using
Access writes to the ODBC log eg.
MSACCESS 608-62c ENTER SQLAllocStmt
HSTMT * 092B1588
MSACCESS 608-62c EXIT SQLAllocStmt with return code
HDBC ...Proxy Tables in Table Last
In IM10.5 When I look at my list of tables when making a
new query or report, I cannot see tables that are proxy
tables. Am I missing a setting somewhere to let me see
...Reverse Proxy table ASE 15.0.2
I have tried to make a reverse of proxy tables (ASE 15.0.2)
with PD 12.5 ESD#16 but doesn't work, I believe ..... The
proxy tables are reversed as normal tables.
Is It correct that in reverse window don't appear the sheet
Thanks in advance
...Blocks created on ASE Proxy Table when select/update
We have a proxy table that is being accessed from an IQ
The procedure selects data as well as updates data into the
When the proc is run twice simultaneously, there is a block
created on the ASE side..(select from one proc blocking
update from another proc)
Is there any way to change this behaviour??
The table is DataPages locked if that is of any use....
I'd want to start with finding out what query plan(s) are in use on the ASE
side, along with the type of locks required to support said query plans
(the SQL text, submitted by IQ to AS...creation of proxy tables in IQ with remote ASE server
i want to create proxy tables in sybase IQ 12.6 windows with
respect to sybase ASE 15.0.2 linux
i create ASE remote server in IQ with the help of sybase central
when i execute the following script in iq ,
create existing table <table_name>_proxy at '<remote ASE server>.<iq
i am getting error that remote ASE server name not found.
I believe the syntax of your statement is wrong. Qualify the remote ASE
at '<remote_ASE_server>.<ASE_dbname>.<ASE_...Creating proxy table IQ to ASE
I have set the environment variables
This is what I have entered in IQ isql - connected with
create server ase_proxy_server
create existing table proxy_stock_trade
I keep getting error
ASA error -656 no suitable driver.