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

Unexpected rounding when using ISNULL in sybase sql anywhere

I have to work with a legacy system based on SQL Anywhere 5, db access layer is in C++ using embedded SQL. The problem I have is not really a C++ problem, but embedded SQL forces us to SQL statements which cannot be dynamically generated. There are…
Doc Brown
  • 19,739
  • 7
  • 52
  • 88
2
votes
3 answers

Is it possible to connect a .NET application directly to a Sybase SQL Anywhere db file

I'm working on a .NET application to connect to an existing Sybase SQL anywhere database which is a .db file. Is it possible to connect it directly to the .db file just like how you would to an Access data file database or does it need a server to…
chris_techno25
  • 2,401
  • 5
  • 20
  • 32
2
votes
3 answers

SQL Anywhere Syntax error near @

I am working in ASA 11 with store procedures. Example: CREATE PROCEDURE "DBA"."pa_select_employ"( @cod nVARCHAR(10), @name nvarchar(15) OUTPUT) BEGIN SELECT @name=name_employ FROM EMPLOY //the line 6 WHERE…
hcovenas
  • 21
  • 1
  • 4
2
votes
1 answer

External "Hello World" Function in SQL Anywhere with Powerbuilder-generated DLL

I created a function in PowerBuilder.NET Hello World. The project compiled as Helloworld.dll, generated in C# from the PowerBuilder utility. Inside Helloworld, I made the non-visual n_cst_helloworld. Inside the non-visual, I made the object function…
Object-Oriented Disoriented
  • 23
  • 5
2
votes
1 answer

Change c# WebReference url address

Hi, I have 2 clients with 2 different servers. After generating wsdl classes I change url address for clients accordingly in SoapHttpClientProtocol consructor. from this.Url = "http://10.0.3.5:88/SomeName/dish to this.Url =…
koziol
  • 21
  • 2
2
votes
1 answer

Failed to load native dll (C:\Users\[Username]\AppData\Local\Temp\...\dbdata.dll

I'm trying to create an SAConnection into a Sybase IQ database. I'm attempting to create the connection through a simple visual studio C# application. My code fails at: SAConnection connection = new SAConnection(connString); And pops up with a…
Danzomida
  • 475
  • 2
  • 5
  • 11
2
votes
1 answer

What permissions are required for the Entity Framework to generate a model from a database?

I am connecting to a third party SQL Anywhere instance and having issues generating an Entity Data Model from an existing database. The connection is working with a basic ODBC connection, but when generating a model I am met with a "Permission…
sglantz
  • 2,063
  • 4
  • 20
  • 30
2
votes
2 answers

Cryptic SQL Error From Sybase (Error -680)

I tried to run a dynamically generated SQL query within PHP targeting an Sybase SQL-Anywhere database and I got the following error: Warning: sybase_query(): message: SQL Anywhere Error -680: Invalid expression in WHERE clause of Transact-SQL…
recursion.ninja
  • 5,377
  • 7
  • 46
  • 78
2
votes
2 answers

Can Sybase Sql Anywhere be deployed like VistaDB (or MSAccess)?

The context : My current project uses VistaDB as it really fits the main scenario: the user log into the application, selects the DB (file on HDD or Network drive), does his job, then logs off. The DB (a single file) can be copied (email, usb…
elpipo
  • 124
  • 5
2
votes
3 answers

SQL Anywhere 11 (Sybase) with Entity Framework in Visual Studio SP1?

Well, the question is pretty much in the title. I've just installed Visual Studio SP1, and now when I want to import a Entity Model from a database, it doesn't display the SQL Anywhere provider anymore. Does anyone know if there is a patch or some…
daniel
  • 1,929
  • 4
  • 14
  • 13
2
votes
2 answers

Trigger performing insert

I have to create a trigger that does not allow more than one null in a certain column (hourfinish). Here is the trigger I wrote (I am using Sybase): ALTER TRIGGER "InsertIntoCardDetail" instead of insert on DBA.CardDetail referencing new as…
Rick77
  • 241
  • 3
  • 21
2
votes
1 answer

Is it possible to authenticate a Sqlanywhere system user without creating a new database connection?

In Sybase Sqlanywhere, system users are stored in sys.sysuser. Here is an example row from the table, for the user 'dba' with the password 'sql'. user_id 1 object_id 175 user_name 'DBA' password…
Taylor Williams
  • 256
  • 4
  • 22
2
votes
1 answer

SQL Anywhere 11 - Check if event exists

I have an SQL script which creates a scheduled event: CREATE EVENT "Daily_1200PM" SCHEDULE "Daily_1200PM" START TIME '12:00' EVERY 24 HOURS HANDLER begin -- Blah blah, do some stuff here end; I would like to remove this event, if it exists. I…
JamesPD
  • 620
  • 2
  • 8
  • 22
2
votes
1 answer

Update entity with string as PK in EntityFramework and SQL Anywhere as provider

I have simple table in Sybase -- Creating table 'SimpleText' CREATE TABLE [dbo].[SimpleText] ( [Id] nvarchar(10) NOT NULL, [SimpleValue] nvarchar(120) NULL ); GO -- Creating primary key on [Id] in table 'SimpleText' ALTER TABLE…
talisker
  • 140
  • 7
2
votes
1 answer

How to add column names to the csv file created by SQL output statement?

I used this statement SELECT * FROM SalesOrders; OUTPUT TO 'e:\\output\\rule_criteria.csv' WITH COLUMN NAMES; I get an error saying 'WITH' was not expected here. Any way to resolve this? I'm using SQL Anywhere 10.
user1414843
  • 21
  • 1
  • 2
1 2 3
…
38 39