I'm interested in what you are using for "server/instance" ... .NET can access AD or NetBIOS (friendly server) names to access the server instance - but you will need an IP or (better) an FQDN to access it via JDBC. Perhaps you can post your settings from CF Admin.
-mark Mark A. Kruger, CFG, MCSE www.coldfusionmuse.com www.necfug.com -----Original Message----- From: kurt schroeder [mailto:[EMAIL PROTECTED] Sent: Monday, October 09, 2006 2:42 PM To: CF-Talk Subject: CF, jdbc, SQL2k5 problem I have the works, on one box for testing. and it all functions except for the ColdFusion connection to the SQL2K5. I even created a few dot.net apps for testing and they connected fine! The other, possibly related symptom is that i can not create an ODBC data source eather. A side note is that i can connect to the live db on a different box, but this is a sql2000 db. Does anyone have any idea why this could be happening? here is the dot.net connection string that does work: (real items changed) SERVER\INSTANCE;Initial Catalog=DBNAME;Persist Security Info=True;User ID=SSSSS;Password=XXXXX After 10 years of developing CF apps this one is a first Never had this kind of trouble before!!! Thanks for the help! KES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
