actually it's on a server, my notebook is a 2k3 standard >Dave, > >For someone with your length of development you really have surprised me on >this issue. > >First of all, if you install SQL2005 on a workstation it will default to a >desktop version or a named instance of a database, however you can have >multiple databases in that named instance. > >Second of all, yes for every named instance you do need to have a different >port. > >Now Kurt this may answer your question. > >You need to download the SQL2005 JDBC drivers from MS if you haven't done so >already, you then make the connection in the same manner you would any JDBC >driver connection even mySQL. > >Now comes the catch, you need to go back to SQL2005 and open the TCP/IP >ports because by default these are disabled and you will not be able to get >coldfusion to connect to until you do this. > >SQL Express doesn't run on port 1433. On my machine it runs on port 1771. I >didn't do anything special during the installation (meaning I just accepted >all the defaults) so I'm not sure if 1771 is the default port for SQL 2005 >now or if for some reason on my setup it just chose this port. The port is >obviously crucial when you're setting up your datasources for CF. To check >your port after installation, go to the SQL Server Configuration Manager >(the same one you went to above to enable TCP/IP connectivity), go to >Network Configuration/Protocols again, right click on TCP/IP, choose >Properties, then click on the IP Addresses tab. Under IPAll in the TCP >Dynamic Ports section, in my install this was automatically set to port >1771. > > > >Senior Coldfusion Developer >Aegeon Pty. Ltd. >www.aegeon.com.au >Phone: +613 8676 4223 >Mobile: 0404 998 273 > > >-----Original Message----- >From: Dave Watts [mailto:[EMAIL PROTECTED] >Sent: Tuesday, 10 October 2006 12:38 PM >To: CF-Talk >Subject: RE: CF, jdbc, SQL2k5 problem > >> > You can't connect using an instance name. You will need to >> > use the IP socket corresponding to the instance. >> >> I'm not so sure about that. I believe i used an instance name >> at a client and it worked see: >> http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18294 >> but can't get it to work here > >You might want to read that technote more carefully. It says you have to use >a unique port, which is what I said as well. > >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:256092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
