Discussions tagged ODBC
PB2022 PowerServer Project Painter only recognizes 64 bit ODBC datasources?
- New
- Issue
- Last updated 5 days ago
- Chris Pollach @Appeon replied 5 days ago
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 3 months ago
- Chris Pollach @Appeon replied 2 months 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 5 months ago
- Armeen Mazda @Appeon replied 5 months 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
- Issue
- Last updated 8 months ago
- John Fauss replied 7 months 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 1 year ago
- Arnd Schmidt replied 1 year 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 1 year ago
- Chris Pollach @Appeon replied 1 year 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. ...
Using the Microsoft Text Driver ODBC driver to read text files
- Resolved
- How-to
- Last updated 1 year ago
- Steen Jakobsen replied 1 year ago
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...
Comparison of methods accessing SQL Server from PowerBuilder
- Advice
- Last updated 1 year ago
- Roland Mühlberger replied 1 year ago
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...
SnapDevelop 2019 R3 Beta 2 - Problem with SnapObjects.Data.Odbc
- Resolved
- Issue
- Last updated 2 years ago
- Arnd Schmidt replied 2 years ago
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_...
ODBC connection to HANA server
- How-to
- Last updated 2 years ago
- Chris Pollach @Appeon replied 2 years ago
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...
PB 2019 and Informix Database Connection
- Resolved
- How-to
- Last updated 2 years ago
- mike S replied 2 years ago
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...
SELECTBLOB with ODBC SQL driver and application roles
- Issue
- Last updated 2 years ago
- Chris Pollach @Appeon replied 2 years ago
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...
Error de Conexión MYSQL cuando se despliega en la WEB
- How-to
- Last updated 2 years ago
- Kai Zhao @Appeon replied 2 years ago
Buenas Noches
Recientemente estamos trabajando con base de datos en MYSQL y hemos migrado nuestra aplicación a la WEB pero muestra el siguiente mensaje de error, cuando lo probamos en el IDE de PB con ODBC no tenemos problemas.
FUENTE DE DATOS AE...
catalog tables could not be created and are not available for use - Conexion ODBC SQLITE
- Resolved
- How-to
- Last updated 2 years ago
- Olan Knight replied 2 years ago
Buenas Tardes
Al tratar de hacer un perfil de conexion OBDC en power builder , recibo la advertencia " catalog tables could not be created and are not available for use" y luego me sale conexión exitosa.
La conexión ODBC es de una base de datos SQ...
PB 2017 R3, ODBC ASE, Stored Procedure Declare, C0038 on Variable
- Advice
- Last updated 2 years ago
- Charlie Cummins replied 2 years ago
Hello,
Running PB 2017 R3, using ODBC to connect to ASE database.
PB in-code stored procedures declares are failing on recompile the with following error (ran fine under ASE Native). C0038: SQLSTATE = ZZZZZ[SAP][ASE ODBC Driver][Adaptive Server En...
Powerbuilder with Oracle 18c using ODBC
- Resolved
- Advice
- Last updated 3 years ago
- Larry Peters replied 3 years ago
Hi. The Appeon Newsletter 2020 in January made the following comment:
Oracle Compatibility Alert for PowerBuilder UsersExisting versions of PowerBuilder are not compatible with Oracle 18c or 19c. If you are using PowerBuilder 2019, please apply MR #...
PowerBuilder 2017 support for ODBC
- Issue
- Last updated 3 years ago
- Christian Desloges replied 3 years ago
We are having several issues accessing a MSSQL Server 2016 database using "ODBC Driver 13 for SQL Server". My question is simple: Is "ODBC Driver 13 for SQL Server" supported for applications built using PowerBuilder 2017?...
- Page :
- 1