Menu
  • HOME
  • TAGS

Concat Order-By string in sql dynamically

c#,sybase,sqlanywhere

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...

node.js sqlanywhere compilation/update errors

node.js,sqlanywhere

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....

Entity Framework connection factory not working

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.

Connect to SQL Anywhere - dblgen12.dll not found

c#,sqlanywhere,sybase-asa

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...

Sybase SQL Anywhere driver throws NullReferenceException

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.

Failed to generate type library for iAnywhere.Data.SQLAnywhere

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...

error in using case with like sql anywhere query

sql,sqlanywhere

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...

SQL Anywhere .NET Data Provider throws Authentication violation exception

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...

Sybase SQL anywhere 11 Grant/Revoke on column views

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++: Creating a local copy of an Object

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)...

Find if the local temporary table exists in sql anywhere and use it

sql,sybase,sqlanywhere

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...

Best practice for data version control in sql and c#

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...

I can't save data to database with Django and SQL Anywhere 11

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....