3/14/2026 12:23:00 PM
|
| |
| 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!
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.
|
|
|
|
scripting error
Posted: 09 May 07 5:52 AM
|
fiogf49gjkf0d 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
|
|
|
|
Re: scripting error
Posted: 10 May 07 8:30 AM
|
fiogf49gjkf0d 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 |
|
|
| |
|
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!
|
|
|
|
|
|
|
|