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:219258 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
