Database connectivity with MS Access in Microsoft Visual Studio .NET

[abhinavdua]

Hi All,

I am developing a intra-company website. I am working in MS Visual
Studio .NET, and am writing the code in VBScript.

I have an MS Access database with which i want to connect. Once the
connection is established, i want to retreive a particular record and
display one particular field of the record in a text box.

Given below is the concerned code snippet (the default.aspx.vb file):
Partial Class _Default
Inherits System.Web.UI.Page

Protected Sub Submit_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Submit.Click
Dim Conn
Dim rsAddRequest
Dim val

Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.Open(Server.MapPath("requests.mdb"))
rsAddRequest = Server.CreateObject("ADODB.Recordset")

rsAddRequest.CursorType = 2
rsAddRequest.LockType = 3

rsAddRequest.Open("Select * from request where
TrackingID='RR0004'", Conn)

Name.Text = rsAddRequest.Fields("RequesterName").ToString()

rsAddRequest.Close()
rsAddRequest = Nothing
Conn = Nothing
End Sub
End Class
The database is requests.mdb; the table is request, the field to be
displayed is RequesterName and the text boc is named Name.

The code given above diplays "System.__ComObject" in the text box.

And, if i remove the .ToString() part, then the error generated is
"Conversion from type 'Field' to type 'String' is not valid."

Please help me out as i am unable to figure where i am going wrong and
what is the solution. Please reply ASAP.

Thanks.

[David W. Fenton]

ab********@gmail.com wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:

I am developing a intra-company website. I am working in MS Visual
Studio .NET, and am writing the code in VBScript.

I have an MS Access database with which i want to connect

No, you have a Jet database that, perhaps, you created in MS Access.

Access is not involved -- only Jet. Jet and Access are two different
things. Learn the difference.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/