Byte Field Value is returning as unreadable format in vb 6.0

General
Enthusiast

Byte Field Value is returning as unreadable format in vb 6.0

Byte Field value is coming not in readable format using ADO 2.8 Object Library in VB 6.0, It returning like Box Symbol with "?" Symbol , it is not in readable format after that i checked in Teradata SQL Assistant, in that byte field is returning value in readable format. And i am very sure this problem is not happened due to my code problem and it is not a problem of ADO Object Library also. ADO will Connect the Teradata Driver and pass query to Terdata Driver, finally driver will return the results of the query.

Teradata Driver Version is 13.10.00.07

Teradata Database Version is 13.10

If anyone has come across this issue please let me know or Any ways to get. Please help me out. It is very urgent

I mentioned the vb code which i used for fetching byte field value.

Dim rs As New ADODB.Recordset
Dim con As New ADODB.Connection

Private Sub CmdSubmit_Click()
On Error GoTo ErrorTrap
    Set con = Nothing
    Dim strConnstr As String
    strConnstr = "DSN=" & TxtDsnName.Text & "; Server=" & TxtServerName.Text & "; Database=" & TxtDatabaseName.Text & "; UID=" & TxtUserID.Text & "; PWD=" & TxtPassword.Text
    con.Open strConnstr
    If Adocon.State = 1 Then
        Set rs = Nothing
        rs.Open "Select UserID from dbc.dbqlogtbl", con
        If rs.EOF = False Then
            TxtResult.Text = rs.Fields(0).Value
        End If
    Else
        MsgBox "Not Connected"
    End If
    Exit Sub
ErrorTrap:
    If Err.Number <> 0 Then
        MsgBox Err.Description
    End If
End Sub

1 REPLY
Enthusiast

Re: Byte Field Value is returning as unreadable format in vb 6.0

Byte Field Value is not returning as readable format in C#.Net Application

 

Teradata Driver Version is 13.10.00.07

Teradata Database Version is 13.10

If anyone has come across this issue please let me know or Any ways to get. Please help me out. It is very urgent