Problems Connecting to MSDE SP3a

  • Thread starter Thread starter Jesus Carmona
  • Start date Start date
J

Jesus Carmona

Good day everyone;
I have a program for a PocketPC that was working great, this program
connects to a database (MSDE) but when I updated the MSDE to SP3a everything
blew-up... There is no way I can connect to my database anymore. The funny
part is that if I connect to a full MS-SQL Server the program works just
fine. Do I need to change anything in my connection string so I can connect
to MSDE SP3a? Any Ideas of how can I solve this problem?

I have MSDE2000 SP3a
MDAC 2.8
VS.NET 2003
I'm using System.Data.SqlClient to connect

Here is my connection string.

mString = "Data Source = myServer; Initial Catalog = Aduana; Password = abc;
User Id = sa"

I also tried this:
mString = "User Id = sa; Password = abc; Database= Aduana; Server =
myServer"

Thank you in advance for your help...
Jesus Carmona
 
Hi,

Which error do you get? Did you update existing MSDE instance or you
installed new MSDE instance with SP3a
 
Jesus,
SP3a turns off network connection by default. Use the svrnetcn.exe
utility to enable TCP again and you should be OK once more.

Ron Allen
 
Back
Top