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
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
MsgBox "Not Connected"
If Err.Number <> 0 Then