So it only took me and a microshit guy like 1.5 hours to figure this one out, and it turns out to be that the service pack (4) for sql server 7 zero'ed out my concurrent user licenses for both of my older sql server 7 servers. THANKS MICROSHIT!!! THANKS a whole lot, anyway, thank you all for your help.
...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 -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 1:41 PM To: CF-Talk Subject: RE: HELP!!!! jrun-resources.xml > Of course, using JDBC/ODBC bridge means you can test using > ODBC :) You need a JDBC app to test JDBC connectivity. Dick Applebaum pointed out a useful JDBC client for this sort of thing - ViennaSQL. It's a runnable JAR file: http://vienna.sourceforge.net/ > Hey -- as an side, when you say the ODBC connection work, > are you simply using the "Test Datasource" in the MSSQL > ODBC setup? I don't remember all the details, but it's > not a complete test -- it's more like a ping (yes, there's > a sql server there) than a real test (yes, login is > successful). I'm pretty sure this isn't correct. When you use this test, you connect to the specific database, using the specific username and password. The "ping" part happens before you even get that far in the ODBC Control Panel - when you select a server or server alias. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4