Discussions tagged ODBC
Sql Server - Row changed between retrieve and update
- Advice
- Last updated 2 weeks ago
- mike S replied 2 weeks ago
Sql Server 2019
PowerBuilder 2019 R3 build 2728
I'm using ODBC connection
I have a datastore, I change data and then do an update
lds_post_dates.setitem(i, "column_name", ll_value)ll_rv = lds_post_dates.update()
The base table for the datas...
SQL Anywhere 16+ Default DB Owner for alternate user
- How-to
- Last updated 3 weeks ago
- Jeff Wayt replied 3 weeks 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 ...
Ported my app from PB2019 to PB2022R2. German Umlaute like öüäß are no longer working. Database is MySQL8.0.
If i write Umlaue in a datawindow column and call dw.update() => next retrieve brings back some weird characters like 'ü'
App connects ...
Connection is busy with results for another command
- Resolved
- Issue
- Last updated 2 months ago
- Tim Bruce replied 2 months ago
Sql Server 2019
PowerBuilder 2019 R3 build 2728
app.ini connection (server X'd out)
DBMS="ODBC"DBParm = "ConnectString='DSN=XXXXX',ConnectOption='SQL_INTEGRATED_SECURITY,SQL_IS_ON', MsgTerse='Yes',DisableBind=1,DelimitIdentifier='No',TrimSpaces=1"...
OBDC Profile - Powerbuilder 2019 IDE Crash
- Issue
- Last updated 3 months ago
- Armeen Mazda @Appeon replied 3 months ago
Hello All,
I am having problems trying to create a new database profile on Powerbuilder 2019.
When I click "New Profile", just crash without any message.
I already used the repair function on powerbuilder 2019, then I completely removed PB...
Error in PB calling stored procedure
- Issue
- Last updated 4 months ago
- Andreas Mykonios replied 4 months ago
Windows 10 PB Version 6.5.1 Postgres 12psql-ODBC 12.02.01 Connection
Hi,
Error in PB calling stored procedure, The error message is Procedure has already been executed.
I have implemented a minimal use case, see the attachment.
I created the fo...
Automatically generate schema for Datawindow
- How-to
- Last updated 5 months ago
- hoshea hashub replied 4 months ago
Windows 10PB Version 6.5.1 Postgres 9.2psql-ODBC 9.02.01 Connection
Hi,
When I connect to postgres database with PB and create a Datawindow, the schema will be automatically generated before the table name.
I found that when I created a ...
Hello All
We are migrating to 64 bits enviroment (PB2022 R2)
we have a external file in dbf format
in 32 bits we are using the microsoft driver for dbf but it is only available in 32 bits
does anyone have manage to connect to a DBF file in 64 bi...
Application Communication through DSN
- Issue
- Last updated 6 months ago
- Kevin Ridley replied 5 months ago
Dear Team,
I am facing a critical issue with my power builder application. I am having a customized odbc driver which is communicating with my PB application.
I am having another Visual Studio 2022 application which is communicate with my PB appli...
Cannot retrieve stored procedure result set #2 in Powerbuilder report
- Issue
- Last updated 9 months ago
- Chris Pollach @Appeon replied 9 months ago
Hi,
In Powerbuilder 2022, I have a report fetching data from a MS SQL stored procedure returning two result sets. This works fine when connected to a SAP ASE database, but after migrating to MS SQL, it looks like only the first result set from the p...
Demo database ODBC not showing in connections list
- Issue
- Last updated 11 months ago
- Miguel Leeuwe replied 7 months 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 11 months ago
- Chris Pollach @Appeon replied 11 months 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...
I was attempting to follow the tutorial in PB2022 for PowerServer, using the Sales Demo app. The PowerServer project painter apparently only recognizes Sql Anywhere (ODBC) data source names if they are set up with the 64 bit ODBC Data Source Administ...
When creating an ODBC Configuration for PB Demo 2022, and when I click on the Test Connection button I receive an error, that it is unable to start server. I followed the steps in the Appeon doucment guide, and looking for any insight that will help...
How get access to the PB Demo DB V2017 IM?
- How-to
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Hello everyone,
I am currently doing the Infomaker fundaments curse. In order to practice I need to have access to the PB Demo DB V2017 IM.
I installed the ODBC driver and the Demo DB, however, on infomaker this is what I have on the ODB ODBC
...
Powerserver Object cannot connect to database using script and connectstring
- How-to
- Last updated 1 year ago
- Armeen Mazda @Appeon replied 1 year ago
I am using the CASE statements for setting database connection details up to PB2021 without PowerServer
Example:
Case IS_USE_SCRIPT /* Populate Database Connection from Script */ as_dbms = "ODBC" as_database = "" as_userid = "" as_dbpass = "" as_lo...
PB2019R3 Execute Stored Procedure crashes
- Resolved
- Issue
- Last updated 1 year ago
- John Fauss replied 1 year ago
We have migrated our applications from PB10/12.5 to PB2019R3. We have a lot of stored procedures being called via the Declare/Execute statements. When the process gets to the Execute statement it crashes the application.
We are connecting to MSS...
ODBC::Argument data type text is invalid for argument 1 of upper function.
- Resolved
- How-to
- Last updated 2 years ago
- Arnd Schmidt replied 2 years ago
Hi
I have a desktop application developed in PB2017 R3. It is connecting to the MS SQL database thru ODBC with connection string as below:
SQLCA.DBMS = "ODBC" SQLCA.AutoCommit = TrueSQLCA.DBParm = "ConnectString='DSN=dsn_name;UID=xyz;PWD=abc',Commi...
First)
An update toaddresses the problem that requires Dw_1.Reset() AND Dw_1.DataObject = “” to be added to the closing of each window containing a datawindow,.
Dw_1.Reset()
Dw_1.DataObject = “”
Second)
PB.ini needing Accessibility=0
...
Select varchar(max) field on SQLServer return the value truncated
- How-to
- Last updated 2 years ago
- Chris Pollach @Appeon replied 2 years ago
I select a field declared as nvarchar(nmax) from a table in sqlserver using an odbc connection (even with a native driver). The result from the select is truncated if the value in the column has more then 32676 character. I use Power Builder 2019R2. ...
- Page :
- 1