>- see footer for list info -< Ok got there in the end - I looked at the JDBC url on the settings summary page in the administrator to see how it was putting together the url, looks like I don't have to include server\instance name, simply including the server name and setting the correct port was all it needed.
Thanks for all the suggestions > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:dev- > [EMAIL PROTECTED] On Behalf Of Snake > Sent: 02 March 2006 13:17 > To: 'Coldfusion Development' > Subject: RE: [CF-Dev] trying to connect to a new named instance of SQL server > > >- see footer for list info -< > Ok, now try the CF DSN. > If it doesn't work, try an ODBC socket as a quick fix. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: 02 March 2006 13:17 > To: 'Coldfusion Development' > Subject: RE: [CF-Dev] trying to connect to a new named instance of SQL > server > > >- see footer for list info -< > Good suggestion, tried it and I can successfully setup an ODBC datasource > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:dev- > > [EMAIL PROTECTED] On Behalf Of Snake > > Sent: 02 March 2006 13:00 > > To: 'Coldfusion Development' > > Subject: RE: [CF-Dev] trying to connect to a new named instance of SQL > server > > > > >- see footer for list info -< > > Can u make a windows ODBC DSN to that instance ? > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > [EMAIL PROTECTED] > > Sent: 02 March 2006 11:47 > > To: 'Coldfusion Development' > > Subject: RE: [CF-Dev] trying to connect to a new named instance of SQL > > server > > > > >- see footer for list info -< > > Nothing unusual, all caps no hyphens or underscores or anything... > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:dev- > > > [EMAIL PROTECTED] On Behalf Of Steve Powell > > > Sent: 02 March 2006 09:33 > > > To: Coldfusion Development > > > Subject: RE: [CF-Dev] trying to connect to a new named instance of > > > SQL > > server > > > > > > >- see footer for list info -< > > > [EMAIL PROTECTED] wrote : > > > > > > <SNIPPED> > > > > > > Is the Instance name anything unusual? > > > > > > I've had problems in the past where the instance name was too long > > > and my > > VB apps > > > wouldn't connect correctly because the network drivers I was using > > couldn't cope. > > > Spaces and such can cause problems. We keep a lot of our stuff to > > > all > > upper case and > > > less than 8 chars because of our old NT boxes. > > > > > > Just a thought. > > > > > > Steve > > > > > > > > > Steve Powell > > > [EMAIL PROTECTED] > > > 07971 583792 > > > > > > > > > > > > > > > _______________________________________________ > > > > > > For details on ALL mailing lists and for joining or leaving lists, > > > go to http://list.cfdeveloper.co.uk/mailman/listinfo > > > > > > -- > > > CFDeveloper Sponsors:- > > > >- Hosting provided by www.cfmxhosting.co.uk -< > > > >- Forum provided by www.fusetalk.com -< > > > >- DHTML Menus provided by www.APYCOM.com -< > > > >- Lists hosted by www.Gradwell.com -< > > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > > > >help > > -< > > > > > > > > > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, go > > to http://list.cfdeveloper.co.uk/mailman/listinfo > > > > -- > > CFDeveloper Sponsors:- > > >- Hosting provided by www.cfmxhosting.co.uk -< > > >- Forum provided by www.fusetalk.com -< > > >- DHTML Menus provided by www.APYCOM.com -< > > >- Lists hosted by www.Gradwell.com -< > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > > >help -< > > > > > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, go > > to http://list.cfdeveloper.co.uk/mailman/listinfo > > > > -- > > CFDeveloper Sponsors:- > > >- Hosting provided by www.cfmxhosting.co.uk -< > > >- Forum provided by www.fusetalk.com -< > > >- DHTML Menus provided by www.APYCOM.com -< > > >- Lists hosted by www.Gradwell.com -< > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > > >help > -< > > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > >-< > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
