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 >> //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 > //www.freelists.org/list/programmingblind > > __________ View the list's information and change your settings at //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 //www.freelists.org/list/programmingblind __________ View the list's information and change your settings at //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 //www.freelists.org/list/programmingblind