System.__ComObject

i am new to vb and am using Visual Studio 2005 and connecting to an Access Database to build a simple web application. The code below is within the click event of a button.

Dim SqlCmdAsNew ADODB.Command

Dim connAsNew ADODB.Connection

Dim rstAsNew ADODB.Recordset

conn.ConnectionString ="some connstring"

conn.Open()

SqlCmd.ActiveConnection = conn

SqlCmd.CommandText ="some sql"

rst.Source = SqlCmd

rst = SqlCmd.Execute

Dim recordAs ADODB.Record

record = rst("Year")

Response.Write(record)

The output I get is "System.__ComObject", can anyone help me with this as I am losing my mind, many thanks

[1542 byte] By [MartinMcL] at [2007-12-22]

.NET Development

Site Classified