Discussions tagged SQL Anywhere

when i run this sql in interactive sql it trows an error You have an error in your SQL syntax; it seems the error is around: 'autoincrement, nome varchar(60) not null, sigla char(2) not null, primary ' at line 2 this is the sql create table estad...
Hello. I´m trying to delete multiple rows in a function passing an array to IN function and i made this sql :   DELETE FROM CONTRATOS WHERE ID IN (:DELETED_IDS)   Powerbuilder is returning me an error "variable reference in database statement...
I have a log in window that connects to Okta, retrieves the user profile and from there the connection string, and then uses that connection string to connect to the proper database. User A is able to log in just fine. I created a new user and assig...
What is our need: When a user logs into the app all data written to and retrieved from the database needs to be unique to their tenant. Where we are now: Our app is going from the desktop client/server to the web. Data was physically separated by ...
Hello, We recently installed SQL SA 16 and loaded our data onto this new version coming from SQL SA 9. We were going through the deployment wizard provided by the PowerServer ToolKit when we reached the part to add a transaction object. We could not...
This is the server we are using The application loads. After the password is entered these are the messages that appear and I believe in this order.   This is AEM data source. There is only 4 items that appear in the ODBC Data Source dropd...
Hello, I'm installing PB2017R3 on Windows 10 64 bit where PB12.5 has been installed with SQLAnywere 12 64 bit. However, when the installer comes to the step about SQLAnywhere, it does not list the installed engine and I don't see any way of selectin...
Hello community,we have a 32bit PowerBuilder application and use as database system ASA12 (Sybase SQL Anywhere 12) via ODBC. Now the question is, is it better to install the ASA12 driver as 32bit or as 64bit on a 64bit machine?It's not about the comp...
Hi Team,   I know this is wrong platform to ask below question, but still if anybody has advise or has experience on below topic can throw the light.   Is there any tool to migrate database from SQL Anywhere 16 to Adaptive server Enterprise? I am...
I have a PB 12.6 app using a local SQL Anywhere 12 db that pipes to an Oracle db.  Client wants to move it to a Citrix environment.  I need to have the SQL Anywhere db support multi-users.  Right now, each user has a SQL Anywhere db on their PC.  Wha...
  • Page :
  • 1