Discussions tagged SQL Anywhere
We have a PB 2017 app accessing a SQLANywhere Database which has the character set for CHAR types as windows-1252 (its an old app) but NCHARS are UTF8. The issue is the SQL ANywhere SQL processor automatically converts the SQL syntax to the CHAR for...
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...
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 ...
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...
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...
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...
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...
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 (...
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...
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...
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...
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?...
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 ...
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...
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 ...
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...
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...
- Page :
- 1