Ok, i solved my problem like this: I extemded my SQL-Code with my own tag, so that the order-by looks like this: [ORDER-BY] order by myColumn asc [/ORDER-BY] if there is no [ORDER-BY] in the sql-code, i use my sold technique: SELECT * FROM (SELECT * FROM CustomerTable) as _orderBy...
The SQL Anywhere node.js driver currently only supports node 0.10. We are working on adding support for version 0.12 but I have no estimate on when that might be available. Disclaimer: I work for SAP in SQL Anywhere engineering....
c#,entity-framework,connection,entity-framework-6,sqlanywhere
It is important that the configuration section in the app.config does not exists, because it has a higher priority.
After some more time asking google I found the following question asked: http://sqlanywhere-forum.sap.com/questions/19449/cannot-find-the-language-resource-file-dblgen12dll The accepted answer links to http://dcx.sybase.com/index.html#1201/en/dbadmin/da-install-s-5107108.html, where is explained where the dll looks for the files. On Windows, SQL Anywhere searches the following paths relative to each location in the preceding list: . .. .\bin32 and ..\bin32...
c#,multithreading,.net-4.0,nullreferenceexception,sqlanywhere
Well, the SAConnectionPoolManager were not thread safe when multiple threads are trying to allocate/close multiple connection pools. This was fixed (so they say) in version 16.0.0.1431 and 12.0.1.3851.
c#,entity-framework-5,com+,sqlanywhere,type-library
When I tried to register the assembly through the console. It shows: An unknown exception occurred during installation: 1: System.IO.FileNotFoundException - Could not load file or assembly 'EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. It turns out that after I installed...
There are syntax errors in your query: SELECT CASE WHEN a.Column LIKE '%Moderate to severe aortic stenosis%' THEN 'Moderate to Severe' WHEN a.Column LIKE '%Severe aortic stenosis with%' THEN 'Severe' WHEN a.Column LIKE '%moderate aortic stenosis present%' THEN 'Moderate' else ' ' END FROM MyTable a Field a.Column should appear...
entity-framework,sybase,sqlanywhere
Seems like the OEM Edition of SQL Anywhere can have unauthenticated and authenticated connections. The unauthenticated ones can only read (in theory) from the database and somehow write to it (for 30 seconds after the first write, in my case the SaveChanges() call). Here's the code how to authenticate your...
sql,views,sybase,grant,sqlanywhere
You can't. From the SQL Anywhere 11 docs: "SELECT permissions on columns cannot be granted for views, only for tables". Disclaimer: I work for SAP in SQL Anywhere engineering....
c++,c++11,sqlanywhere,ultralite
As per my understanding function conn->GetLastError() returns a pointer of ULError and need to check is the return pointer is null or not. This will work for you. const ULError *error = conn->GetLastError(); if (error){} Since C++11 you can do as follows instead comparing with NULL if( error != nullptr)...
I'm not sure what version of Sybase you have but this works in Sybase 11 so I can imagine it will work in any version up too: Begin Create local Temporary table TEMP_TABLE (column1 int); //Create temp table // any other code needed to be executed if table did not...
c#,sql,version-control,sqlanywhere,revision-history
As someone who live and breathe database source control (part of amazing team at DBmaestro), I can recommend on combination of 2 methods, depending on how you run the delta. Using triggers you should save all information you need for the deployment, if it by using slow change dimension or...
django,python-2.7,connection,database-connection,sqlanywhere
Sorry, but the SQL Anywhere Django driver requires SQL Anywhere v12 or higher; you cannot use it with SQL Anywhere v11. I have confirmed that the driver uses features of the database server that were not supported in version 11. Disclaimer: I work for SAP in SQL Anywhere engineering....