Stack Overflow
Stack Overflow

Questions tagged [sybase-asa]

Sybase Adaptive Server Anywhere, is an RDBMS by SAP, that runs as an embedded database. Since version 10, ASA is developed under the name [SQLAnywhere]

162 questions
1
vote
1 answer

Sybase stored procedure through JDBC

This one has baffled me for a long time, so I am trying to get some help here :) I am using JDBC to connect to an age old Sybase Adaptive server 6 (!!!) I couldn't even find the JDBC drivers for it online, so I copied them from the installation…
trumpets
  • 11
  • 1
  • 2
1
vote
1 answer

Sybase SQL Anywhere 10 - Logging SQL Statements

Does anyone know of a mechanism in Sybase ASA 9 / Sybase SQL Anywhere 10 to log the SQL statements that it executes? I have a web application that is misbehaving due to some apparently missing data, but everything looks fine. If we were able to log…
Andy Neillans
  • 258
  • 1
  • 2
  • 16
1
vote
1 answer

Sybase ASA 8 character issue - £ vs ú

I have an issue at a client where the same data field displays differently in our legacy application installed on two different machines. The character in question is the UK pound sign £ which on some machines displays as ú. I have tried to…
Richard Hopton
  • 201
  • 1
  • 5
1
vote
1 answer

Is there a table which lists invalid triggers?

I am trying to unload a schema of Sybase ASA 9 and it goes till 90% + but then it gives me an error when creating triggers: adjusted_amount is not found It doesn't tell me which trigger is referencing this column. Is there any way to find which…
Adnan Bhatti
  • 3,410
  • 4
  • 25
  • 38
0
votes
1 answer

Sybase Check Constraint Evaluation

I'm trying to formulate some check constraints in SQL Anywhere 9.0. Basically I have schema like this: CREATE TABLE limits ( id INT IDENTITY PRIMARY KEY, count INT NOT NULL ); CREATE TABLE sum ( user INT, limit INT, my_number…
Alex Koay
  • 2,915
  • 4
  • 18
  • 16
0
votes
0 answers

Inconsistency JDBC Query Sybase ASA 8.0.3

I'm very confused about this situation. I'm developing a Spring Web Based App, I'm trying to implement a simple SQL Query but for some reasons there is a consistency problem. When I Run in Sybase Central: SELECT COUNT(*) FROM "DBA"."USUARIOS" I got…
GeralDo
  • 114
  • 2
  • 6
0
votes
1 answer

How to connect to Adaptive Server Anywhere 7 (SQL Anywhere) using PHP and Apache?

I am building an application which needs to pull data from an in house database. This database is Adaptive Server Anywhere Version 7. It is running on a Windows 2003 Server with Apache and PHP. The server houses both the web application and the…
Roeland
  • 3,698
  • 7
  • 46
  • 62
0
votes
1 answer

Unable to connect to the SYBASE Database in Docker when triggered through FASTAPI

I am unable to connect to my database inside Docker when I try to trigger an SQL query through an API call. When I do it without Docker, it works. Details: When I start the uvicorn server directly with the following command: uvicorn api:app --host…
Utkarsh Saboo
  • 57
  • 2
  • 9
0
votes
0 answers

What does adding a comma and a number mean in a Sybase SQL where expression?

In managing a legacy codebase I've found a ",0.001" added to certain WHERE clause terms and I can't quite figure out why. I've abstracted this below: It's quite hard to Google and I couldn't find anything in the Sybase documentation. What does this…
Kieran
  • 718
  • 1
  • 16
  • 33
0
votes
0 answers

Sybase Database Support on Node.js with SSL

I am working on this project that has been bugging me for a while and wanted to ask community's help on it. So basically we have an On-Prem Sybase database that needs to communicate with a cloud micro service running in Kubernetes in AWS. I am…
Sam
  • 57
  • 7
0
votes
0 answers

Avoid update trigger loop sql anywhere 12

Looks like in previous versions you could use @@nestlevel, but in ver 12 it always returns -1. So how do you avoid update loops? I'm trying to sync multiple connected contacts in the same table. ALTER TRIGGER "Sync" AFTER UPDATE ORDER 1 ON…
Ove Halseth
  • 431
  • 5
  • 13
0
votes
0 answers

Replication from Sybase SQL Anywhere to MSSQL

I am trying to replicate or synchronize data between Sybase SQL Anywhere database with MSSQL db. I tried Proxy Table in SQLA and insert query is working fine. But for actual replication we need update and delete. For that I used INNER JOIN remote…
FaheemMCFC
  • 21
  • 6
0
votes
1 answer

How to pass TEXT(the list of id's as a string) to sybase ase stored procedure

How to pass TEXT(the list of id's as a string as I have long list of id's) to sybase ase stored procedure call? If I want to pass TEXT to stored procedure call then how can I use same TEXT in where IN query of sybase? CREATE PROCEDURE…
Rahul Mankar
  • 910
  • 9
  • 17
0
votes
1 answer

Sybase ASA sequence

Please advice, how to get current value of sequence from system tables/views in Sybase ASA. For example: CREATE SEQUENCE test_seq1 INCREMENT BY 3 START WITH 5 select test_seq1.currval Error: The 'currval' operator is not defined yet for sequence…
AlexR87
  • 1
0
votes
1 answer

How to parse database data from an asp site?

I am working on a legacy web site run on asp. I need to migrate the data, like user accounts and posts, to php or ruby based web site. I got a data file with file extension of .asa. I don't know how to migrate the data into MySQL. Anyone can help?
Frankel
  • 536
  • 2
  • 5
  • 19
1 2 3
…
10 11