Hello

Great book and I'm following it religiously could someone please help me.

I have everything done as chapter 3 describes and there are no visible errors but the database info is not showing up when I run the Default.asp page.

I do get the drop down and the "Error" "An error occurred" message on the page after load.

This is my Output

'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_32\mscorlib\2.0.0.0__b77a 5c561934e089\mscorlib.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_32\System.Web\2.0.0.0__b0 3f5f7f11d50a3a\System.Web.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System\2.0.0.0__b77a 5c561934e089\System.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Configuration \2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dl l', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Xml\2.0.0.0__ b77a5c561934e089\System.Xml.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Web.RegularEx pressions\2.0.0.0__b03f5f7f11d50a3a\System.Web.Reg ularExpressions.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Design\2.0.0. 0__b03f5f7f11d50a3a\System.Design.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_32\System.Data\2.0.0.0__b 77a5c561934e089\System.Data.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_32\System.Transactions\2. 0.0.0__b77a5c561934e089\System.Transactions.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_32\System.EnterpriseServi ces\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseSer vices.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Drawing\2.0.0 .0__b03f5f7f11d50a3a\System.Drawing.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\Microsoft.JScript\8. 0.0.0__b03f5f7f11d50a3a\Microsoft.JScript.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Web.Services\ 2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll' , Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Web.Mobile\2. 0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Users\DEVELOPER\AppData\Local\Temp\Temporary ASP.NET Files\root\61173f14\183a49fa\assembly\dl3\e594eed9 \0071101c_f551ce01\ASPPatterns.Chap3.Layered.Model .DLL', Symbols loaded.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Users\DEVELOPER\AppData\Local\Temp\Temporary ASP.NET Files\root\61173f14\183a49fa\assembly\dl3\4847227e \009e411d_f551ce01\ASPPatterns.Chap3.Layered.Prese ntation.DLL', Symbols loaded.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Users\DEVELOPER\AppData\Local\Temp\Temporary ASP.NET Files\root\61173f14\183a49fa\assembly\dl3\79367442 \0071101c_f551ce01\ASPPatterns.Chap3.Layered.Repos itory.DLL', Symbols loaded.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Users\DEVELOPER\AppData\Local\Temp\Temporary ASP.NET Files\root\61173f14\183a49fa\assembly\dl3\25c322f0 \0071101c_f551ce01\ASPPatterns.Chap3.Layered.Servi ce.DLL', Symbols loaded.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Users\DEVELOPER\AppData\Local\Temp\Temporary ASP.NET Files\root\61173f14\183a49fa\assembly\dl3\81fc4e48 \00c750a9_ef51ce01\StructureMap.DLL'
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Users\DEVELOPER\AppData\Local\Temp\Temporary ASP.NET Files\root\61173f14\183a49fa\assembly\dl3\55fedd51 \00aace62_6053ce01\ASPPatterns.Chap3.Layered.WebUI .DLL', Symbols loaded.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Runtime.Seria lization\3.0.0.0__b77a5c561934e089\System.Runtime. Serialization.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.IdentityModel \3.0.0.0__b77a5c561934e089\System.IdentityModel.dl l', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.ServiceModel\ 3.0.0.0__b77a5c561934e089\System.ServiceModel.dll' , Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.ServiceModel. Web\3.5.0.0__31bf3856ad364e35\System.ServiceModel. Web.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.WorkflowServi ces\3.5.0.0__31bf3856ad364e35\System.WorkflowServi ces.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Core\3.5.0.0_ _b77a5c561934e089\System.Core.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Data.DataSetE xtensions\3.5.0.0__b77a5c561934e089\System.Data.Da taSetExtensions.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Web.Extension s\3.5.0.0__31bf3856ad364e35\System.Web.Extensions. dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Web.Abstracti ons\3.5.0.0__31bf3856ad364e35\System.Web.Abstracti ons.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Xml.Linq\3.5. 0.0__b77a5c561934e089\System.Xml.Linq.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Users\DEVELOPER\AppData\Local\Temp\Temporary ASP.NET Files\root\61173f14\183a49fa\App_global.asax.2sgny f66.dll', Symbols loaded.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\SMDiagnostics\3.0.0. 0__b77a5c561934e089\SMDiagnostics.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'A_0498ae76_bf5e_4032_9f0c_5c615f2bc8e8'
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'M_0498ae76_bf5e_4032_9f0c_5c615f2bc8e8'
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Users\DEVELOPER\AppData\Local\Temp\Temporary ASP.NET Files\root\61173f14\183a49fa\App_Web_qbqelvtc.dll' , Symbols loaded.
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'Anonymously Hosted DynamicMethods Assembly'
'iisexpress.exe' (Managed (v2.0.50727)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Data.Linq\3.5 .0.0__b77a5c561934e089\System.Data.Linq.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
The program '[4568] iisexpress.exe: Managed (v2.0.50727)' has exited with code 0 (0x0).

Kind thanks for assistance :)