Discussions tagged MSOLEDBSQL
Increase column sizes on hundreds of datawindows
- Advice
- Last updated 4 months ago
- mike S replied 3 months ago
Greetings community,
In the past few months, our company migrated multiple applications from Powerbuilder 9 to Powerbuilder 2019.
We did encounter something interesting: for varchar(max) and text column types, on our MSSQL database, all datawind...
MSOLEDBSQL - SqlState 42000 OLE DB Driver for SQLServer Incorrect syntax near X
- Resolved
- Issue
- Last updated 11 months ago
- Kevin Geist replied 11 months ago
When I do CTRL L to verify my event code, I get errors that indicates MSOLEDBSQL throws a SqlState 42000 OLE DB Driver for SQLServer Incorrect syntax near 'xxx'
Yet, when I run this code connecting to this database, the code works, the imbedded sql...
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...
Hello Appeon team,
I am evaluating PB 2019R3, since PB 2017R3 is not compatible with the new driver MSOLEDBSQL.
Even if we add “DataTypeCompatibility = 80”, the values of the columns of datetime will be truncated (for example, "2021-02-02 14:50:...
- Page :
- 1