Re: Windows XP Pro SP3 / SQL 2000and 2005 Express Fails

I think the problem is something new that they adeded. They added some "Surface Layer' security that seems to be causing trouble or I just haven't added the correct ASPNET security object yet.
I have two different machines with similar problems because I am trying to set up muy dev environment and one to show clients their products where they don't have WIFI. One of the machines owon't even let me past the admin login screen. I'll check the other to see how far I can get withthat on. 

Tom
----- Original Message ----- From: <andre.dure@xxxxxxxxxxxxx> 
To: <programmingblind@xxxxxxxxxxxxx>
Sent: Monday, June 23, 2008 9:01 AM
Subject: RE: Windows XP Pro SP3 / SQL 2000and 2005 Express Fails


A typical connection string for sql looks like this:
Data source=yourSqlServer;initial catalog=YourDatabase;User id=yourUser;password=yourpass
You must pass that string to the sqlconnection constructor, or assign the value to the connectionstring property of the connection. Either way works fine. 

hth

André Duré

T&E Systems - Latam
Accenture CIO - Buenos Aires - Argentina Delivery Center
Paseo Colón 746 Piso 3 C1063ACU
+54-11-4850-3580

-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Tom Ladis 
Sent: Friday, June 20, 2008 9:44 PM
To: programmingblind@xxxxxxxxxxxxx
Subject: Re: Windows XP Pro SP3 / SQL 2000and 2005 Express Fails

I changed to code over the use SqlServer and SqlClient but am not sue what
the login string should look lik.  Do yuou have an example?    Thanks    Tom
----- Original Message ----- From: <andre.dure@xxxxxxxxxxxxx> 
To: <programmingblind@xxxxxxxxxxxxx>
Sent: Thursday, June 19, 2008 3:31 PM
Subject: RE: Windows XP Pro SP3 / SQL 2000and 2005 Express Fails


Why don't you try to use the system.data.sqlclient instead of ODBC? It works
pretty better with sql

hth

André Duré

T&E Systems - Latam
Accenture CIO - Buenos Aires - Argentina Delivery Center
Paseo Colón 746 Piso 3 C1063ACU
+54-11-4850-3580

-----Original Message-----
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Tom Ladis
Sent: Thursday, June 19, 2008 1:56 PM
To: programmingblind@xxxxxxxxxxxxx
Subject: Re: Windows XP Pro SP3 / SQL 2000and 2005 Express Fails

The exception messages says that there is a System.Data.ODBC.ODBCException
in System.Data.dll.   Not really much help.

I have found something about a System.Data.ODBC security class on
Microsoft.com that leads me to believe that I have to include something that
was not previously necessary or that I need to add some type of access for
the ASP process to get to the databases.

I will reproduce the errors and geet the exact error messages when I have
more patience.

Thanks,
Tom
----- Original Message ----- From: "Jackie McBride" <abletec@xxxxxxxxx> 
To: <programmingblind@xxxxxxxxxxxxx>
Sent: Thursday, June 19, 2008 10:22 AM
Subject: Re: Windows XP Pro SP3 / SQL 2000and 2005 Express Fails



Are u getting any error messages, or is it just not working?

On 6/19/08, Tom Ladis <tom@xxxxxxxxxxxx> wrote:

Hello all.   I recently installed the Windows SP3 on XP Pro.  The machine
already had SQL 2000 and some ASP web sites that accessed the databases
well.  After installing the service pack the web sites cannot access the
databases.

Does anybody know what Microsoft did to break this?  I have even tried
installing SQL 2005 express edition hoping that it would work better, but
no.

I am guessing that they added some security that I need to adjust now,
but
am having trouble finding the correct info.

Does anybody know what has happened?

Thanks,
Tom

__________
View the list's information and change your settings at
http://www.freelists.org/list/programmingblind





--
Change the world--1 deed at a time
Jackie McBride
Check out my homepage at:
www.abletec.serverheaven.net
& please join my fight against breast cancer
<http://teamacs.acsevents.org/site/TR?px=1790196&pg=personal&fr_id=3489>
__________
View the list's information and change your settings at
http://www.freelists.org/list/programmingblind




__________
View the list's information and change your settings at
http://www.freelists.org/list/programmingblind




This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information.  If you have
received it in error, please notify the sender immediately and delete the
original.  Any other use of the email by you is prohibited.
__________
View the list's information and change your settings at
http://www.freelists.org/list/programmingblind


__________
View the list's information and change your settings at
http://www.freelists.org/list/programmingblind
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. 
__________
View the list's information and change your settings at
http://www.freelists.org/list/programmingblind


__________
View the list's information and change your settings at http://www.freelists.org/list/programmingblind

Other related posts: