Discussions tagged ODBC
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
...
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...
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...
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
...
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. ...
I need to read some data from tab-separated text files with a row of column headers, where I know that certain column names will always be there, but don't know whether they will always be in the same order, or what other columns might be there. So l...
Dear PowerBuider Programmers,
this might emerge as a philosophical question, but I still hope to get some answers:
PowerBuilder allows many different ways to access Microsoft SQL Server databases from classic (client/server) PB windows applications...
I am trying to access an SQL Anywhere Database via ODBC, but it fails.
Via Nuget I can see only a SnapObjects.Data.Odbc Version 2.1.0, but not a Version 3-0-0-beta2.
While I am using this 2.1.0 (old?) version, the build-in Server throws the followi...
We have a PB 2019 R2 application connecting to a SQL Server 2016 database using the old SQL Server driver (sqlsrv32.dll). The OS is Windows 10 Enterprise. The connection is scripted as follows:
SQLCA.DBMS = lsODBCTrace + "ODBC"SQLCA.LogId = ls_...
Hi,
About the 'Database Profile Setup ODBC'
If I use Infomaker with an ODBC to a SQL server I can use the Driver-specific parameter : Database=MY_DB.
And I will only see the tables in this database.
But, if I use an ODBC to a HANA server with t...
Hello,
Environment info:Powerbuilder 2019 R2 Build 2353Database: Informix 12.10.FC13 running on Linux serverInformix client: 4.10.TC14 (32 bit) and 4.10.FC12W1 (64 bit)PB App and Informix Client running on Windows 2008 Server R2 (Service Pack 1)
ED...
PB 2019 R2 Build 2279
We have a problem using application roles with ODBC driver for SQL Server and the SELECTBLOB function:
First we connect to the sql database using "ODBC Driver 17 for SQL Server" (or 13), then we activate application role by ex...
- Page :
- 1