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
3
votes
2 answers

How to solve log slowness with or without NoSql

I am having a problem regarding a Log Searching Speed and Disk Size. It is extremely big, it has about 220 millions rows and 25 gigabyte disk size and takes several minutes to fetch some selects. How does it work? The log is saved in the database…
Ismael
  • 2,330
  • 1
  • 25
  • 37
3
votes
3 answers

How do I check if a temporary table exists in SQL Anywhere?

I want to write a SQL IF statement that checks whether or not a local temporary table exists, but those kinds of tables are not recorded in the SQL Anywhere system catalog.
Breck Carter
  • 351
  • 2
  • 5
  • 18
3
votes
1 answer

Decode information from Sybase transaction log file

I am looking for a way to decode the information stored in a Sybase database transaction log file (all queries issued to the database). Can someone please help with this?
Gleeb
  • 10,773
  • 26
  • 92
  • 135
3
votes
2 answers

How does pyodbc determine the encoding?

I'm fighting Sybase SQL Anywhere 12 together with Python (and Twisted) for several weeks by now and I even got my stuff working. There's only one annoyance left: If I run my script on CentOS 5 with a custom Python 2.7.1, which is the deployment…
hynek
  • 3,647
  • 1
  • 18
  • 26
3
votes
1 answer

Completely unloading a JDBC driver in Java

I have an application that uses Java, mybatis, and SQL Anywhere. Because of some circumstances, I have to manually load in the SQLA driver jar at runtime. I got this working with this code: public static URLClassLoader ucl; public static…
Troncoso
  • 2,343
  • 3
  • 33
  • 52
3
votes
1 answer

CodeIgniter 3.1.10 : Cannot connect to remote database by DSN using ODBC

I have a problem to connect to remote database by DSN using ODBC driver in CodeIgniter 3.1.10 as mention above. The DSN has been created in ODBC Data Source Administrator. The problem occurred when I want to update the system from CodeIgniter 2.2.3…
Shafiq Khalid
  • 81
  • 1
  • 2
3
votes
1 answer

How to connect remotely with Sybase SQLAnywhere.SAConnection?

I'm trying to connect with .net to a remote sybase sql anywhere database. I don't see much info online how to connect, mostly ODBC or DSN files. I tried this connection string: Data Source=myserver.com;Port=2638;Uid=myuser;Pwd=mypass Which gives…
Yisroel M. Olewski
  • 1,560
  • 3
  • 25
  • 41
3
votes
2 answers

Insert or Update in Sybase SQLAnywhere

How can I insert a row in database (Sybase SQL Anywhere 12.5) if it does not exist, and update if it exists? I'm trying following: $stmt = $conn->prepare('INSERT INTO customer_info (user_id, fname, lname) VALUES(:user_id, :fname, :lname) ON…
user966582
  • 3,225
  • 4
  • 32
  • 33
3
votes
1 answer

sql anywhere 5.5 database connect to sql anywhere 12

I have a database file created in sql anywhere 5.5 and I need it to connect to sql anywhere 12. I tried it but it won't accept it, saying that: "This database was created on an older version of sql anywhere"
Redi
  • 163
  • 1
  • 10
3
votes
2 answers

Inno Setup LoadStringFromFile fails when file is open in another process

To check to see when a database (SQL Anywhere) is fired up and ready to receive requests I am outputting the database message window to a log (text) file and then attempting to read this using LoadStringFromFile, which I then search for specific…
Robert Wigley
  • 1,917
  • 22
  • 42
3
votes
1 answer

Session Isolation Issue with local SQL Anywhere Database

I am migrating an existing set of applications from Win XP to Win 7. We have a 3rd party application which is launched by and runs in the user’s session which accesses a local SQL Anywhere 9 database via ODBC (launched on demand using dbeng9). On…
bobcat1506
  • 31
  • 2
3
votes
2 answers

Why does SQL Anywhere ignore the @ named parameter?

I am using Dapper to query a SQL Anywhere Datasource, and I am getting an error that makes it seem that the "@" prefix for my where clause value is ignored. Double balance = qb.Query("select end_balance_amt from…
Israel Lopez
  • 1,135
  • 3
  • 11
  • 25
3
votes
1 answer

show all foreign keys - SQL Anywhere

Can anyone tell me how to list all the foreign keys in a SQL Anywhere database ?
WinSupp
  • 361
  • 2
  • 6
  • 20
3
votes
2 answers

How recover sybase database (unknown db version)

I have a database file (*.db) that need to be recovered. The bad is, the end-user have null idea of the version of the database. Not know the password. The original developer is lost. The computer where was installed was formatted. We have not…
mamcx
  • 15,916
  • 26
  • 101
  • 189
3
votes
1 answer

Node.js and node-sqlanywhere - No Connection Available

I have been trying to use node-sqlanywhere to query my Sybase database. However, I cannot seem to be able to connect to the database. var sqlanywhere = require('sqlanywhere'); var sqlanywhere_conn = sqlanywhere.createConnection(); var…
Antoine Cloutier
  • 1,330
  • 11
  • 23
1 2
3
…
38 39