Discussions tagged SQL Anywhere
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...
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