FAQ Database Discussion Community


Sybase SQL anywhere 11 Grant/Revoke on column views

sql,views,sybase,grant,sqlanywhere
My objective is to hide some column values to specific user or group on my views. I managed to give access to views, tables or table column with GRANT SELECT [(MY COLUMN)] ON TABLE/VIEW TO MY_USER for this query I have this error : GRANT of column permission on view...

C++: Creating a local copy of an Object

c++,c++11,sqlanywhere,ultralite
I'm an objective-C developer that's struggling with C++ code. Below is the code I have in C++: ULConnection *conn; ...... //code that builds up the connection conn->GetLastError()->GetString(value, 255); I need to create a local copy (not reference) of GetLastError(). How do I get a local reference and also check for...

Best practice for data version control in sql and c#

c#,sql,version-control,sqlanywhere,revision-history
In this question i want to figureout, what is the best practice to control versions of data in sql. We are useing a relational database (Sybase SAP Sql Anywhere). The problem is, we don't know in which layer of our software we should implement a version control system. We want...

Failed to generate type library for iAnywhere.Data.SQLAnywhere

c#,entity-framework-5,com+,sqlanywhere,type-library
What could be the reason of this error when I tried to build a c# solution with class like this: using iAnywhere.Data.SQLAnywhere; /// Specify a name for your serviced component [ ProgId( "Name" ) ] /// Add content to hosting COM+ App's description field [ Description("Name")] /// Configure component's Transaction...

Entity Framework connection factory not working

c#,entity-framework,connection,entity-framework-6,sqlanywhere
I use entity framework 6 and try to overwrite the connection string factory. I've written the following connection factory: internal class MyDBConnectionFactory : IDbConnectionFactory { public System.Data.Common.DbConnection CreateConnection(string nameOrConnectionString) { SAConnection connection = new SAConnection(ConnectionManager.GetConnectionString(nameOrConnectionString ?? "Default")); return connection; } } Than i have written my own configuration class: public...

Sybase SQL Anywhere driver throws NullReferenceException

c#,multithreading,.net-4.0,nullreferenceexception,sqlanywhere
I have the problem, that in my multithreading application, the SQL Anywhere 12 driver throws NullReferenceExceptions. The Exception is always thrown at different points, but always during opening a connection. There are a maximum of 5 open connections. The stack trace is the following: I have no idea why this...

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

sql,sybase,sqlanywhere
I want to write a procedure in SQL anywhere which can check if a local temporary table exists and if it does use it. I do not want to drop the table. I have already found a way to drop local temporary table which is: DROP TABLE IF EXISTS t;...