Discussions tagged SQL Anywhere

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...
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...
  • Page :
  • 1