EasyCFM.COM ColdFusion Forums / Other / AS/400 & CF connectivity

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: AS/400 & CF connectivity

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

wingnut
07-17-2006 @ 2:24 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 33
Joined: Jun 2006

We have some info in our AS/400 system I would like to pull out, and create a CSV file.

I'm curious if anyone has tried connecting to a AS/400 system, if so, can you provide a little info:  what type of connector did you use, etc.  Any possible problems I should look out for?

I'm used to connecting to Access and MySql systems, this is my first AS/400.......

Any help is appreciated.
Thanks!

maquiladoras
07-17-2006 @ 2:28 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2073
Joined: Dec 2002

wow, someone bought one of those things?
I used to work for a company where we had an AS/400 eternally on loan

anywho! the information you're looking to get, is it a file, in a db etc?


-
Any code printed thus far is likely to be stolen and used by Ray Horn, well done...ray
-

wingnut
07-17-2006 @ 2:39 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 33
Joined: Jun 2006

The info is in the database, as far as I know.

maquiladoras
07-17-2006 @ 2:52 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2073
Joined: Dec 2002

if its a stock AS/400 then i'm going to assume the DB is using IBM's DB2.

Coldfusion comes with a DB2 Universal connector
however IBM Also have an opensourced JDBC driverset themselves, you can find them here
https://sourceforge.net/project/showfiles.php?group_id=128806

Also another good resource for AS/400+DB2+Coldfusion is here

http://www.brooks-bilson.com/blogs/rob/index.cfm?mode=cat&catid=FB4A5820-B901-42A8-836EF2A508F8CACB

you will have to find out details from the DBA things like username and password and whether you can have remote permission to access the Machines DB

-
Any code printed thus far is likely to be stolen and used by Ray Horn, well done...ray
-


Website Designed and Developed by Pablo Varando.