There is a JDBC driver for the as400. We used to install Client Access Express on the servers, but I hated that. When I found the JDBC driver, I was delighted.
I don't think the DB2 driver would have worked for us, but I was able to get the JDBC driver working quite quickly. If you are interested in that, I can send you the driver file(s) and what you need to enter in the CF administrator. M! -----Original Message----- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 10: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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:219259 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
