did that but i got an error :
db2 => connect to db1 user MS007 using PASSWORD
SQL30081N A communication error has been detected. Communication protocol
being used: "TCP/IP". Communication API being used: "SOCKETS". Location
where the error was detected: "". Communication function detecting the
error:
"connect". Protocol specific error code(s): "146", "*", "*".
SQLSTATE=08001
anyway, did all AS400 comes with a DB2 database, as i'm pretty much knows
nothing about AS400, my AS400 administartor told me that they might be using
the legacy AS400 database, might not be a DB2.
----- Original Message -----
From: James Taavon <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 12:27 AM
Subject: Re: as400 connection
> Ok, here is what you need to do:
>
> - Make sure you are running DB2 Connect Version 5 Fixpak 6 on your
> Solaris Server.
> - From DB2 Connect create a catalog for your database
> - At the command prompt type the following
> - catalog tcpip node "as400 or any name" remote "as400 hostname or ip
> address" server "port number"
> - catalog database "dbname" as "dbalias" at node "same as previous
> line" authentication dcs
> - catalog dcs database "dbname" as "dbalias"
> - connect to the database using an assigned username and password to
> check if cataloging was successful
>
> Then once the connection is confirmed go into your CF Administrator and
> setup your connection with a username a password, then test. The
> connection should be successful.
>
> If you have anymore questions, let me know.
>
>
>
>
>
> Mak Wing Lok wrote:
> >
> > my CF server is sitting on Sun Solaris server, what should i do then?
did
> > client server come with an Unix version?
> >
> > ----- Original Message -----
> > From: Robert Everland III <[EMAIL PROTECTED]>
> > To: CF-Talk <[EMAIL PROTECTED]>
> > Sent: Tuesday, February 13, 2001 12:24 PM
> > Subject: RE: as400 connection
> >
> > > Yes you use client access's built in odbc connection. Very easy, kind
of
> > > slow but I haven't really had too much problems with it. Getting
AS/400
> > SQL
> > > should speed up everything though, with stored procedures and all.
> > >
> > >
> > > Bob Everland
> > >
> > > -----Original Message-----
> > > From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, February 12, 2001 11:11 PM
> > > To: CF-Talk
> > > Subject: as400 connection
> > >
> > >
> > > hi people,
> > >
> > > did anyone know that if it is possible for CF server to "talk" to
AS/400
> > > machine?
> > > advise needed, thanks
> > >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
