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
5
votes
4 answers

sqlanydb windows could not load dbcapi

I am trying to connect to a SQL Anywhere database via python. I have created the DSN and I can use command prompt to connect to the database using dbisql - c "DNS=myDSN". When I try to connect through python using con = sqlanydb.connect(DSN=…
Brian K
  • 61
  • 1
  • 4
5
votes
2 answers

Free tool to migrate from Sybase SQL Anywhere 12 to MS SQL Server 2008

I need to recover data from a Sybase SQL Anywhere 12 (I have an *.db file) into MS SQL Server 2008. I installed the SQL Anywhere 12 Developer kit and that allowed me to run the database and installed ODBC drivers that should have allowed me to do…
Jason Kealey
  • 7,988
  • 11
  • 42
  • 55
5
votes
6 answers

Python list of ints in prepared sql statement

My question is somewhat the same as Python list of String to SQL IN parameter but I have a list of integers. The python code I use is: ids = [1000032, 1000048] sql = 'SELECT CompNo, CompName, CompType FROM Component WHERE DeptID IN (?)' …
Martijn de Munnik
  • 924
  • 12
  • 23
5
votes
1 answer

Entity Framework code first and ironpython

Is it possible to use the Entity Framework 6 with the code first pattern and write the models in C# and in IronPython? The background is, that a few standard models are defined in the c# core, and some custom models has to be defined in…
BendEg
  • 20,098
  • 17
  • 57
  • 131
4
votes
1 answer

Can I call a user-defined function from a column CHECK constraint?

I have a user-defined SQL function that returns 1 or 0 and I want to call it from a column CHECK constraint.
Breck Carter
  • 351
  • 2
  • 5
  • 18
4
votes
3 answers

java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.BasicDataSource cannot be cast to org.apache.tomcat.jdbc.pool.DataSource

I'm running Tomcat 7.0.22 and I wrote a simple servlet that connects to a SQL Anywhere 12.0 database. When I run the servlet I get java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.BasicDataSource cannot be cast to…
user981052
  • 41
  • 1
  • 1
  • 2
4
votes
1 answer

SSIS Error: "ODBC Source" failed validation and returned validation status "VS_NEEDSNEWMETADATA"

I have an SSIS project that I have not had any issue with for the last year. I can execute the unchanged packages without issue currently from Visual Studio 2019 and as a SQL Agent Job in SSMS. However, if I open the data flow ODBC source in the…
Hslew
  • 69
  • 1
  • 2
  • 7
4
votes
2 answers

SQL Anywhere Error -157: Cannot convert '08/10/09' to a timestamp

This same question has been asked here: Getting Exception 'Cannot convert '08/10/09' to a timestamp' while connecting to Sybase Database with .Net No answer has been provided and I am unable to post comments to that thread as I am a newer user so I…
Dan Mayor
  • 105
  • 1
  • 11
4
votes
1 answer

Using named parameter only when passing integer

Currently I'm trying to work with Named Parameters using SAP Sybase SQL Anywhere 12 with dapper. The following codes runs correctly: public class Test { public int Str1 { get; set; } public string Str2 { …
BendEg
  • 20,098
  • 17
  • 57
  • 131
4
votes
1 answer

Table lock throws exception vs table lock waits for end

Currently i am wondering, why some times ADO.NET throws directly a table lock exception, when a table is locked and some times the executed statements waits, until the table is not locked any more. When does a table lock cause an exception and when…
BendEg
  • 20,098
  • 17
  • 57
  • 131
4
votes
1 answer

SQL Anywhere 11, JZ0C0: Connection is already closed

I develop am webservice based on apache tomcat 6.0.26, apache cxf 2.2.7, spring 3.0, hibernate 3.3 and sybase sqlanywhere 11. im using the latest JDBC Driver from SYBASE jconn.jar Version 6. The persistence layer is based on spring + hibernate dao,…
Alex
  • 4,033
  • 9
  • 37
  • 52
4
votes
2 answers

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 3 bytes) after ini_set

At first, I've already looked at this, this and this. I've received the following error: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 220 bytes) I'm working with php 5.4and sql Anywhere 11. The solution to this is…
Kenny
  • 177
  • 2
  • 3
  • 14
4
votes
1 answer

SQL Anywhere table length

how can I see the length of a table (in bytes) on SQL Anywhere? It's possible? Thank you
Cesar
  • 3,519
  • 2
  • 29
  • 43
4
votes
4 answers

How to generate a list of number in SQL as it was a list of comprehension?

In my case, using sql anywhere (sybase). Something similar to haskell. [1..100]. I don't know how to generate a random simple list of 1 up to 100. I only could do it doing: select 1 union select 2 union select 3 Google did not provide any sample,…
Ismael
  • 2,330
  • 1
  • 25
  • 37
4
votes
2 answers

Sybase - Changing size of "Name" column - "Illegal Column Definition" error

We have a Companies table in our database with a "Name" varchar column and its size is currently 30 characters. Our seemingly simple task of changing its size to 50 characters has turned into a bit of an issue. When trying to change it and save…
Vitoc
  • 185
  • 1
  • 9
1
2
3
…
38 39