Proxy table mapping an ASE TableHi
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
2> go
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 12Hi everybody
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....
Duplicate a proxy tableIs there an equivalent callable procedure to the "Duplicate Proxy Table"
dialog?
Something like this:
DUPLICATE PROXY DBA.proxyTable TO DBA.dbTable
If what you are trying to do is copy data from the a remote table
to a local table, then check out the sa_migrate functions:
Adaptive Server Anywhere SQL User's Guide
14. Importing and Exporting Data
Migrating databases to Adaptive Server Anywhere
--
Mark Culp
ASA Development
** Whitepapers, TechDocs, bug fixes are all available through the **
** iAnywhere Developer Community at http://www.ianywhere...
Add row to table with table.row.add()
Everytime I click on a button I want to add a tableRow to a table like this: TextBox TB = new TextBox(); TableCell Cell = new TableCell(); Cell.Controls.Add(TB); TableRow Row = new TableRow(); Row.Cells.Add(Cell); table.Rows.Add(Row);It works the first time, but when I click the button again the last r...
Proxy Tables ASEHi.
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?
Some Tips?
Renato Gonzalez
...
Proxy table ASEHi,
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
configured?)?
Thanks in advance
Roseli
---== Posted via the PFCGuide Web Newsreade...
Duplicate row in Proxy tableI've moved database server from Win 2000 to Win 2003 and I get a lot of
strange results using proxy tables.
Previous installation (all works fine) :
- Sql Anywhere 8.02.4249
- Windows 2000 server
New installation:
- Sql Anywhere 8.03.5144
- Windows 2003 server
In both cases:
- Odbc driver IBM Client Access 9.00.08.00 for As400 DB2
On the new installation I get one row duplicated when I select from every
proxy table.
The duplicated row is always the first row of the last fetched block.
For example, if the table has 232 records Sql Any fetch the rows in blocks
of 50. Th...
Add Column on Proxy tableI have a prozy table that references a table in another
database.
I want to add a column to the proxy table that has already
been added to the original table.
I get a "Column already exists" error when I try to run and
add column statement on the proxy table.
Any advice greatly appreciated.
Thanks!
Melissa
Melissa wrote:
> I have a prozy table that references a table in another
> database.
>
> I want to add a column to the proxy table that has already
> been added to the original table.
>
> I get a "Column already exists" er...
Proxy tables in ASE V12Our agency is currently developing a new EAServer application which will
include significant usage of CIS to access remote tables via proxy tables.
Many of these accesses will require joins - joins between tables
exclusively on the remote instance of ASE as well as joins between remote
tables (via proxy tables) and local tables. Is anyone aware of any issues
or gotchas, performance or otherwise, regarding using proxy tables in ASE
V12?
Also, this application will access two databases on the local server
sometimes joining tables across those databases. The development team
...
Proxy tables in ASE 12.5Hi everyone.
Is it possible to have ASE proxy table to ASIQ in PDesigner
10.1?
Thanks in advance,
Jo=e3o Sim=f5es
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
> 10.1?
>
> 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:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement
...
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...
ase 15.5 proxy TableHi 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.
TIA
...
problem with proxy table of ASe to IQI 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
sp_iqwho
works well
disconnect from iq_server
Exited passthru mode from server 'stckrec'.
When I create the follwoing proxy table it fails with
following mesage:
CREATE EXISTING TABLE IQ_StockRecordRaw( C1 varchar(1000))
EXTERNAL TABLE at "iq_server.iqdb.dbo.StockrecordRaw"
go
Msg 11216, Level 16, State 13:
Server 'SRV15', Line 1:
Internal Ct-Lib/Cs-Lib error 67241508: 'ct_send(): protocol
specific layer:
intern...
how to add the unique index while there are duplicate row in the table?1> declare delete_duplicate_catalog cursor for
select id from catalog_5_4
for update
2> 3> 4> 5> 6>
7> go
1> open delete_duplicate_catalog
2> go
Msg 311, Level 16, State 1:
Line 3:
The optimizer could not find a unique index which it could use to scan
table
'catalog_5_4' for cursor 'delete_duplicate_catalog'.
1>
...