Stack Overflow
Stack Overflow

Questions tagged [sqlanywhere]

SAP SQL Anywhere is an RDBMS, produced by SAP. Before version 10, use [sybase-asa].

SAP SQL Anywhere is a relational database management system, produced by SAP. Before begin rebranded as SAP SQL Anywhere, the product was known as Sybase SQL Anywhere.

It runs on Windows, Mac, and some Unixes.

Some of its strengths include:

  • low administration cost
  • embedded version
  • mobile functions (specific ultra-light engine, and replication tools)

There is a dedicated forum at sqlanywhere-forum.sap.com.

581 questions
0
votes
1 answer

Unable to perform database backup using sybase central

Error: The storage control block address is invalid unable to determine disk freespace SQL Anywhere 9 Sybase Central 4.3 Windows XP How to resolve this problem? Button to choose dir is not activated. I tried also type local and network dir, both…
BlueMark
  • 962
  • 4
  • 23
  • 41
0
votes
1 answer

SQL Combining multiple rows into one row

What I am wanting to do is combine all job codes that are associated with a VhStock.No into one row. Either column WkRoDesc.Job_Code END AS WorkNeeded that has all job codes but the four listed below separated by a ' , ' Then combine those four job…
Troy
  • 3
  • 1
  • 5
0
votes
1 answer

SQL Anywhere error - Function or column reference to 'id' must also appear in a GROUP BY

I have 2 tables: test table: Column Type Nullable Primary Key -------------------------------- -------------------------------- -------- ----------- id integer …
rev2012
  • 95
  • 2
  • 9
0
votes
1 answer

Mobilink error with Syncing to Production Oracle DB Options

Ok so here is the scenario. We have two developers using the developer edition of Mobilink to sync to a consolidated Oracle DataBase using SqlAnywhere. The mobilink Version is Version 11.0.1.2331 Everything works fine in the two development…
runxc1 Bret Ferrier
  • 8,096
  • 14
  • 61
  • 100
0
votes
1 answer

Error: Database server connection limit exceeded in SQL Anywhere. Does this error has anything to do with calling dispose()?

As the title suggesting, I've been doing some research on the cause of this error. Then I saw this which primarily suggesting that it is most likely related to license number. However, at the very bottom there was a reply suggesting that calling…
LulalaBoss
  • 127
  • 1
  • 9
0
votes
1 answer

External Environment could not be started - CLR on Sybase's Interactive SQL

I'm having an issue figuring out how to start an external environment within Sybase Central's Interactive SQL. The executable, dbextclr12.exe has not been manipulated since 2010, so I know I didn't accidentally alter that. Here is the call: START…
Object-Oriented Disoriented
  • 23
  • 5
0
votes
0 answers

SQL Anywhere 11: Select brings inconsistent results when database cache is low

We have a complex sql query with five subquerys and the group by clause. If I restrict the database server cache to 16m (with the option "-ch 16m") we get randomized different results from the same sql query (these issue is reproducible on different…
sebyz
  • 53
  • 7
0
votes
1 answer

Sybase sql anywhere sync a Database view(pull from consolidated to remote)?

I am trying to set up a synchronization model to sync my consolidated Oracle database with a remote SQL Anywhere database. I have a couple Views on the consolidated Oracle database that I want to pull into the Sql Anywhere database as tables. I…
runxc1 Bret Ferrier
  • 8,096
  • 14
  • 61
  • 100
0
votes
4 answers

How can I delete pairs of matching rows?

I have a table which contains sales order data (order number, product number, sales price, etc.). However, the table is littered with corrections and various other invalid data. One of the main issues is that corrections were entered by adding a new…
Ben S
  • 68,394
  • 30
  • 171
  • 212
0
votes
1 answer

CHECK constraint on a table

I want to modify the following DDL to add CHECK constraints so that the manager of a store(FK employee_number is store table) works at the same store (FK store_code in employee table table) and a store supplies all the products if its type is…
zan
  • 355
  • 6
  • 16
0
votes
4 answers

adding CHECK to impose constraints on more than one table

I want to modify the following DDL to add CHECK constraints so that the manager of a store works at the same store and a store supplies all the products if its type is 'local'. Can anyone help? CREATE TABLE employee( employee_number CHAR(5) NOT…
zan
  • 355
  • 6
  • 16
0
votes
0 answers

Sybase SqlAnywhere 12 connection hangs after first connection attempt is successful

I'm experiencing what I believe is an environment issue, but I'm at my end as far as debugging it. I'm attempting to connect to a Sybase SqlAnywhere from a Rails 3.2.13 app on the same network. This is working from a rails 2.8 app, but I…
Brandon Burke
  • 26
  • 2
0
votes
3 answers

Adaptive server anywhere ASA SqlAnywhere 8.0 ODBC driver

Well, I've searched the interwebs like crazy and I am unable to find this driver. I am trying to convert data from a client's database that was built using the ASA 8.0 engine. ASA 8 has been out of support since 2008. The software company that…
QuietSeditionist
  • 703
  • 4
  • 8
  • 18
0
votes
1 answer

Is there a way to query for database names within an SQLAnywhere Service?

I have launched an SQLAnywhere v12 service instance with the following command: "C:\Program Files\SQL Anywhere 12\Bin64\dbsvc.exe" -as -s auto -t network -w TestEmpty12 "C:\Program Files\SQL Anywhere 12\Bin64\dbsrv12.exe" -n TestEmpty12 -x…
Hobo Joe
  • 181
  • 14
0
votes
2 answers

How do I Connect to a Sybase Database from Windows CE using .Net?

I need to make a connection to a Sybase (SQL Anywhere) database in a Windows CE app over the network (wifi). I'm hoping someone in the SO community has done before and can't point me in the right direction. There doesn't seem to be a lot of…
Robert H.
  • 5,864
  • 1
  • 22
  • 26
1 2 3
…
38 39