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

SQL Error in SQLAnywhere with Ultralite Database on Windows CE 5.0 - VB.net

We are deploying a SQLAnywhere solution on Windows CE 5.0 devices and are running into an error in our first SQL statement. Definitions are... Dim dbf As String = "dbf=\Program Files\sfpwarehousescanner\BRAINY2_remote.udb" Public conn As…
Nate Bunney
  • 2,418
  • 2
  • 22
  • 31
2
votes
2 answers

SQL Anywhere linux odbc SQL_HANDLE_HENV error

I've got a linux server running RStudio, and I'm trying to connect to an SQL Anywhere database. I have the drivers installed and configured, and I can connect using iSQL. When trying through RStudio, I continually get this error: Error:…
clarkwray
  • 23
  • 2
2
votes
1 answer

Python and SQL Anywhere 17 trouble with "Could not load dbcapi"

I installed SQL Anywhere 17 client. I ran /opt/sqlanywhere17/bin64/sa_config.sh And still have problem with sqlanydb.InterfaceError: ('Could not load dbcapi. Tried:None,dbcapi.dll,libdbcapi_r.so,libdbcapi_r.dylib', 0) #!/usr/bin/python3.6 # -*-…
user9733940
2
votes
2 answers

Python + Twisted + sqlanydb = abort()

I'm using Twisted 11 together with SQLAnywhere 12 via the official sqlanydb driver. Generally, it works fine. But occasionally the application crashes with an abort on the first query. If one query worked, all following work too. However my tests…
hynek
  • 3,647
  • 1
  • 18
  • 26
2
votes
3 answers

Is there a way to connect VSCode to an SQL Anywhere database?

I have seen extensions that allow you to connect to a MySQL database, PostgreSQL, Oracle, etc ... But I have not found a way to connect to an SQL Anywhere database (or to connect to an ODBC created in the system). Does anyone know how to do…
BraveOtter
  • 114
  • 1
  • 12
2
votes
1 answer

Sum values of each element by hour from date to date in SQL

I was searching a lot, but I could not find the answer. Maybe someone can give me some hints: I have a table that contains following columns and data (just an example): +-------+------------------+----+--------+--------+ | Type | InsertDate |…
KonradR
  • 43
  • 7
2
votes
2 answers

Sap.Data.SQLAnywhere.SAException: Cannot find the language resource file (dblgen17.dll) when connecting to Sybase SQL Anywhere using .NET

I am trying to establish a connection to a Sybase database, using Sap.Data.SQLAnywhere. Using an SQL Anywhere client works perfect from a workstation, but I am having some trouble running the code within an Azure Function. This is the beginning of…
swaglord mcmuffin'
  • 236
  • 1
  • 11
2
votes
0 answers

Disable quotes in sql views, procedures, functions saved with sybase central

we have updated our database from sqlanywhere 11 to 16. Unfortunately after the update all views, procedures, functions in sybase central have quoted column names. f.e. SELECT "customer_id", "customer_name", "customer_nr" as "cNr" from "customer" Is…
tbr
  • 61
  • 2
  • 5
2
votes
1 answer

Using like statement in odbc connection

Is there a way to use a LIKE statement using an ODBC connection in .net? I have tried everything I could think of, yet I always get a SQL exception. SELECT field FROM table WHERE fieldName LIKE '%SOME_STRING%'; string sql = "SELECT field FROM…
Dan
  • 1,222
  • 2
  • 17
  • 33
2
votes
2 answers

How to calculate the hash of a row in SQL Anywhere 11 database table?

My application is continuously polling the database. For optimization purpose, I want the application to query the database only if the tables have been modified. So I want to calculate the HASH of entire table and compare it with the…
new2db
  • 31
  • 3
2
votes
1 answer

search entire Sybase database for a string of data

I have a Sybase database and SQL Anywhere 16 for querying data. I need to find some example pieces of data in the database. There are hundreds of tables with unhelpful names. I'm not a Sybase expert, although I do know the SQL language (I'm a SQL…
Conrad S.
  • 774
  • 4
  • 10
  • 19
2
votes
1 answer

get the PK right after an insert statement ODBC SQL Anywhere

I do have this insert statement over a SQL Anywhere database, for the insert I use ODBC and this is a little snippet of the sentence(just an example) cmd_ex.CommandText = @" insert into tabla (numero1, numero2, numero3,…
Pablo Tobar
  • 614
  • 2
  • 13
  • 37
2
votes
0 answers

How to connect to SQL Anywhere database from linux?

I want to access to a SQL Anywhere database which is on another server. I can do it easily from Windows, but I need to do it from Debian now. All of this in php. Windows side : I have installed SQL anywhere driver from…
Nihiora
  • 21
  • 1
  • 5
2
votes
1 answer

Laravel sql anywhere connection error in ubuntu apache

The error text is : sasql_connect(): The SQLAnywhere client libraries could not be loaded. Please ensure that libdbcapi_r.so can be found in your LD_LIBRARY_PATH environment variable. I get this error when I run the code as a Laravel Job. However,…
muhammed safa yaşar
  • 31
  • 1
  • 4
2
votes
1 answer

Extracting SAP SQL Anywhere .db/.log database files with free unix tools?

I've recently gotten a copy of a SAP SQL Anywhere 12.0.1.3152[1] .db and .log file. I don't have access to the source database, only these two files. This is an ARGUS database of public records I'd like to make publicly available (via BigQuery).…
Sai
  • 6,919
  • 6
  • 42
  • 54
1 2 3
…
38 39