Discussions tagged ODBC

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---...
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...
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 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 ...
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...
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...
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 ...
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...
DB Connection Issues w/ Mobile deploy w/ Native Microsoft SQL Server  Summary Have not been able to deploy as mobile application and go beyond the database connection. Have tried using native and ODBC and have failed numerous times. PB2017 Help con...
I need to test to see if a database is running through a PowerBuilder application. Every time that I test the connection, and the database is down, the ODBC dialog box appears and the application just sits and waits for someone to respond to the wind...
I'm having an issue where opening any datawindow in the powerbuilder IDE will turn on ODBC database logging causing application testing to run extremely slowly. Logging is not turned on in the ODBC DSN or in the properties of the connection in th...
We are connecting to SQL Server using ODBC Driver 11. Any embedded SQL using SELECTBLOB or UPDATEBLOB truncates data at 32K, which is the default for a SQL Server driver. I have been unable to modify the default size to 1 GB, either by setting PBM...
using AppeonServer 2016 Under .net i must use ODBC cause is a INGRES database and the only way we found to do it. if we can not succed all our project will fail. When i define a DataSource in the AEM the results are    ...
Is there a way to switch off the warnings that come up - when closing script   The reason i ask is that I am writing an application that has to access several databases - sqlca - sqlcb and sqlcc So if i am actively connected to lets say the ...
Ya pude configurar todo y todo se convirtió de maravilla.  Al momento de ejecutar el ambiente web me sale este error "keyword not supported: 'dsn' "  me conecto por odbc en cliente servidor y lo hace perfecto ..  el appeon no trabaja con odbc...
Microsoft says it no longer supports SQL Server Native Client and they didn't provide a new version with SQL Server 2016. I am wondering what the future is for connecting to SQL Server. I have PB 12.5.2 and SQL Server 2016. I am using an OD...
Any issues with BLOB or CLOB columns? Thanks, Brian Prom ...
I'm not finding an entry for MySQL in the ODB170.INI file, so retrieval of identity keys isn't working. I found the following on the web somewhere: [MySQL] PBSyntax='MySQL_SYNTAX' PBNoCatalog='YES' PBTableOwner='NO&#...
  • Page :
  • 1