Discussions tagged ODBC
SnapDevelop 2019 R3 Beta 2 - Problem with SnapObjects.Data.Odbc
- Resolved
- Issue
- Last updated 1 week ago
- Arnd Schmidt replied 1 week 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 1 month ago
- Chris Pollach @Appeon replied 1 month 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 3 months ago
- mike S replied 4 months 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 6 months ago
- Chris Pollach @Appeon replied 6 months 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 6 months ago
- Zhao Kai @Appeon replied 6 months 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 8 months ago
- Olan Knight replied 8 months 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 11 months ago
- Charlie Cummins replied 11 months 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 11 months ago
- Larry Peters replied 11 months 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 1 year ago
- Christian Desloges replied 1 year 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?...
Risks of keeping apps on Power Builder 10.x /12.x platform
- Advice
- Last updated 1 year ago
- Armeen Mazda @Appeon replied 1 year ago
We have number of applications in Power Builder 10.x and 12.x with SQL server as back end database using ODBC connections. These are built using Power builder Classic. I know PB 10.x/12.x is not supported anymore. I need an advice from experts on wha...
Problem with reading large text columns in Postgresql from PowerBuilder
- Resolved
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
PB 2019 Build 2082 using PostgreSQL 10.8
We have a problem reading values from column that is text data type with a length over 32768 characters. If the length of text is bigger we get only first 32768 characters
We configure ODBC for database ...
Hi Team,
We deployed our application to web recently and we are facing the following error when we try to run the application through web. We were able to connect to the database while configuring the profile.
---------------------------Error---...
changing to ODBC for sql server 17. application/debugger crashes on selectblob
- Issue
- Last updated 1 year ago
- Chris Low replied 1 year ago
because of the need to disable TLS 1.0, i'm moving to the latest sql driver that supports tls 1.2 (unless anyone has better suggestions)
SQLCA.DBParm = "ConnectString='DSN=" + ls_dsn + ";UID=" + sle_userid.text + ";PWD=" + ls_password +"',DelimitIde...
How to suppress ODBC login window after incorrect password?
- Resolved
- How-to
- Last updated 1 year ago
- Jonathan Meltzer replied 1 year ago
I have just changed our application to use a DSN-less connection to ODBC, and I am struggling with how to trap an incorrect password condition. Previously (our current production code), we had an OLE DB connection. We have a login screen, and if th...
Powerbuilder 2017 R2 Citrix ODBC
- Resolved
- How-to
- Last updated 1 year ago
- Prasad Pati replied 1 year ago
Powerbuilder application deployed to Citrix works great, except connecting to Excel file. I am using ODBC to connect to excel file to import data into datawindow, this works great on desktop but in Citrix client C: drive becomes \\Client\c$. getting ...
ODBC Driver 17 for SQL Server problems with updating datawindow
- Resolved
- Issue
- Last updated 1 year ago
- Chad Bailey replied 1 year ago
I need the ODBC Driver for SQL Server so I can use encryption TLS 1.2. I've encountered two problems with inserting and updating datawindows.
I have tables and columns where there is a column on a table that cannot be null but has a database defau...
Postgresql Not Showing Schema Qualified Table / View Names
- Resolved
- How-to
- Last updated 2 years ago
- jeff hersey replied 2 years ago
Windows 10
PB 2017 R3
Postgresql 9.6
ODBC Connection
-----
Hi,
When connecting to Postgresql, table names are not schema qualified. PB assumes the user that I am connecting with, is the schema / owner of all tables.
I have confirme...
Values instead of ? while displaying error
- Resolved
- How-to
- Last updated 2 years ago
- René Ullrich replied 2 years ago
Hello,
Using PB 11.5, PostgreSQL 10
When showing error while updating dw / ds, it shows ? in places of field values. It would be better if values are shown, to identify and correct those values. We used to see values while using SQL Server, but ...
Unable to Connect ODBC after Web Deployment
- How-to
- Last updated 2 years ago
- Zhao Kai @Appeon replied 2 years ago
Installed Appeon PB2017 Universal Ver 2017 Build 1858 with PowerServer
Using 32 Bit SQL Anywhere8.
Perfectly works in Powerbuilder Environment
When Deployed on Web (same) will not connect to ODBC after (Tested perfectly in ODBC Connectivity befor...
- Page :
- 1