> 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