Discussions tagged MSOLEDBSQL

ADO.NET vs. MSOLEDBSQL
  1. Resolved
  2. How-to
  1. Last updated 1 month ago
  2.  Sverre Tvedt replied 1 month ago
4 replies
263 views
0 votes
Platforms: SQL Server 2022/PB 2022 32bit apps We are considering a new attempt to upgrade from PB 2022 to R3, having abandoned the previous attempt to upgrade to R2, due to the hassle with .NET Desktop Runtime 6.0 on  the client side. There are hund...
  1.   ADO.NET
  2.   Database Driver
  3.   PowerBuilder (Appeon)
  4.   MSOLEDBSQL
Sverre Tvedt Sverre Tvedt
  1. PowerBuilder
Support for Powerbuilder 2021 and new MSOLEDBSQL 18.7 Drivers
  1. Resolved
  2. How-to
  1. Last updated 2 months ago
  2.  Armeen Mazda @Appeon replied 2 months ago
1 reply
326 views
0 votes
  **EDITED TO CLARIFY PREVIOUS SUPPORT, NOT FUTURE SUPPORT** Is Powerbuilder 2021 supported for the new MSOLEDBSQL 18.7.2 drivers released on April 9th this year? Has anyone updated to the newest 18.* driver and had success with existing applicati...
  1.   Database
  2.   PowerBuilder
  3.   PowerBuilder (Appeon)
  4.   MSOLEDBSQL
Michael Quintus Michael Quintus
  1. PowerBuilder
Cannot get raiseerror from procedure called using RPC
  1. Resolved
  2. How-to
  1. Last updated 7 months ago
  2.  Arnd Schmidt replied 7 months ago
1 reply
511 views
0 votes
Hi all, I'm using RPC to call MSSQL stored procedures. local externa function on transaction object  function long PORADI_DNE(datetime DATUM,ref int SEKVENCE) RPCFUNC ALIAS FOR "dbo.PORADI_DNE" If there is  raiserror ('Error from procedure',3,1)...
  1.   RPC
  2.   MSOLEDBSQL
Aleš Vojáček Aleš Vojáček
  1. PowerBuilder
Support for MS SQL Server 2022 and new MSOLEDBSQL Drivers
  1. Resolved
  2. Misc
  1. Last updated 1 year ago
  2.  Roland Smith replied 1 year ago
4 replies
3604 views
0 votes
Hi, what are the plans for supporting MS SQL Server 2022 and Versions of the MSOLEDBSQL19 newer 19.0.0?   According to the PB Help only MS SQL Server Versions up to 2019 are supported and only the MSOLEDBSQL19 Driver Version 19.0.0 is supported. ...
  1.   Database
  2.   PowerBuilder
  3.   SQL Server
  4.   MSOLEDBSQL
Gerrit Bruns Gerrit Bruns
  1. PowerBuilder
Increase column sizes on hundreds of datawindows
  1. Advice
  1. Last updated 2 years ago
  2.  Matt Balent replied 2 years ago
4 replies
1802 views
0 votes
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...
  1.   Bug
  2.   DataWindow
  3.   PowerBuilder (Appeon)
  4.   SQL
  5.   Text
  6.   VARCHAR
  7.   MSOLEDBSQL
P Laceholder P Laceholder
  1. PowerBuilder
MSOLEDBSQL - SqlState 42000 OLE DB Driver for SQLServer Incorrect syntax near X
  1. Resolved
  2. Issue
  1. Last updated 3 years ago
  2.  Gokul Kannan replied 11 months ago
2 replies
2937 views
0 votes
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...
  1.   Compiler
  2.   Syntax
  3.   MSOLEDBSQL
Kevin Geist Kevin Geist
  1. PowerBuilder
Comparison of methods accessing SQL Server from PowerBuilder
  1. Advice
  1. Last updated 3 years ago
  2.  Armeen Mazda @Appeon replied 3 years ago
3 replies
2285 views
0 votes
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...
  1.   ODBC
  2.   OLEDB
  3.   SQL Server
  4.   MSOLEDBSQL
Roland Mühlberger Roland Mühlberger
  1. PowerBuilder
MSOLEDBSQL in PB 2019R3
  1. Issue
  1. Last updated 3 years ago
  2.  Miguel Leeuwe replied 11 months ago
6 replies
2620 views
0 votes
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:...
  1.   MSOLEDBSQL
Feng Eric Feng Eric
  1. PowerBuilder

Find Questions by Tag

.EXE .NET 6.0 .NET Assembly .NET Core 3.1 .NET Core Framework .NET DataStore .NET Std Framework 32-bit 64-bit ADO.NET AEM AI Algorithm Amazon AWS Android Apache API APK App Store App Store (Apple) Appeon Workspace Appeon Xcelerator Plug-in Architecture Array ASE Asynchronous Methods Authentication AutoBuild AutoCompiler Automated Testing Automation AutoScript Azure Barcode Base64 Batch BigData BLOB Branch & Merge Browser Bug Build Button C# C# Class Importer C# Editor C# Model generator Calendar Camera Certificate Chrome Citrix Class Client Client/Server Cloud Cluster Collection COM Command Line Compiler Compression Computed Field Configuration Controls Cookies Cordova Crash Cross-Platform Crosstab CSharpAssembly CSharpObject CSS CSV Cursor Data Database Database Driver Database Painter Database Profile Database Provider DataObject DataSource DataStore DataStore (C#) DataStore (PS) DataType DataWindow DATE DATETIME DB2 Debug Debugger Debugging Deployment Design DLL DO-WHILE Dockable Docker Documentation DOUBLE Download DragDrop Edge Edit Style Editor Elevate Conference Email Embedded SQL Emulator Encoding Encryption Enhancement Request Entity Entity Framework ERP Error Event Event Handler Event Handling Excel Exception Export Expression External Functions F# Field File File Access Filter Firefox Firewall Font FOR-NEXT Foreground Format Function Garbage Collection GeoLocation Git Graph HANA Hash Header HTML/5 HTTP/S HTTPClient Icon IDE Identity IIS IMAPI Import InfoMaker Inheritance Installation Integer IntelliSense Interface Internet Internet Explorer iOS IPA iPad iPhone IWA J# Java JavaScript JBoss JDBC JOIN JSON JSONGenerator JSONParser Kestrel Label Lambda Large File LDAP Library License LINQ Linux OS Load Balancing Localization Localized PBVM Log In Log Out Logging LONG LONGLONG macOS MAPI Maps MDI Memory Memory Leak Menu Merge MessageBox Messagging Method Migration MIME TYPE Mobile Model ModelStore ModelStore (C#) MSOLEDBSQL Multi Threading MVC MySQL n-Tier Namespace NativePDF NVO OAuth ODATA ODBC Office Offline OLE OLEDB Online Open Source OpenAPI OpenSSL Oracle OrcaScript Other Outlook Output Package Parameter Patch PayPal PB Classic PB Native PB.NET PBC PBD PBDOM PBG PBJVM PBL PBNI PBORCA PBVM PBX PDF Performance Permission PFC Picture Pipeline Play Store (Google) Plugin Popup Port POST PostgreSQL PowerBuilder PowerBuilder (Appeon) PowerBuilder (SAP) PowerBuilder Compiler PowerBuilder Runtime PowerClient PowerScript (PS) PowerScript IDE PowerScript Migrator PowerServer PowerServer Mobile PowerServer Toolkit PowerServer Web PowerServerLabel Print Properties Proxy Publish PULL PUSH Query Regression Release Renew Resize Response REST Retrieve RibbonBar RibbonBar Builder Rich Text Roadmap RPC Runtime Packager SaaS Scaffolding Script SDI SDK Security Server Service Session Single Sign-on Size SMTP SMTPClient SnapDevelop SOAP Sort Source Code Speech Recognition SQL SQL Anywhere SQL Server SqlBuilder SqlExecutor SQLite SqlModelMapper Storage Stored Procedure Subscription SVN Swagger Syntax TabbedBar TabbedView Tablet TabPage Target TE Control Testing Text TFS Theme TIME Timer TLS/SSL Tomcat TortoiseGit TortoiseSVN Transaction Transparency Trial Trigger TRY-CATCH TX Control Type UI ULONG UltraLite Uninstall Unit Test Unit Testing UNIX OS Update Upgrade Upload URL User Center User Object UWP Validation VARCHAR Variable Versioning Visual Studio Visual Studio Code VM Voice Warning WCF Web API Web Extensions Web Service WebBrowser WebForms WebLogic WebSphere WildFly WinAPI Window Windows OS WinForms Wizard Workgroup Workspace WPF XCODE XHTML XML Zoom