Can we see an example of the code that is giving you these results?

I'm new to ADO.NET so hopefully this problem will be easy for you lot.

I'be upgraded a VB6 project that uses standard ADO to .NET. I knew there would be upgrade issues, but I didn't mind 'cos I thought it would a good starting point.

I started by simply including the ADODB object so I didn't have to modify this code too much, but every field that I field from the recordset returns System._ComObject.

I concluded that it must be an issue with the old ADO and VB.NET. Sadly after slowly re-writing the code as ADO.NET i still get the same result - System._ComObject.

I think strictly speaking that the problem must have more to do with VB.NET rather that ADO.NET, but I'm hopeing this problem seems familiar to someone.

Cheers,
Mark

Public gazConnection As New SqlConnection
Public gazRecordSet As SqlDataReader

gazConnection.ConnectionString = "SERVER=SQUEEL;" & _
    "Initial Catalog=CityGaz;User Id=citygaz;" & _
    "Password=citygaz"
gazConnection.Open()

'Open recordset as per SQL
Dim cmd As New SqlCommand(mySQL)
gazRecordSet = cmd.ExecuteReader(CommandBehavior.CloseConnection)

Do While gazRecordSet.Read()
     myString = gazRecordSet("address")
Loop

This is the jist of it.
Cheers,
Mark

After buying a rather chunky text book, I've added a few lines of code that appears in it's examples. I'm sure of their significance right now, but they seem to do the trick. Everything is fine now.

Thanks to anyone who's trying to help, but it's sorted!

Cheers,
Mark

Hi there (Mark)!

I'm having the same problem, does anyone have a solution. THANKS!!!