Problems connecting to MSDE SP3a

[Jesus Carmona]

Good day everyone;
I'm having 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 I can 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

 

[Guest]

August 9, 2004

You are using the SA account to login onto the server. When
you upgrade to SP3a, the SA account is no longer supported, if
you use a weak password. You must change you password to
a strong one. I am pretty sure that this is your problem. I am
quite sure that to be a strong password, it has to consist of: a
minimum of 8 characters, some symbols, and both numbers and
letters. I am not positive that this will work, but you might want
to check. I hope this helps!


Joseph MCP

 

[Jesus Carmona]

Thanks Joseph,
I'll try to change the password and check again.

Does this change apply to MS-SQL Server 2000 as well in SP3a?

Thank you very much...

 

[Herfried K. Wagner [MVP]]

I'm having 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 I can solve this problem?

Notice that there is a separate group for database-related questions
available:

<URL:

 

[Jesus Carmona]

I tried what you suggested, and it didn't work. However I found out that by
default SP3a turns off network connection, using svrnetcn.exe I was able to
turn it back on.
Thanks a lot for your interest.

Regards
Jesus Carmona