Discussions tagged SQL Anywhere
Enhancement request: modify SQLSyntax in transactions SQLPreview event
- Resolved
- Misc
- Last updated 2 months ago
- René Ullrich replied 2 months ago
Hi all, have a happy new year!
I could not find another way to post an enhancement request for future PB versions, so I'll leave it here. If there is a better way to do so, please let me know.
We develop and maintain a quite large c/s application (...
SQL AnyWhere example database
- Resolved
- How-to
- Last updated 8 months ago
- Chris Pollach @Appeon replied 8 months ago
Hi guys,
I am completely new to Powerbuilder and I want to follow the self-guided tutorial on Appeon's website.
It requires me to download SQL Anywhere 17, which I have done, and get the EAS Demo db vnn example database that comes along with SQL A...
SQL Anywhere Engine not detected even though it is installed
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Hi,
I am trying to install PowerBuilder 2019 R2-2353 and I want to be able to use the Demo apps that come with the install.
I have installed SQL Anywhere 17 on my machine as well.
During the installation PowerBuilder is not picking up any engine a...
load sqlselect from model without params
- How-to
- Last updated 1 year ago
- David Xiong @Appeon replied 1 year ago
is it possible to load a sqlselect from a model without params?
I have this structure:
[SqlParameter(name: "first", dataType: typeof(int))][SqlParameter(name: "second", dataType: typeof(int))][FromTable("mytable", Schema = "DBA")]
[SqlWhere("...
Hi Folks,
My application is on PB 2017 R2 and its running on windows server 2012 R2 OS. Application is connecting with local DB which is in SQL anywhere and remote database which is in SQL server.
This application is basically fetching the files fr...
Demo DB files are where?
- Resolved
- How-to
- Last updated 1 year ago
- Armeen Mazda @Appeon replied 1 year ago
When I installed 2019R3 I didn't have SQLAnywhere installed. I remember a message box coming up and informing me of this. Did the .DB files get copied to the install folder somewhere? If so, where?...
Sybase database recovery from complete log (no backup)
- Resolved
- Advice
- Last updated 2 years ago
- Chris Keating replied 2 years ago
Hi all.
A customer of mine, yesterday, performed a bad processing with our PB application on a Sybase SQL Anywhere 10 database and unintentionally deleted a lot of data in various tables. He has no backup of the db (not to mention) but the database ...
Silent installation of PowerBuilder 2017
- How-to
- Last updated 2 years ago
- Julie Jiang @Appeon replied 2 years ago
Hello,
I'm trying to install Powerbuilder 2017 silently onto Windows 2016, however I can see the pre-requisite is SQLAnywhere2017.
Installing PB manually I can decide NOT to install SQLAnywhere, so wondering what's the reason behind this being requ...
Need SQL Anywhere patch v8.0.3 for SA Studio 8.0
- Resolved
- Issue
- Last updated 3 years ago
- Michael Ray replied 3 years ago
Summary: server down, lost files.
Details: Trying to recreate production environment for database network server. Have the purchased disc for SQL Anywhere v8.0 and the patch for v8.0.2, but need patch for v8.0.3. Can anyone direct me or provide the ...
Appeon Training How to get the a Trial Version version of SQL Anywhere that works with PB2019
- Resolved
- Advice
- Last updated 3 years ago
- Kelly Loree replied 3 years ago
I am trying to using the Appeon training material and need to use the trial version of SQL anywhere , but there is only one option for trial version and it is 17.0.4.2053 which is incompatible with PB 19 as per message that I get which says "SQL vers...
sql syntax error
- Resolved
- Issue
- Last updated 3 years ago
- David Peace (Powersoft) replied 3 years ago
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...
How to use array in IN clause?
- Resolved
- Issue
- Last updated 3 years ago
- Rômulo Sorato replied 3 years ago
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...
Connection cache name cannot null - Getting this error although I have set this value
- Resolved
- Issue
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
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 options do we have to create a multi-tenant web app using SQL Anywhere 16 on PB2019?
- Resolved
- Advice
- Last updated 3 years ago
- Armeen Mazda @Appeon replied 3 years ago
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...
Running PowerBuilder 2019 Universal. Cannot connect to current database
- Issue
- Last updated 3 years ago
- Arthur Foux replied 3 years ago
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...
No SQLAnywhere engine listed in PB2017R3 setup
- Issue
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
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...
ASA12 Runtime installed as 32 or 64 bit?
- Advice
- Last updated 4 years ago
- Eric Freudenberg replied 4 years ago
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...
Migration tool for SQL Anywhere to ASE
- How-to
- Last updated 4 years ago
- Narayana Bhat replied 4 years ago
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