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.Sql Client 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

[Joseph MCP]

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" wrote:

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.Sql Client 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

[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...
"Joseph MCP" <Jo*******@disc ussions.microso ft.com> wrote in message
news:E6******** *************** ***********@mic rosoft.com...

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" wrote:

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.Sql Client 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

[Herfried K. Wagner [MVP]]

* "Jesus Carmona" <jc******@norie ga-bts.com> scripsit:

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:news://news.microsoft. com/microsoft.publi c.dotnet.framew ork.adonet>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[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
"Joseph MCP" <Jo*******@disc ussions.microso ft.com> wrote in message
news:86******** *************** ***********@mic rosoft.com...

August 9, 2004

Yes, this situation also applies to SQL Server 2000 SP3a.
I will be curious to hear if that solves it...
Joseph MCP
"Jesus Carmona" wrote:

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...
"Joseph MCP" <Jo*******@disc ussions.microso ft.com> wrote in message
news:E6******** *************** ***********@mic rosoft.com...

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" wrote:

> 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.Sql Client 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
>
>
>
>