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
0
votes
1 answer

SQL Anywhere doesn't work on VPS

I'm trying to connect to SQL Anywhere database on external server. I'm working on VPS Linux. Following documentation when I run command ./bin32/sa_config.sh I get this error. -bash: ./bin32/sa_config.sh: Permission denied Permission are: -rw-r--r--…
miszczu
  • 1,179
  • 4
  • 19
  • 39
0
votes
1 answer

SQL Anywhere, Entity Framework 4 and Transactions

I have a process in my program that uses an Entity Framework 4 EDM. The entity context object contains function imports for calling stored procedures. The process receives a batch of data from a remote server. The batch can consist of data for…
Tony Vitabile
  • 8,298
  • 15
  • 67
  • 123
0
votes
2 answers

connect to SQL Anywhere by TCP/IP

I'm new in sql anywhere, currently I'm trying to connect using PHP. This is what I've got so far: $conn = sqlanywhere_connect ( "UID=usr;PWD=pass;ENG=serv;DBN=bd_name;COMMLINKS=TCPIP{HOST=10.1.1.189:2638}" ); SQL Anywhere is installed on another…
miszczu
  • 1,179
  • 4
  • 19
  • 39
0
votes
1 answer

SQL Anywhere 11 upgradation

I have a licensed version of SQL Anywhere 11 installed in my system. The current version is 11.0.1 48XX. I want to upgrade it to SQL Anywhere 11 version 11.0.1 56XX. I am not able to find the fix pack or upgradation installer i need for this. Can…
user182944
  • 7,897
  • 33
  • 108
  • 174
0
votes
1 answer

Does SQL Anywhere version 10 works with Entity Framework?

I see Sybase SQL Anywhere has Entity Framework provider for version 11 and 12, but I want to get it working with SQL Anywhere 10. Is it possible. Upgrading to version 11 or 12 is not possible in our environment, so we must stick to version 10. Does…
fenix2222
  • 4,602
  • 4
  • 33
  • 56
0
votes
1 answer

How to write an update statement using parameters?

I'm having trouble writing the update statement gathered from a few different classes. So let me explain what I have.. I have a Minutes.cs class which will get and set the attributes of the database public class Minute{ public Minute() { // …
melvg
  • 57
  • 1
  • 2
  • 12
0
votes
2 answers

How to change date format of a datetime object?

currently, i have a datetime object DateTime theDateTime = DateTime.ParseExact(dateAndTime, "d MMMM yyyy hh:mm tt", provider); which successfully converts it into a datetime (from a string) to become for example : 7/6/2012 9:30:00 AM How do i…
melvg
  • 57
  • 1
  • 2
  • 12
0
votes
3 answers

Unable to insert DateTime format into database

I'm unable to insert the DateTime into my database. Am i writing the statement wrongly? Apparently without the DateTime, I am able to insert into the database string dateAndTime = date + " " + time; CultureInfo provider =…
melvg
  • 57
  • 1
  • 2
  • 12
0
votes
1 answer

MySQL mobilink synchronization with SQL Anywhere

My computer configurations are MySQL-mysql-5.0.96 SQL Anywhere-11 win XP 32 bit I am trying to connect mysql with sql anywhere for mobilink syncronization but getting error while following the tutorial given at this site:…
Vijay Shegokar
  • 2,492
  • 1
  • 20
  • 30
0
votes
1 answer

SQL anywhere 5 error

I have a below block of code calling from c language. do_connect(); db_find_engine(&sqlca,NULL); //EXEC SQL CONNECT "athena" IDENTIFIED BY "amci"; dbpp_connect_40( (sqlcaptr), &__SQLV_sql_1, __SQLV_sql_2, __SQLV_sql_3, SQLNULL, SQLNULL, SQLNULL ); I…
ravi
0
votes
1 answer

Does Microsoft Jet 4.0 support 64bit integers?

I have a csv file that I'm trying to import into a Sybase SQL Anywhere database using the SABulkCopy (Sybase's version of SQLBulkCopy) class in C# .NET. The csv file's first column maps to a 64bit integer primary key value in the Sybase DB. There is…
user1197862
  • 37
  • 2
  • 7
0
votes
1 answer

When are immediate materialized views updated

I use SQL Anywhere 11. I have the following view: CREATE MATERIALIZED VIEW "DBA"."PointsAcc"( /* view_column_name, ... */ ) IN "SYSTEM" AS select sum(PL.Points) AS Sum, DP.UserUID, COUNT(*) AS cnt FROM Points DP KEY JOIN PointLine PL KEY JOIN…
klundby
  • 301
  • 1
  • 3
  • 17
0
votes
1 answer

MobiLink synchronization scripts generation

I'm working with MySQL as a consolidated database and SQLAnywhere as a remote database. I'm trying to synchronize all data using MobiLink. I've just successfully managed to run database synchronization from this tutorial:…
zbyszek26104
  • 437
  • 1
  • 5
  • 15
-1
votes
1 answer

Bi-Directional Data Sync

I have a query on bi-directional data sync. The scenario is, that we have ERP software running on a local network which is developed in PowerBuilder and the database is SQL Anywhere 16, Also, we have our cloud software which is developed in .net6…
Ajay AV
  • 21
  • 4
-1
votes
1 answer

Dual results in Query

I have a query where I am getting double the results in my line items. Here is a copy of what I have. Do I have to do the joins differently? Here is also a screen shot of what the results look like. Every line item is doubled up. SELECT ds_id as…
Bertocious
  • 13
  • 1
  • 4
1 2 3
…
38
39