SQl Statement returns value "System.Byte[]"

[snufse]

I have a sql select, and some of the fields have return value of "System.Byte[]". Fields are all character and they all have values. Can anyone explain what this means? Thank you.

[AIS4U]

snufse:

It is kind of hard for anyone to speculate about your SQL select statement without seeing your code.

Also, it might be helpful to know what type of database you are using.

[snufse]

I am connecting to db2 retrieving a single record.

Here is the code:

Dim MyConnection As Odbc.OdbcConnection = New Odbc.OdbcConnection
        MyConnection.ConnectionString = "Driver={Client Access ODBC Driver (32-bit)};System=vgsys400;Uid=vgwprja;Pwd=ammt7584;"
        MyConnection.Open()
 
        Dim MyCommand As Odbc.OdbcCommand = New OdbcCommand
        MyCommand.CommandText = "SELECT YAALPH from VGIPRDHRP.F060116 where YAAN8 =" + EmpCode.ToString
        MyCommand.CommandType = CommandType.Text
        MyCommand.ExecuteScalar()
 
        Dim MyAdapter As New Odbc.OdbcDataAdapter
        MyAdapter.SelectCommand = MyCommand
        Dim MyDataSet As New DataSet
        Dim MyDataTable As New DataTable
 
        MyAdapter.Fill(MyDataTable)
        TextBox1.Text = MyDataTable.Rows(0).Item(0).ToString
        
        MyConnection.Close()

[snufse]

Solution:

When connecting to db2 and selecting data and a field value is represented as binary or hexdecimal data is normally not translated. Following will solve this problem. In the connection string insert following: "Translate=1".

So my complete connection string now reads:

MyConnectionString = "Driver={Client Access ODBC Driver (32-bit)}; System=vgsys400; Translate=1; Uid=vgwprja; Pwd=ammt7584;"

This will solve the problem.

[xhimi69]

10 years later, you saved the day for me