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
Categories Integration
Created by Guest
Created on Nov 17, 2020

Make SQL scripts to run OS400 as for Windows Server

I want to run some scheduled agents which calls a SQL server. but it don't work because Domino is installed on OS400 server.

It runs perfectly from Windows Notes client.

  • Attach files
  • Guest
    Reply
    |
    Aug 16, 2021

    When running this script on domino 0S400 server version 9.0.1FP9:


    strConn = |Provider=SQLOLEDB;Data Source=| + sqlsrv + |;Initial Catalog=| + sqldb + |;User ID=| + sqluser + |;Password=| + sqlpw

    Set adoConn = CreateObject("ADODB.Connection")

    Set rs = CreateObject("ADODB.Recordset")

    Call adoConn.Open(strConn)


    we get an error,:


    When running from Notes client on a Windows pc, there are no problems.


  • Admin
    Thomas Hampel
    Reply
    |
    Jan 17, 2021

    Sorry, I dont understand this idea. Is this an idea or a bugreport? Can you please explain more? Maybe even provide screenshots of what you are trying to do?