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
2
votes
1 answer

Value does not apply to variable in SQL Anywhere

when I try to execute this function I get a error. When I execute the command without a function and without using variables it works, therefore I think the value does not apply to my variable, the declaration or the setting of variable does not…
Ray Ban
  • 67
  • 8
2
votes
1 answer

Sybase SQLAnywhere

I just downloaded Sybase SQLAnywhere Developer Edition and installed. It looks fantastic and maintenance also very easy. Could someone let me know which engine it uses? Is it Interbase? Secondly, is there any RAM or DB size limit in this edition?…
RKh
  • 13,818
  • 46
  • 152
  • 265
2
votes
2 answers

SQL: How to format decimals, including ones less than 1

This feels like a REALLY basic question buy I have been looking around for about an hour and have yet to find a straight answer. I have a decimal number, it represents a weight, I want it rounded and formatted in a way that is considered…
SpeedOfRound
  • 1,210
  • 11
  • 26
2
votes
0 answers

Unicode characters in SQL Anywhere: VARCHAR(n CHAR) or NVARCHAR(n)

We are using SAP Sybase SQL Anywhere 16 with C#.NET and want to use unicode characters in string fields. When setting up the database with UCA collation, this already works with VARCHAR fields. Unfortunately we had to learn that the max length is…
maf-soft
  • 2,335
  • 3
  • 26
  • 49
2
votes
1 answer

Operating system compatibility for SQL Anywhere 7

Regarding which operating systems are compatible for Sybase SQL Anywhere 7 Currently i am using windows 2003 sever for Sybase SQL Anywhere 7 data base engine related operations and i wish to establish it under Server 2008 64Bit server environment.
Gayan Abeydeera
  • 67
  • 1
  • 10
2
votes
1 answer

Add up all occurances when a condition exists

I am totally stuck on the best way to write SQL code to handle a task I have to produce a report. We use Sybase ASA. It is embedded with an application. The query needs to produce the following output: Media Server | Total NUmber of Backups |…
Opethian
  • 37
  • 4
2
votes
1 answer

Want to have a SQL Server run query against a SQL Anywhere DB on another server

I have a SQL Server 2012 database on one server, and a SQL Anywhere 12 database on another server. I want to schedule a nightly select query that pulls data from the SQL Anywhere DB to the SQL Server DB. This is all easily done between two SQL…
Jack L.
  • 21
  • 1
2
votes
0 answers

C# How to open a SQL Anywhere connection alongside an Entity Framework connection

I have a C#, .Net 4.5.2 project, built in VS2012, which uses Entity Framework to connect to a SQL database. I now need to access a separate Oracle database, and have been trying to use SQL Anywhere 16 to make the connection. I know that the SQL…
Colin Plater
  • 23
  • 5
2
votes
2 answers

Remove digits from string in Sybase SQL Anywhere 16

I am looking for the best method to remove digit characters from ASCII text within Sybase SQL Anywhere 16. Is there any method of doing this which does not resort to nested REPLACE() calls, loops etc.? Example: This 1.00 is 200 a test 333 string.…
telenachos
  • 884
  • 6
  • 18
2
votes
1 answer

Tunnel ODBC queries to REST endpoint

Is there an easy way to tunnel SQL-Queries which are send to an ODBC-Driver to a restful api, without writing my own ODBC driver using C/C++? I need to do this, because i want redirect some odbc queries to a restful api. For example: |----------| …
BendEg
  • 20,098
  • 17
  • 57
  • 131
2
votes
3 answers

How to connect to Sql Anywhere 9 from C#

I have a project in which I need to get data a Database that is on Sql Anywhere v9, searching in Google I cant find to much information because its an old version(and I/the client cant upgrade the version of the database), in the few documents that…
Omar Martinez
  • 440
  • 6
  • 16
2
votes
1 answer

OleDBConnection error Database Server Not Found C#

I'm trying to connect to a remote SQL Anywhere 10 database server using the following connection string but receiving a "Database Server Not Found" error. OleDbConnection conn = new…
OM Asphyxiate
  • 329
  • 1
  • 5
  • 14
2
votes
0 answers

Sybase: Convert Binary to String in query

I am trying to retrieve a value from a sybase SQL anywhere database using PHP. The problem is, that the value ist only available in binary. When I try to SELECT the value and print it, php interprets only garbage like this: I7?J?`X but the string…
globus243
  • 710
  • 1
  • 15
  • 31
2
votes
1 answer

Upgrading EF to 6 with SQL Anywhere 17. Edmx giving invalid cast exception

I am upgrading from EF 5 to EF 6. Previously I was using SQL Anywhere 12, and now I am using SQL Anywhere 17. I upgraded EF version, upgraded SQL anywhere version, but when I build, I get this error Unable to cast object of type…
fhnaseer
  • 7,159
  • 16
  • 60
  • 112
2
votes
0 answers

Entity Framework with Sybase SQL Anywhere 16 crashes Visual Studio

I am trying to use Entity Framework with Sybase SQL Anywhere 16 and database first. I have successfully integrated SQL Anywhere into Visual Studio over SetupVSPackage. I also have added the correct data provider like this: …
BendEg
  • 20,098
  • 17
  • 57
  • 131
1 2 3
…
38 39