Skip to main content
D
djkhalif
Inspiring
July 25, 2009
Question

Connect Coldfusion 8 to AS400 (MAPICS)

  • July 25, 2009
  • 2 replies
  • 1557 views

I am looking to connect to AS400 so that users can:

1. Pass usernames and passwords to AS400

2. query a "Work Order" to get related items (AS400)

Thanks in advance.

This topic has been closed for replies.

2 replies

D
djkhalifAuthor
Inspiring
July 31, 2009

Thanks Bob. I got it going using jt400.jar. I have to make another post because the data is returning gibberish in some places.

D
djkhalifAuthor
Inspiring
July 29, 2009

I am able to establish a connection to AS400 using ODBC socket and connection string. However,  my account does not have enough permissions to see any data. I would like users to pass their authentication to AS400 via a Coldfusion form. Any ideas on params? Should they look like this:

<cfparam name="FORM.username" default="Your Username">

<cfparam password="FORM.password" default="Enter Password">

If so, then will they pass to AS400?

J
JR__Bob__Dobbs-qSBHQ2
Inspiring
July 31, 2009

Disclaimer: I'm not familiar with MAPICS.

If are trying connect to MAPIC using an OBDC or JDBC DSN setup in ColdFusion and execute SQL statements via CFQUERY you might try using the password and username attributes of CFQUERY.


<cfquery name="myQuery" datasource="myMapicsDsn" username="#form.username#" password="#form.password#">
    <!--- your query here --->
</cfquery>

CFQUERY

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_p-q_17.html#1102316

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices