Problem using ASA 7.0 connecting to ASE 11.9.2 via ODBC DSN
I downloaded ASA 7.0.2 to evaluate it as a Client to connect to a databse
which is installed on an ASE 11.9.2. system (first of all, can this be
done?). I am running Win 2K Professional. I have already set up an ODBC DSN
which I have used successfully for creating a linked server to the ASE
database in MS SQL Server 2000. I also have used this DSN to create a
successful ODBC link to MS Access 2000
In this case I created an ASA 7.0 DSN using the same configuration
parameters that I used for the the above DSN, but when I test the connection
in Sybase Central 4.0 (or in the ODBC ...ASA 7.0.2/ 1462 replicating vias RS 12.5 to ASA 7.0.2 / 1462
I need your help. Working on setting up Subscription based replication in
the following manner:
ASA 7.0.2 / 1462 (aka PDB)
...SQLRemote Problem with 7.0.2-1 and 6.0.2-1 on Linux [ASE 11.9.2-3 and ASE 12.5 eval]
I got the following problems using sql-remote.
on ASE 12.5 eval:
I got the following RPMs installed on RedHat Linux 7.2 - Kernel 2.4.17 -
After the execution of ssxtract or ssremote I got an error like:
../ssxtract: /opt/sybase-12.5/SQLRemote/lib/libsstasks7_r.so: version
`libdbtasks7_r.so' not found (required by ./ssxtract)
The file libsstasks7_r.so exists and the path is correctly specified in
There'...PB 188.8.131.5211 Problem to connect to ASE 11.9.2
Having PB 184.108.40.20611 installed in a Windows 2000 environment I cannot
connect to a remote ASE 11.9.2 (on windows NT 4 SP6).
PowerBuilder just drops me out!!!
...Problems in reverse engineering an ASA 6.0.2 database to build and ASE 11.9.2 schema
I am in the process of migrating our database backend from ASA 6.0.2 to ASE
11.9.2. I have PD AppModeler 220.127.116.110 32-bit which I have used to
reverse-engineer the current ASA database tables and stored procedures. I
then changed my 'target' database to ASE 11.5-11.9 and generated the table
schemas and stored procedure creation scripts for loading into ASE. Although
the create table scripts had some minor issues (i.e. generating 'on default'
instead of on 'default') the stored procedures scripts failed miserably.
Functions available in ASA are no longer support...Error connecting ASE 11.9.2 databases through PB 7.0 and IM 7.0
I receive this error message every time I try to list tables of ASE database
through PB 7.0 and IM 7.0.
"Store Procedure sp_pb70table not found. Specify owner.objectname or use
sp_help to check whether the object exists (sp_help may produce lots of
I could not find that store procedure in the existing store procedure in the
Adaptive server Sybsystemprocs database too.
According to your instalation manual book, I can re-create them by running
the pbsys.sql scripts, which I supposed to find it in the \sybtools
directory. But I don't have that directory ...Migration from ASA 7.0.4 to ASA 9.0.2
We run a good sized 8gb, highly transactional ASA 7x db
currently. Our application vendor has said that we can
upgrade to version 9.x now, but they have not provided any
details on how or if they have tested the application on
version 9. Currently all of their large customers are still
on ASA 7 (someone is going to have be the first). I have a
copy of 9 and we have tested without, but we are unable to
create the load that we need to guarantee that it will
handle our production environment.
Any advice or help would be greatly appreciated.
...Migration asa 7.0.4 a asa 9.0.2
I'm making a sybase migration 7.0.4 to sybase 9.0.2, I already made the
migration of the database but when trying to connect, with you line them
next, it leaves the error -75, and says that I don't have permits. I'm
using codewarrior 8
int ConectarDB (void)
ULEnablePalmRecordDB( &sqlca );
EXEC SQL CONNECT "dba" IDENTIFIED BY "sql";
I'm making something bad.
"Luis Ponce Ibarra - Hotmail" <firstname.lastname@example.org> wrote in
...Problem with creation of Proxy tables from ASE 11.9.2 to ASA 7
while creating proxy tables to link ASE 18.104.22.168 SWR9098 to ASA 7.0.1 (918)
both running on Sun Solaris, there is a problem where it takes approximately
20 minutes to create the table. When running against ASA 6.0.3, this table
creation took a matter of seconds.
Is there some issue with regards to the creation of proxy tables with CIS to
ASA 7? When I look at the CPU utilisation, ASA is hitting close to 100% CPU
while it sits there for the 20 mins.
The server is added with 'exec sp_addserver ...'
The login is added with 'exec sp_addexternlogin..."
An...Different syntax in ASE 11.9.2 and ASA 7.0.4
Hey, guru !
Pls, help me. I don't found information in ASA documentation, i wanna know
why next query working in
Count( distinct P.POLIS_COD ) , Count( distinct LOSS.LOSS_ID)
FROM LOSS, POLIS P
where P.POLIS_COD = LOSS.POLIS_COD
and in ASA 7.0.4 not working
ERROR code: -156 "Invalid expression near 'Count(distinct LOSS.LOSS_ID)'"
Using an asademo example in 8.x I tried this:
select count(distinct employee.emp_id), count(distinct department.dept_id)
from employee, department
where employee.dept_...PB 8 connect ASA 7.0 via ODBC and JDBC #2
When PowerBuilder connect ASA 7.0 via ODBC,
I exec system store procedure exec sa_conn_info under powerbuilder isql
session , it work fine!
When I connect ASA 7.0 via JDBC(Jconnect 5.2), I exec the same store
procedure, it return error like this "Select error:Internal Error: No
ResultSet: The Command did not produce any ResultSet"
ps :PB 8.0.2 version 9506
Does it PB
...SQL Remote ASA 7.0.01->ASE 11.9.2 Identity Error
Hi ! How i can replicate data into identity column ????
You must use a different datatype on the consolidated. You might consider
reading the following section in the Help file:
Replication and Synchronization Guide
PART 3. SQL Remote
CHAPTER 16 . SQL Remote Design for Adaptive Server Enterprise
Ensuring unique primary keys
Sybase - iAnywhere Solutions
Please only post to the newsgroup
EBFs and Whitepapers
"Alexandr" <shurok@mail...Problems connecting ASA 9.0.0 on SuSE 9.0
I found several threads about this, but it's still not running :-(
- all IP-connections are OK with IP-address and host-name
- the db-server is starting:
I. 03/28 00:36:31. Database server started at Sun Mar 28 2004 00:36
I. 03/28 00:36:31. Trying to start SharedMemory link ...
I. 03/28 00:36:31. SharedMemory link started successfully
I. 03/28 00:36:31. Trying to start TCPIP link ...
I. 03/28 00:36:31. Starting TCP listener on IP address 0.0.0.0:2638
I. 03/28 00:36:31. Starting on port 2638
I. 03/28 00:36:31. Looking for serve...