slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: scripting error

CGK
Posts: 34

scripting error Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 May 07 5:52 AM

Hi All,

We are working on SalesLogix version 6.2 and facing the following errors:

Upon accessing the Notes-History in Contacts,
" error in including script(system:NotesHistoryCommon): Authentication failed at line 493, char 5"
Upon accessing the Notes-History in Accounts,
" error in including script(system:NotesHistoryCommon): Authentication failed at line 495, char 5"

We looked into the code:

For i = 0 To grdHistory.Columns.Count - 1
Set col = grdHistory.Columns.Item(i)
If col.Sorted <> 0 Then
If col.Sorted = 1 Then
strGridSQL = strGridSQL & " Order By " & col.FieldName & " Desc"
Else
strGridSQL = strGridSQL & " Order By " & col.FieldName & " Asc"
End If
Exit For
End If
Next

grdHistory.SQL.Text = strGridSQL (..... Line 493)
grdHistory.Active = True
grdHistory.Selection.Add(grdHistory.GetCurrentField) (... Line 495)

Upon debugging, we came across the message stating "Type Mismatch" in the following executable statement;

SqlClause = "Select b.Lastname, b.Firstname, a.contactid, a.accountid, a.opportunityid, c.country " & _

"From Activity a, Contact b, Address c " & _

"Where a.ActivityID = '" & gsActivityID & "' " & _

"and a.ContactID = b.ContactID " & _

"and b.addressID = c.addressID "

We could not figure out as to why it states "Authentication failed" and then again states "Type Mismatch".
Could anyone guide us with this code?

Thanks,
Chaitanya

[Reply][Quote]

Michael Litman
Posts: 94

Re: scripting error Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 10 May 07 8:30 AM

Hi Chaitanya,

We have had errors that point to lines of code in the system:common ***** as well In most cases the errors are in error and we have had to replace the MSADO15.DLL because it is corupt or not regestered properly. I would try this first before changing code in any system: common script.

Find the MSADO15.DLL file it should be in the C:\WINDOWS\system32\dllcache unregester this file and re-regester it if you continue to get this error copy it to a floppy from a machine that is work properly and copy it to the machine that isn't then regester the new dll.

If you are still getting the error then I would start to look at if it is a specific computer or all machines in the network. If it is just one machine then try to uninstall and re-install the client if you are having network wide problems it is time to call your BP.

Hope that helps ML

P.S. to regester a dll click start run in the command line type regsvr32 "C:\WINDOWS\system32\dllcache\msado15.dll" -u to unregester and regsvr32 "C:\WINDOWS\system32\dllcache\msado15.dll" to regester. ML

[Reply][Quote]

CGK
Posts: 34

Re: scripting error Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 May 07 6:20 AM

Thanks ML

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/18/2025 2:39:22 PM