SQL connection Issue

[tpadhu]

Hi,

i'm trying to access MSDE from smart device apps. but connection failed.Actually i tried this before few months. spent more than a week. but failed. so i just used SQL 2000.
Now it's a time to change from SQL 2000 to MSDE.
So again trying my best. but still I couldn't make the connection. if i test the connection from Server Explorer -> database connection, connection succeeded. but when i try to establish it via pgm(VB.NET), failed to open the connection.
As u said,I enabled TCP/IP.
Firewall - off
anti virus - unloaded.

getting error like "Server not found - "CMP1\MSDE1"

Can anyone guide me to solve this issue?


Thank You!

[HanneSThEGreaT]

You need to use SQLServerCE instead

have a look here as well
http://builder.com.com/5100-6387-1058880.html

[tpadhu]

In Pocket PC, i'm using SQL serverCE as localDB.

At the server side i need to have MSDE (or) SQL 2000.

At present, i'm using SQL 2000. but My actual requirement is MSDE.

I've seen in the TCP/IP Port, port number is 1433 (for both default and MSDE instances). Is it correct? Do i need to change the port no?

Always getting msg. like "Specified server not found". I wasted whole day for just to establish the connection. what should i do ?Going mad with this..

But no other way. I should do it. Can i ask technical support for this?
If so, How? . It's a free one. right?. Will microsoft give technical support?
I searched in web. not found specific help.

Kindly suggest me. I need to solve this pbm within tomorrow.

Thanks.

[HanneSThEGreaT]

http://www.informit.com/articles/article.asp?p=421049&rl=1