Remote port is the one you want to use. Not sure why it wouldn't work, perhaps the driver is not configured to work that way... maybe there's some kind of encryption going on as well...
-----Original Message----- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 1:00 PM To: CF-Talk Subject: Re: iseries as400 question We tried this and it came back with two port numbers. one local and one remote. We tried them both and neither worked :( On 9/26/05, Russ <[EMAIL PROTECTED]> wrote: > Netstat -a should give you all the network connections that your computer > has at this time... issue a long running query, and run netstat -a to see > what connections you have to the db computer... that should give you the > port # as well > > -----Original Message----- > From: Ryan Guill [mailto:[EMAIL PROTECTED] > Sent: Monday, September 26, 2005 12:04 PM > To: CF-Talk > Subject: Re: iseries as400 question > > yeah, we tried that (or at least one of the db guys did) and he said > he couldnt discern anything meaningful from it. But ill try that > again, maybe he missed something. > > On 9/26/05, Russ <[EMAIL PROTECTED]> wrote: > > Well if you can't google it, have you tried sniffing the information? > > Either do netstat or put on ethereal or something while you're connected > to > > the datasource... you'll see which port the packets are going to... > > > > -----Original Message----- > > From: Ryan Guill [mailto:[EMAIL PROTECTED] > > Sent: Monday, September 26, 2005 11:50 AM > > To: CF-Talk > > Subject: iseries as400 question > > > > Hey guys, > > > > Is anyone else out there in cftalk land using iseries as400 for a > > datasource? > > > > We have about 15 that we are connecting to currently and we have them > > set up just fine through the odbc client access connections. But we > > were looking at maybe switching it over to the native coldfusion db2 > > driver. Only problem is, we can't seem to figure out what the port > > needs to be. the client access odbc administrator doesn't ask for a > > port (its not an option anywhere.) I am thinking that it must be a > > standard thing because of that fact. Anyone have any suggestions or > > know where I could look. several google searches haven't yeilded > > anything. The default db2 port when you pull it up in cf is 50000 and > > it isn't right. > > > > thanks for any help. > > -- > > Ryan Guill > > BlueEyesDevelopment > > [EMAIL PROTECTED] > > www.ryanguill.com > > (270) 217.2399 > > got google talk? Chat me at [EMAIL PROTECTED] > > > > The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com > > > > www.ryanguill.com/ > > The Roman Empire: www.ryanguill.com/blog/ > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219287 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
