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

C++: Creating a local copy of an Object

I'm an objective-C developer that's struggling with C++ code. Below is the code I have in C++: ULConnection *conn; ...... //code that builds up the connection conn->GetLastError()->GetString(value, 255); I need to create a local copy (not…
user1107173
  • 10,334
  • 16
  • 72
  • 117
2
votes
1 answer

synchronize joomla mysql and powerbuilder sql anywhere database

Hallo! I need to synchronize 2 Databases. I have a Windows 2000 Server with Xampp (schoolserver). Do you know some ways to realize this? I thought following: 1.Write the data in the php script or c# script 2. let something like a cronjob(dont know…
Umit
  • 323
  • 1
  • 4
  • 11
2
votes
2 answers

Find if the local temporary table exists in sql anywhere and use it

I want to write a procedure in SQL anywhere which can check if a local temporary table exists and if it does use it. I do not want to drop the table. I have already found a way to drop local temporary table which is: DROP TABLE IF EXISTS t; I have…
Ankur Patel
  • 1,413
  • 8
  • 14
2
votes
2 answers

database encryption questions

We are using Sybase SQL Anywhere 11. We need to encrypt some of our tables in our database. I followed the instruction and did it. We selected the "strong" option with encryptionKey and AES256_FIPS algorithm. But there are something I am not clear…
5YrsLaterDBA
  • 33,370
  • 43
  • 136
  • 210
2
votes
2 answers

Connect to SQL Anywhere - dblgen12.dll not found

I try to connect to a SQL Anywhere 12 database with the iAnywhere.Data.SQLAnywhere.v4.0.dll. On the database server this connection is successful, however on any other PC's I get the error Language Ressourcefile not found
Florian
  • 1,827
  • 4
  • 30
  • 62
2
votes
1 answer

What does the Sybase SQL Anywhere -O (uppercase) switch do?

I recently needed to recover a database without backups or a transaction log and discovered the "-O" switch which, according to http://nntp-archive.sybase.com/nntp-archive/action/article/%3C3850ECE1.F29E6FBC@ictsoftware.de%3E, "is used for recovery…
David Murdoch
  • 87,823
  • 39
  • 148
  • 191
2
votes
1 answer

Node.js driver for SqlAnywhere - Prepared statements exceeded

I am using the node.js driver for SqlAnywhere. I am getting the "Resource governor for 'prepared statements' exceeded" error. Initially, I was executing my queries like this: connection.exec(myQuery, myArgs, myCallback); where myQuery would look…
Antoine Cloutier
  • 1,330
  • 11
  • 23
2
votes
1 answer

how to change db user name and db group name in Sybase Anywhere 11

all! I have a db with tables User and Group, which represent entities in some application. But at the same time there are database users and database groups with the same names. I need to anonymize the database. It's easy to change db tables, e.g.…
Illia Levandovskyi
  • 1,228
  • 1
  • 11
  • 20
2
votes
2 answers

error in using case with like sql anywhere query

I want to use like in case statement and search string from a particular colmun if any part of that string contains 'Moderate to severe aortic stenosis' THEN instead of full string I want to display 'Moderate to Severe' if any part of that string…
Jim
  • 91
  • 2
  • 11
2
votes
0 answers

I need to query the table to retrieve the domains but also filter it so that any subdomains are removed

In a SQLAnywhere 11 database, I have a string field called "domain" that contains data that looks like: stats.ebay.com 103814.agchurges.org I need to query the table to retrieve the domains but also filter it so that any subdomains are…
Amit
  • 21
  • 1
2
votes
3 answers

Starting a database connection with sqlanydb inside a fork

Based on an example for forking, I build up this little script: #!/usr/bin/env python # -*- coding: utf-8 -*- import sqlanydb import os def child(): conn = sqlanydb.connect(uid='dba', pwd='sql', eng='somedb_IQ', dbn='somedb') curs =…
frlan
  • 6,950
  • 3
  • 31
  • 72
2
votes
2 answers

Introspecting IDENTITY columns

For a table such as: create table foo (id int identity primary key) I would like to query the system tables to determine that id is in fact an IDENTITY column. The closest thing I found was: select tc.max_identity from systabcol tc join systab t on…
Rafael Kitover
  • 967
  • 10
  • 13
2
votes
1 answer

Decrypting AES in SQL Anywhere 16 encrypted in C# and vise versa

I have this peace of code that encrypts stuff using AES, to be more precise Rijndael algorithm to mimic (http://dcx.sybase.com/index.html#sa160/en/dbreference/encrypt-function.html) the behaviour of SQL Anywhere 16, for sake of examples simplicity…
Valdas
  • 368
  • 4
  • 14
2
votes
1 answer

Sybase "Not enough values for host variables" with multiple SETs

When executing a query with more than one parameter used to SET local variables, I get this error: iAnywhere.Data.SQLAnywhere.SAException (0x80004005): Not enough values for host variables I get the same error using either OdbcConnection or…
xinux
  • 967
  • 8
  • 14
2
votes
2 answers

How to search in sql for hour/minutes?

I have to search all rows with a filter with specific hour and minute. Example: 26/05/2009 - 16:00 26/05/2009 - 17:00 10/11/2009 - 09:00 10/11/2009 - 10:00 10/11/2009 - 11:00 10/11/2009 - 12:00 I want all rows with hour/minute "17:00" and "18:00".…
Ismael
  • 2,330
  • 1
  • 25
  • 37
1 2 3
…
38 39