Re: Connect to 2K on machine with both 2K and 2K5

Am Fri, 22 Dec 2006 10:00:33 -0800 schrieb Karl Perry:

I have both SQL Server 2000 Developer Edition SP3 and SQL Server 2005
Developer Edition (9.00.2047.00) installed on my WinXP SP2 notebook.

I'm connecting from a Windows PocketPC 2003 Second Edition device which is
running a custom app which uses SQL Server CE 3.0.

The database I need to connect to from the PocketPC device is attached to my
SQL Server 2000 instance.

When my PocketPC application connects to the IP address of the notebook and
displays a list of attached DBs, it shows the DBs attached to the 2005
instance, not the 2000 instance. The application accessing the DBs is
currently looking at port 1433. The app was written by our developers so we
can change it to look at another port if necessary.

I can't figure out how to get the PocketPC device to look at SQL Server 2000
rather than 2005. Can anyone help?

If I need to repost this message on another NG, please let me know the one
most appropriate and I'll repost.

TIA,

Karl Perry

I think, this two servers use different ports. And port 1433 is occupied by
SQL2005. Now you can check which port is used by SQL2000 and change your
program on the PocketPC. Or you reconfigure your SQL-Servers, that SQL2000
use port 1433 again and SQL2005 use another port. I have the same scenario
where MSDE without instance is using port 1433 and three instances are
running with SQLExpress, every instance has another port address. Works
perfect (port number can be used in the connection string).

bye,
Helmut
.

Relevant Pages

  • Re: Opening a COM port on Smartphone
    ... > On my PocketPC the ports are COM5 for inbound and COM8 for outbound. ... >> I don't know for the Smartphone but i know that, for PocketPC 2003, ... Note the BT serial port. ... using a thirdparty SerialPort component but everytime I try to call OpenI ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: bluetooth application development
    ... bluetooth stack give the ... possibility to make a BT discovery, pairing and VirtualCOM port attach. ... Once you have made this association (in PocketPC outbound VCOM usually ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Serial Port Comms
    ... >I have developed a PocketPC application which has to copy a file via a serial ... >of the serial port. ... instead of a return character. ... >16 bit characters but I have tried converting them to CHAR but nothing ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: How to use a PocketPC as an input device to a PC using USB cable
    ... as the hostname and some port number in the PocketPC application. ... I set up a TcpListener on the same port. ... > I've done something like this using a wireless connection to ... >> I've set the iPAQ as the TcpClient and the desktop as the TcpListener. ...
    (microsoft.public.pocketpc.developer)
  • Re: ADP problems after SQL 2005 Upgrade
    ... Use the SQL Server Configuration Manager to create aliases; ... each port can be associated only with a single instance. ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
Loading