Skip to Main Content
HCL Domino Ideas Portal

Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino Page

Status Needs Clarification
Workspace Domino Designer
Created by Guest
Created on Jul 23, 2018

Update the existing LS ODBC method to keep up with the current environment

Limitation 1 : LS ODBC cannot work on Notes Client installed on Mac OS

Limitation 2 : Does not return error generated by the target database, instead a generic LS:DO error is returned.

I would be happy to use other alternative for Domino to write to other relational databases, but AFAIK some sort of ODBC driver is needed.

  • Attach files
  • Guest
    Reply
    |
    Mar 15, 2023

    I don't think that I created this but I do have some experience in using LS ODBC so I thought I weigh in.

    Personally I think that using JDBC meant a more complicated setup. You would need to find the jar file containing said JDBC driver (Any clue on which one to use ?), wrap it on a java library and possibly use LS2J if you are only proficient in lotuscript.

    If JDBC is indeed the way forward then at least make it so that using it is as easy as using LS:DO. This would most likely mean exposing the corresponding class and method to lotuscript.

    As for why I use LS:DO ? Well, primarily for integration to other system that require writing into a relational db. I have also use this extensively to export Notes data into relational db.

    Tinus Riyanto - Prisma Global Solusi

  • Admin
    Thomas Hampel
    Reply
    |
    Mar 14, 2023

    No plans to implement ODBC support for MacOS. JDBC is the preferred solution in your situation.
    If this is not solving your situation, can you please explain why it needs to be ODBC?

  • Guest
    Reply
    |
    Feb 9, 2019

    ODBC was originally developed by Microsoft as Windows only.

    Use JDBC.

  • Guest
    Reply
    |
    Nov 19, 2018

    I tested one of my applications and saw a message when I try to open the form:  USE or USELSX Module: *LSXODBC..