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
1
vote
1 answer

Connection to SQL Anywhere 10 *.db file

How to connect to SQL Anywhere 10 db? I have tryed the instruction written here http://www.sybase.com/detail?id=1054947 but they are way out of date. And the dll that they have provided does not work under .net 4.0 no matter that they have stated it…
Jordan
  • 530
  • 7
  • 23
1
vote
1 answer

SQL Anywhere connection error: The driver doesn't support the version of ODBC behavior that the application requested

I'm trying to connect to a SQL Anywhere 5 database (I know it's olllld!) with a .NET 3.5 app in WinXP and it works fine from a stand alone console app. But when I run the exact code in a plugin ,running off a separate AppDomain, (the only difference…
Heckflosse_230
  • 461
  • 2
  • 9
  • 18
1
vote
1 answer

Mobilink with MySQL on Linux

I'm trying to configure MobiLink to work with my MySQL database on localhost. I am using: - mysql-connector-odbc-5.1.10 - SQL Anywhere 12.0.1 Developer Edition I'm following this tutorial http://www.sybase.com/detail?id=1056497, but working on Linux…
zbyszek26104
  • 437
  • 1
  • 5
  • 15
1
vote
2 answers

PowerBuilder: Checkbox in DataWindow

I have a checkbox in the DataWindow, It can be checked and unchecked. The default value in the db is 0. When it's checked, the db value is updated to 1 and on uncheck, the value is updated to 0 again. However, I want to update the database only if…
Billa
  • 1,963
  • 5
  • 18
  • 23
1
vote
1 answer

How do I get SQL SELECT @variable = expression assignments to work like a spreadsheet?

Disclaimer: This is an "asked-and-answered question" posted in accordance with the FAQ statement that it's "perfectly fine to ask and answer your own programming question". Its purpose is to encourage members of the SQL Anywhere programming…
Breck Carter
  • 351
  • 2
  • 5
  • 18
1
vote
1 answer

How to simulate the MySQL bit_count function in Sybase SQL Anywhere?

MySQL's bit_count function is quite useful for some cases: http://dev.mysql.com/doc/refman/5.5/en/bit-functions.html#function_bit-count Now I would like to use that function in other databases, that do not support it. What's the simplest way to do…
Lukas Eder
  • 211,314
  • 129
  • 689
  • 1,509
1
vote
2 answers

SQL Anywhere 17 and PHP functions: sasql_disconnect vs sasql_close

I'm using PHP to connect to a SQL Anywhere 17 database. One of two commands can be used to close the connection. sasql_disconnect or sasql_close. At https://infocenter.sybase.com/help/index.jsp I can find very brief information…
Marcin Sknadaj
  • 11
  • 3
1
vote
0 answers

SQL error using sqlanywhere php API sasql_query()

I'm having problem executing a specific query using php API from sqlanywhere 12. It only happens with SET OPTION query.
Ismael
  • 2,330
  • 1
  • 25
  • 37
1
vote
0 answers

SQL Anywhere in PHP, can't fetch result

I am using SQL Anywhere in php, i use something like this: sasql_connect ("Uid=".$uid.";Pwd=".$password.";ServerName=".$servername.";CommLinks=tcpip(host‌​=".$ip.";port=".$port.")"); $result = sasql_query("SELECT * FROM cars"); When i…
Chris
  • 1,068
  • 2
  • 14
  • 30
1
vote
2 answers

PHP SQL Anywhere connection errors

I am having a very frustrating problem connecting to SQL Anywhere 17 from PHP 7.4.5. The OS is CentOS 7.9. I have installed the SQL Anywhere client v17. There is no Apache or web-server, PHP is in COMMAND LINE mode only! I am explicitly loading the…
Steffen Scheibler
  • 21
  • 3
1
vote
1 answer

Sybase JDBC get generated keys

In Postgres, I can write INSERT .. RETURNING * To retrieve all values that had been generated during the insert. In Oracle, HSQLDB, I can use String[] columnNames = ... PreparedStatement stmt = connection.prepareStatement(sql, columnNames); //…
Lukas Eder
  • 211,314
  • 129
  • 689
  • 1,509
1
vote
2 answers

Not able to connect Coldfusion 9 to Sybase

I am trying to add a datasource in the ColdFusion 9 administrator by connecting it to a Sybase database. I even supplied the port number as 2638 (Sybase). But I keep getting errors like: unable to connect and connection limits reached What should…
Fransis
  • 275
  • 1
  • 5
  • 15
1
vote
3 answers

SQLServer on existing update

We are planning to convert an application from Sybase SQL Anywhere to SQL Server. At SA we use a lot of "on existing update", that checks by primary key, if line exists. If true, is update (in same way if I was executing update clause). If not, it…
Zote
  • 5,343
  • 5
  • 41
  • 43
1
vote
1 answer

update value in first row of partition. sqlanywhere17

given a Table T id FKey col_value 1 1 NULL 2 1 NULL 3 2 NULL 4 3 NULL 5 4 NULL 6 4 NULL 7 4 NULL 8 5 NULL 9 5 NULL i want to Update each row with the highest id with value 1 for each given ForeignKey So my result looks…
C0nan
  • 15
  • 5
1
vote
0 answers

Exception in thread "main" java.lang.UnsatisfiedLinkError: no dbjdbc17 in java.library.path

I am trying to connect a java program to a database SQL Anywhere 17 using JDBC connection SQL Anywhere 17 installed in Windows machine. I have built a JAR to run the connection. The JAR is working in another Windows machine. I have jconn4.jar and…
Tarun teja
  • 59
  • 3
  • 7
1 2 3
…
38 39