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: Tables in Query of LAN script suddenly expecting sysdba as prefix after updating to 8.3

mark
Posts: 70

Tables in Query of LAN script suddenly expecting sysdba as prefix after updating to 8.3 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Dec 16 5:58 AM

Hi All,

I recently updated the saleslogix LAN client to Infor 8.3 from saleslogix 7.5.2. I have many customizations in scripting which invovles direct in line queries. The problem i am facing is my screens saying all of the SQL's are failing suddenly because of wrong table names.

When i debug the code/script it is suddenly expecting sysdba. before every query we used in script. But it is not the case in saleslogix 7.5.2. I am not sure what happend.

Any help is really appreciated

Thanks in advance

Mark

[Reply][Quote]

Steve Robertson
Posts: 146

Re: Tables in Query of LAN script suddenly expecting sysdba as prefix after updating to 8.3 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Dec 16 6:27 AM

Hi Mark,

Check the Connection in Connection Manager for the 8.3 database you are connecting to. The Data Link should be using the sysdba SQL user to connect to the SQL database - from what you describe the connection is not using the sysdba SQL user credentials.

Steve

[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 © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 3:56:10 AM