jrun-resource.xml is where the information about the database is stored when you config it in the CF Admin. I'd verify that all the connection data there is correct, but I'd also try creating a new datasource that point to the same place through CF -- that way you know whether it's this particular entry or *all* connections to SQL 2000. I'm guessing it's all connections to SQL2000.
You'd get the same sort of message if you simply erased info out of that xml config file. Having trouble guessing how an upgrade could have done that so you're probably dealing with something more annoying. Could you have done something like change the default connection method in sql server (e.g. from named pipes to TCP or vice-versa)? I've been running SQL2000 sp2 w/ the .669 cumulative patch/hotfix and can connect using CFMX just fine, but I had patched the SQL servers before the CFMX even rolled out. I can't remember precisely what the upgrade from SQL2k (or sp1) to sp2 did. But if it's only one web server, the the win server patch is where you need to look. bleah. You might try changing over to TCP connections as a test (assuming you're using named pipes) or vice-versa to verify whether the problem is in the connection method itself or something more subtle. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 10:41 AM Subject: HELP!!!! jrun-resources.xml > did an sql 2000 service pack upgrade > and a win2k adv critical updates on all servers > last night, and now one of my servers is having > issues making a datasource connection to > a machine that prior to last night, had no issues... > > here is the error I am getting, HELP!!!! > > Connection verification failed for data source: platypus > []java.sql.SQLException: No datasource named Platypus is configured in > jrun-resources.xml > The root cause was that: java.sql.SQLException: No datasource named > Platypus is configured in jrun-resources.xml > > first, where the heck is jrun-resources.xml? second, should I even be > looking > for this cause it is or isnt the problem? what should I do? > I have verified the odbc connection on the machine, and it is fine > going to the server, datasource test works 100% (from windows odbc > connection form) just not from cf or the administrator setting it up > > thanks. > > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
