Hi,
I have a problem connecting to SQL server 2012 from a scheduled agent in Notes (Domino server running iOS Linux SUSE).
I have however successfully connected running the agent manually, because obviously it’s running on my local machine which has Windows 7 and SQL server 2012 installed.
Is DECS the ONLY way for a Linux based installation to connect to SQL? I have searched but can’t find any definite answers. The reason why I ask is the client is not happy with one solution. They want options.
My code looks like this (this is basic code just to see if I can connect):
Option Public
Option Declare
UseLSX “*lsxlc”
Sub Initialize
'Dim s As New NotesSession
'Dim db As NotesDatabase
Dim lc_connection As LCconnection
Dim lc_results As LCfieldList
Dim lc_foo As LCfield
Dim memo As NotesDocument
Dim errmessage As string
Set lc_connection = New LCconnection("oledb")
With lc_connection
.provider = "SQLOLEDB"
.Server = "sql server instance name"
.Database = "sql db connecting to"
.Userid = "username"
.Password = "password"
.Metadata = "sql table"
End With
Call lc_connection.connect
End Sub
Error on log.nsf:
11/06/2013 10:34:57 AMgr: Agent (‘Test linux cmnd’ in ‘SQLAdmin.nsf’) error message: Error creating product object
Your help will be greatly appreciated.
Thanks,
Eugene