I've downloaded the examples file (3/31/2006), I've also downloaded and installed Pubs.mdf.

The method GetAuthorSqlReader does not appear to exist, I can add it, however the errors won't allow me to build the project.

When I load the examples solution file there are 9 errors, as a result I can't Build the project. The 1st error is "Type 'SqlRecord' is not defined." This error is repeated several times along with others.

Have I set something up wrong in Visual Studio, or am I missing part of the code somehow?

OK I found some information on MSDN that says that the sqlRecord type
has been removed from vb 2005.

So what do I do to fix the following line of code:
Public Function ExecSpReturnRecord(ByVal spName As String, _
                                         ByVal paramValues As IDictionary) As SqlRecord

It looks like this code was written for and would work with the early beta version of VB 2005, but not with the release version.

Wow, that's weird when I shipped the code for this chapter I had that part commented out. I will see if I can upload the code again for this chapter.

Hi,

The code does not seem to have been updated and I wanted to use this method of retrieving data for a project I'm working on - a working example would really help.

I'm sure eventually someone will figure out how to update the on-line post, in the meantime can you e-mail the updated code to me?

Thanks.

Hi,
Thanks for the code update, it got rid of all the compile errors. I still have a problem when I try to run the program - I get the following error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I am using SQLExpress which might be the problem, can you tell me how to fix this problem? I have installed the Pubs database and it shows in SQL Express as well as in Server Explorer.

I have the same problem with a database that I have created from scratch, I'm trying to use this connection concept in it as well.

I still can't get it to work useing the entry in app.config, I would like to be able to use a getConnection function with the connection string in the app.config file and I can't seem to get that to work.

I did get a connection using the following code (in my own app):
Dim dr As SqlClient.SqlDataReader
        Dim conn As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Crisis1.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")
        conn.Open()
        Dim command As SqlClient.SqlCommand = New _
            SqlClient.SqlCommand(storedProcedureName, conn)
        command.CommandType = CommandType.StoredProcedure
        dr = command.ExecuteReader(CommandBehavior.CloseConnect ion)
        While (dr.Read)
         (Read Stuff)
        End While

Can you tell me how to achieve this using your function/app.config concept? It's fine if it uses the code sample from the Pubs database - I can translate it to my database!

Thanks.