I am unable to get this application on page 635 working..

I get the following error 

"An unhandled exception of type 'System.Data.SqlClient.SqlException' 
occured in system.data.dll"

..at the line

myConnection.Open()

I have Visual Studio .NET Academic edition. I have installed MSDE and 
started the service with the default instance name VSdotNET.

I even tried changing the server parameter in SqlConnection to VSdotNET 
from (local). Get the same error.

Also, I am not able to see any pubs data base in the MSDE or any other 
folder.. (did a search on pubs). I assumed it would be installed with MSDE 
or VSudio installation..

Can anyone help me out?

Thanks

In a message dated 1/5/2003 12:02:36 PM Eastern Standard Time, ushetgeri@h... writes:

> Also, I am not able to see any pubs data base in the MSDE 
> or any other 
> folder.. (did a search on pubs).

I'm not sure if pubs gets installed with msde, I'd think that it would. But try installing the .NET Quickstart tutorials that came
with the SDK. That will install pubs. 

I believe your guess was right but this might help to confirm problem you're facing:
put a try and catch statement around the statement..

try 
  myConnection.Open()
catch ex as exception
  msgBox(ex.message) ' this will tell you more...
end try

Hope this will be of some use =)

--- uday shetgeri <ushetgeri@h...> wrote:

> I am unable to get this application on page 635 working..
> 
> I get the following error 
> 
> "An unhandled exception of type 'System.Data.SqlClient.SqlException'
> 
> occured in system.data.dll"
> 
> ..at the line
> 
> myConnection.Open()
> 
> I have Visual Studio .NET Academic edition. I have installed MSDE
> and 
> started the service with the default instance name VSdotNET.
> 
> I even tried changing the server parameter in SqlConnection to
> VSdotNET 
> from (local). Get the same error.
> 
> Also, I am not able to see any pubs data base in the MSDE or any
> other 
> folder.. (did a search on pubs). I assumed it would be installed
> with MSDE 
> or VSudio installation..
> 
> Can anyone help me out?
> 
> Thanks
> ===
> Fast Track ADO.NET with C# is a concise introduction to the
> concepts, techniques, and libraries that you will need in order to
> start using ADO.NET in your applications. The book covers DataSets
> and Typed DataSets, accessing data using DataReaders and
> DataAdaptors, the close relationship between ADO.NET and XML, how
> and where to use ADO.NET in your enterprise applications, and how to
> use Web Services and ADO.NET to easily pass data between
> applications.
> http://www.wrox.com/books/1861007604.htm
> 

Thanks.. With the additional details on the error I got it to work.. had 
to put in a trusted connection = yes in the connection string.

> I believe your guess was right but this might help to confirm problem 
you're facing:
put a try and catch statement around the statement..

try 
  myConnection.Open()
catch ex as exception
  msgBox(ex.message) ' this will tell you more...
end try

Hope this will be of some use =)

--- uday shetgeri <ushetgeri@h...> wrote:

> I am unable to get this application on page 635 working..
> 
> I get the following error 
> 
> "An unhandled exception of type 'System.Data.SqlClient.SqlException'
> 
> occured in system.data.dll"
> 
> ..at the line
> 
> myConnection.Open()
> 
> I have Visual Studio .NET Academic edition. I have installed MSDE
> and 
> started the service with the default instance name VSdotNET.
> 
> I even tried changing the server parameter in SqlConnection to
> VSdotNET 
> from (local). Get the same error.
> 
> Also, I am not able to see any pubs data base in the MSDE or any
> other 
> folder.. (did a search on pubs). I assumed it would be installed
> with MSDE 
> or VSudio installation..
> 
> Can anyone help me out?
> 
> Thanks
> ===
> Fast Track ADO.NET with C# is a concise introduction to the
> concepts, techniques, and libraries that you will need in order to
> start using ADO.NET in your applications. The book covers DataSets
> and Typed DataSets, accessing data using DataReaders and
> DataAdaptors, the close relationship between ADO.NET and XML, how
> and where to use ADO.NET in your enterprise applications, and how to
> use Web Services and ADO.NET to easily pass data between
> applications.
> http://www.wrox.com/books/1861007604.htm
>