> 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
You can't connect using an instance name. You will need to use the IP socket corresponding to the instance. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:256022 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
