Discussions tagged SQL Anywhere
No database warning (Update, Insert) during save of program code
- How-to
- Last updated 8 months ago
- Arnd Schmidt replied 8 months ago
Hello,
at the moment I'm a little bit confused:
If there is a typo at a field name of a SELECT statement I will get an error message. But I don't get an error message with an UPDATE or INSERT statement. Until now I was very sure that a message wou...
SQL Anywhere 17 gives this error but I don't see any user or builtin functions. I removed aggregate functions and IsNull() and still get the complaint. What offends?
Could not execute statement.Syntax error near 'rowid' -- Materialized view definiti...
SQL Anywhere 16+ Default DB Owner for alternate user
- How-to
- Last updated 9 months ago
- Jeff Wayt replied 9 months ago
If App_user is created to connect to SQL Anywhere that is other than DBA, granted Select on the tables, how can the table owner default to DBA without explicitly using DBA.my_table? We don't want to use the DBA account for the application.I've tried ...
Powerserver - SQL Anywhere 17 Connection cannot be established on live program
- How-to
- Last updated 1 year ago
- Sven Fischer replied 1 year ago
Hi,
I'm currently testing the Trial Version of Powerbuilder 2022 with Powerserver to evaluate this.My trouble is how to establish the connection with sqlca to the database
I'm currently using SQL Anywhere 17 32/64 Bit ODBC
I've tried doz...
Migration from Sybase SQL Anywhere to MS SQL Server.
- Advice
- Last updated 1 year ago
- Andreas Mykonios replied 1 year ago
Hi All,
We have PowerBuilder application with Sybase SQL Anywhere as the backend DB. Client wants to move to MS SQL Database, we are doing research on how we can do this migration, however we cannot find any straight forward approach. We have around...
Demo database ODBC not showing in connections list
- Issue
- Last updated 1 year ago
- Miguel Leeuwe replied 1 year ago
Like the title says, I'm having a problem with the tutorial where I started with all the demo files except for the database file as far as I could see. Either that, or when trying to connect to the ODB ODBC Database Profile PB SQLServer V2022 it just...
Chasing Random Disconnects in DB Server to Client RDS Envionment
- Resolved
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
We have a PowerBuilder app PB17 LTR which talks to SAP SQL Anywhere 17.
The app is running on a VM Server running Remote Desktop Services with upwards of 50+ users.
The database is running on a separate VM Server dedicated to the Database
The IT d...
Enhancement request: modify SQLSyntax in transactions SQLPreview event
- Resolved
- Misc
- Last updated 1 year ago
- René Ullrich replied 1 year 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 2 years ago
- Chris Pollach @Appeon replied 2 years 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 2 years ago
- Chris Pollach @Appeon replied 2 years 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 3 years ago
- David Xiong @Appeon replied 3 years 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 3 years ago
- Armeen Mazda @Appeon replied 3 years 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 3 years ago
- Chris Keating replied 3 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 4 years ago
- Gastón Clara replied 1 week 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 4 years ago
- Michael Ray replied 4 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 5 years ago
- Kelly Loree replied 5 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 5 years ago
- David Peace (Powersoft) replied 5 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 5 years ago
- Rômulo Sorato replied 5 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 5 years ago
- Chris Pollach @Appeon replied 5 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...
- Page :
- 1