Starnge error in client 8.5 Mac but not in 8.5 win

HCL Domino Domino Forum
1

Hi all, I developed an application with Notes Designer 8.5 for the Spesen refund for our traveling coworker.

This application is working perfectly in the windows client (7.03 and 8.5)

But when open on a Mac client show the following error message:

“Error loading USE or USELSX module: *lsxlc” (link to error message: http://farm4.static.flickr.com/3393/3255182145_82d42a9152_o.png )

I tried to fix it with a recompile all lotusscript but to no avail

Please, someone can help me?

2

Subject: Where is lsxlc defined?

On the Mac, the lsx “registry” is still the file “LotusScriptExtensions\2.0”, as it was in the OS 9 days. On OS X, this file lives in ~/Library/Preferences/Lotus/LotusScriptExtensions\2.0 (yes, that’s really a backslash in the name). If you don’t have lsxlc defined in the lsx registry, the USELSX statement won’t be able to find it…

The LotusScriptExtensions\2.0 file is still a resource file in Notes 8.5, which means you would need ResEdit (which only runs in OS 9) or the Rez and DeRez tools from the Mac Developer Tools (it gets installed into /usr/bin) to create/modify this file. A copy of LotusScriptExtensions\2.0 from OS 9 (Notes 5) days should work OK if you have one.

Otherwise, you can replace the full path of the lsx file for “*lsxlc” in the USELSX statement, if that’s practical.

3

Subject: We have a win + mac environment

We need to use the application on win and on mac so I can’t simply edit the “*lsxlc” :-(We have branched to Mac with the 8.5 client (currently with 3 macs) so I don’t have a previous LotusScriptExtensions\2.0.

Can you send me a copy of this file to place in the macs at angelo_dot_pampalone_at_schaer.com thanbk you!

4

Subject: Are you running an application that uses LEI or database connectors?

The error indicates that you are - and I don’t know that the connectors or Lotuscript are available on the Mac client. Can you set the agent to run on the server, and does that make a difference?

Sarah

5

Subject: Yes the app use a DB connection:

Yes, this application uses a script library that I created to write data on a SQL Server table.The code is in a “Print button”. On click the data are copied on a sql server table and then presented using MSSQL Reporting Services (I call the report url passing as parameter the doc’s NotesId as a key to locate the data). Moving the code in a server side agent can I call the reports’s url in the client to open a browser with said report?

[Code snippent of the lsx use]

(Declaration)

Uselsx “*lsxlc”

Private Function p_SQLConnect2SqlServer(lcSsn As LCSession,lcCon As LCConnection, sqlTab As String) As Boolean

Dim text As String

Dim extcode As Long

Dim exttext As String



If (lcSsn Is Nothing) Then Set lcSsn= New LCSession

If (lcCon Is Nothing) Then Set lcCon= New LCConnection("oledb") Else lcCon.Disconnect





p_SQLConnect2SqlServer02= False

With lcCon

	.Provider= "sqloledb"

	.Server = "scasql02"

	.Userid = "xxxxx"

	.Password = "yyyyy"

	.Database = "Notes_Prints"

	.MetaData = sqlTab

	.Connect

End With



If Not lcSsn.Status = LCSUCCESS Then

	lcCon.Disconnect

	

	Call lcSsn.GetStatus (text,  extcode, exttext)

	If (lcSsn.Status = LCFAIL_EXTERNAL) Then

		Print "DB message: " & exttext & "  code #" & Cstr(extcode)

	Else

		Print "Connector message: " & text

	End If

Else

	p_SQLConnect2SqlServer02= True

	Print "Connected sussefully with sql server"

End If

End Function