Discussions tagged ODBC

Hello to all users of this forum.I would like to ask you if any of you have encountered a problem similar to mine?I use three versions of PowerBuilder in my work: 11.5, 19 R3 and 22 R3The problem occurs only in version 22 and consists in the fact tha...
1) My PowerBuilderapplication crashing whenever user leaves it idle for sometime, this started happening after SQL Transaction object DBMS changed from MSS to MS Native Client, what could be the reason?2) Which is the preferred connecivity for PowerB...
Chinese characters couldn't be displayed when querying a DB2 table in PowerBuilder. Could someone help on this? Thanks.  It could be displayed when querying in DB2 command windows....
Hi, We have stored icon.bmp stored as a blob in MSS DB, and we are trying to fetch that file in code but blob is able to fetch only 32767 bytes data. We tried adding PBMaxBlobSize in dbparams through ODBC connections, but it doesnt helped. Is their...
Hi there,Currently we use ODBC to connect to SQL Server 2019/2022, but we want the best possible performance and as such we're looking for the best practice in this regard. We're using Powerbuilder Version 2022, Build 1878. Thank you in advance for...
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...
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 ...
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"...
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...
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...
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...
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...
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...
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...
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...
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 ...
  • Page :
  • 1