- see footer for list info -<
Nice of Microsoft to do that for us
:-) yep.
In case you have the same problem with MS SQL2000this is usually due to SP4
being applied. You will need both a hostfile entry for your named instance &
add it to your client network utility.
I recently re-installed my dev environment & it took the best part of 3 days
to get MS SQL2000 working. 2005 was the doddle - go figure!
Cheers,
J
On 4/3/07, Allan Cliff <[EMAIL PROTECTED]> wrote:
>- see footer for list info -<
Thanks for that.
yes, TCP/IP was turned off by default.
Everything works fine now.
Allan
Nice of Microsoft to do that for us
Jatin Nanda <[EMAIL PROTECTED]> wrote: >- see footer for list info -<
Fun and games mate, I had this problem with SQL2000 as well & SQL sp4 - I
should have blogged my complete solution. The solution to this is
explained
in depth on Charlie Aienhart's (spelling??) blog - sorry don;t have the
link
handy.
Essentially you need to enable TCP/IP for your named instance SQL Server
'cos by default this is not installed.
Refer to the link below, though this is for J2EE servers, the screenshots
are the same for CF.
Let me know how you get on: -
http://www.devx.com/dbzone/Article/33681?trk=DXRSS_JAVA
On 4/3/07, Allan Cliff wrote:
>
> >- see footer for list info -<
> I have finally got a new 64-bit pc and am trying to get around a few
> problems with coldfusion. (Vista Ultimate)
>
> I have set up cf using its own server
> http://127.0.0.1:8500/CFIDE/administrator/index.cfm
> and that seems to work fine.
>
> I have also installed MS SQL Server 2005 Developer Edition but I can't
> seem to get a datasource registered with CF.
>
> http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=ded4216b
> I have tried to update the driver but no joy.
>
> Have also tried setting up an obdc connection in windows which it allows
> me to do but Coldfusion can't connect to that either.
> Error accessing available odbc datasources. - Cannot open
> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources: Windows
error 2
> occurred.The system cannot find the file specified.
>
> Any ideas.
>
> Thanks
> Allan
>
>
> ---------------------------------
> What kind of emailer are you? Find out today - get a free analysis of
your
> email personality. Take the quiz at the Yahoo! Mail Championship.
> _______________________________________________
>
> For details on ALL mailing lists and for joining or leaving lists, go to
> http://list.cfdeveloper.co.uk/mailman/listinfo
>
> --
> CFDeveloper Sponsors:-
> >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
> >- 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:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help
-<
---------------------------------
Inbox full of unwanted email? Get leading protection and 1GB storage with
All New Yahoo! Mail.
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- 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:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
