Skip to Content mrc logo mrc logo
  • What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the Web MS Access to the Web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs & Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Development Services Training Mentoring
  • Overview Partners Press Releases Careers Events Contact Blog
  • Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • mrc-Productivity Series
  • Local Database Connections with V6R1
Back to Manual

Local Database Connections with V6R1

 

Both m-Power and mrc-Productivity Series customers have the ability to utilize a Local Database Connection if running their software off of an AS400.

m-Power customers can see this connection by going to Data Dictionary –> Edit Data Dictionary Files –> Data Source Configuration.

Classic Servlet customers can see this connection by going to Data Dictionary –> Edit Data Dictionary Files –> Classic Servlets –> Servlet Properties.

Note: This configuration must be modified slightly with IBM's V6R1. IBM has changed their logic slightly, and for increased security, they no longer allow a *LOCAL database connection without a username and password.

You must add a valid AS400 username and password to authenticate the database connection for the AS400.

  • For m-Power customers, please place the username and password between the respective <value> and </value> tags.
  • For Classic Servlet customers, please place the username and password between the respective " " on the servlet properties page.

Please note:

Classic Servlet customers will need to modify the Sign On screen file, where connection information is stored. Additionally, Classic Servlet customers must modify these two files for each and every data dictionary they are utilizing.

More information can be found here.

Created: July 7, 2008 | Modified: February 7, 2012

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

External Objects Admin m-Painter DB2 Compiling Tomcat Summaries Freemarker Graphing Getting Started Popular Advanced Database Graph Properties Record Selections Security Video Java Dropdowns Reports Bar Graphs Form Validation Administration Maintainer Production Retrieval mrc-Productivity Series Build Process Maintainers Report Parameters Retrievals Graphs Bootstrap Templates Email Calculations Dates Prompt Screens Performance RPG Application Properties Excel SQL App Properties Data Dictionary

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© mrc. All rights reserved.