How does one find that out? I am certian the SQL 2005 instance is listening
on port 1433. But when I telnet into 1433 when only the SQL 2000 instance
is running, I receive the message that I can't access that port.
On 4/27/06, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > On one of my development boxes, I am running CF 7 (on windows
> > XP) I installed SQL Server 2005 with no issues. I then
> > realized that for one client, I will need to have SQL Server
> > 2000. I installed 2000 as a separate instance.
> >
> > I am unable to connect to the new instance with CF (I was
> > able to create a Windows DSN and connect viz ODBC socket). I
> > can connect to both SQL Server instances in SQL Studio, and I
> > can connect to the SQL 2000 instance from Enterprise Manager.
> >
> > The instances are:
> >
> > {serverName}
> > {serverName}\sql2000
>
> The names are irrelevant. You'll have to see what port each is listening
> on,
> and specify that in your datasource.
>
> 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!
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238951
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
