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

iAnywhere.Data.SQLAnywhere.SAException Connection error: Connection was dropped (may not be a SQL Anywhere server)

While trying to connect to SQLAnywhere (Sybase) database (C# code) from Azure ServiceFabric: await using var connection = new SAConnection(connectionString); await connection.OpenAsync(); receive iAnywhere.Data.SQLAnywhere.SAException Connection…
avj
  • 1,626
  • 1
  • 19
  • 23
1
vote
1 answer

Connect codeigniter 3 by ODBC to SQL anywhere

I want to connect to a SQL database anywhere through an odbc but it marks me this error A PHP Error was encountered Severity: Warning Message: odbc_connect(): SQL error: [Microsoft] [ODBC Driver Manager] The architecture of the specified DSN…
Felizx Fell
  • 50
  • 1
  • 5
1
vote
2 answers

ODBC Driver General error: attempted two active database requests

I'm using ASP.NET 2.0 to connect to a Sybase SQL Anywhere 5 server. And I get this error sporadically. It just happens sometimes. The error message is: ERROR [HY000] [Sybase][ODBC Driver]General error: attempted two active database…
Cristian Donoso
  • 503
  • 1
  • 4
  • 14
1
vote
1 answer

How do I resolve this error when attempting to use a Sybase connection in Oracle SQL Developer?

I have downloaded the JTDS driver referenced in this answer, I then set it up as a 3rd party JDBC Driver in SQL Developer. I Created a connection to my locally running Sybase server and tested it. The connection tested successfully! Fantastic! When…
Ridiculon
  • 323
  • 4
  • 12
1
vote
2 answers

How to export data from an ancient SQL Anywhere?

I'm tasked with exporting data from an old application that is using SQL Anywhere, apparently version 5, maybe 5.6. I never worked with this database before so I'm not sure where to start here. Does anybody have a hint? I'd like to export it in more…
Pablo Fernandez
  • 279,434
  • 135
  • 377
  • 622
1
vote
1 answer

Error connecting to SQL Anywhere 16 with php 7.1.7 (dbcapi.dll not found)

I run a IIS Webserver with php 7.1.7 and the propriate SQL Anywhere extension. Anywhere Client is installed in 32bit and 64bit version. When connecting to database with $conn =…
Fabian Knauf
  • 117
  • 8
1
vote
2 answers

Apache: How to add to the path for a virtualhost

I need to add an additional path to my Apache configuration for PHP. Ideally, it would be Serverwide but as I'm using ServerPilot it's easier to just affect the individual VirtualHosts. The Path is currently set to PATH …
AlunR
  • 455
  • 3
  • 10
1
vote
0 answers

Connecting Liquibase with SQL Anywhere 17

I already downloaded liquibase-4.0.0-beta1 and I'm looking to set it up with an existing SQL Anywhere 17 database. I've tried running the following command: liquibase --driver=com.sybase.jdbc4.jdbc.SybDriver --classpath=jconn4-4.0.0.jar…
Leandro
  • 11
  • 1
1
vote
1 answer

How to get data from SQL for weeks. First day Monday

I am from Europe. First day of the week Monday Тhis is my code: set datefirst 1; select DATEPART(wk, did_dat) as Data, sum(sum_cre) as Suma from view_didknobj1 where sas_kod between '505' and '505' and did_dat between '2019.12.23' and…
Вадим
  • 21
  • 1
  • 7
1
vote
1 answer

How to configure Sybase SQLanywhere 16 data source in spring boot?

I want to declare a data source, which is actually a Sybase SQLAnywhere 16 database. I have done the same for MY SQL using com.mysql.jdbc.jdbc2.optional.MysqlDataSource which implements javax.sql.Datasource interface.…
Srijib Sen
  • 51
  • 1
  • 1
  • 9
1
vote
0 answers

Sybase create function (Exercise)

The main task sounds like this: "Make the function of combining the name and surname so that it matches the official style ("surname, firstname") f_name(firstname, secondname). If I correctly understood the task, then when entering ("First Name",…
Vlad Paskevits
  • 388
  • 2
  • 12
1
vote
0 answers

How do I delete row in table with constraint reference in sybase?

I am using sybase's sqlanywhere17. I have tables inventory and user_inventory. I get an error when deleting a row in table "inventory": Row with identifier of 1 cannot be deleted, because it has references in table user_inventory Even though I…
dontstopbelievin
  • 11
  • 2
1
vote
3 answers

Get total length of pipe per date interval

I have a table containing pipes that are installed at a location. Installed dates are always filled in, removed dates can be NULL Type Installed Removed Length PT2 01/01/2011 NULL 2000 PT2 01/01/2011 NULL 2000 PT1…
klennepette
  • 3,176
  • 22
  • 23
1
vote
1 answer

Desktop/Webapp shared database overwriting data on duplicate key

I'm developing a webapp that shares a database with an in-production desktop app (aka I cannot modify the database, only try to mimic behaviors). The module I'm working on now will store notes into this database in the notes table. I was able to get…
Phillip Weber
  • 554
  • 3
  • 9
1
vote
1 answer

QDateTime insertion and retrival in SQLAnywhere Database

I'm trying to store and access Date and Time in a Table which is SQLAnywhere16 Database. Which Data type should be used in Qt so that it can be used for all my Qt business Logic and UI. I'm thinking to use QDateTime, so what are the Function which…
Raj G Y
  • 13
  • 3
1 2 3
…
38 39