ODBC and large data

[ey316]

I'm having this problem with my ODBC database objects. I have a field in the database that stores 2000 characters. However, whenever I extract very long data from it using Microsoft.Data.Odbc objects, I get an incomplete data.

Example, say I have a record in the database wherein that field contains 500 characters. When I retrieve it, I only get the first 25 characters.

Any ideas? Is there a way I can configure my ODBC driver to handle larger data? Thanks in advance.

[Lord_Rat]

Anything under 4k is not an ODBC driver issue.

What database is it stored on and what is the code that does the extraction?

[ey316]

The database is Interbase. I think it's not a database problem because when I tried querying the data directly from Interbase, it returns the entire string.

Anyway, here's the code:

public DataSet GetRemarks(string sku, long entryDate)
{
connection.Open();
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = connection;
cmd.CommandText = "SELECT * FROM " + TableName + " " +
"WHERE " + Fields.EntryDate + " = " + entryDate +
"AND " + Fields.SKU + " = '" + sku + "' "+
"ORDER BY " + Fields.EntryDate + ", " + Fields.LineNum;

OdbcDataAdapter da = new OdbcDataAdapter(cmd);
OdbcDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Console.WriteLine(dr.GetString(5));
}
return dr;
}

[ey316]

The database is Interbase. I think it's not a database problem because when I tried querying the data directly from Interbase, it returns the entire string.

Anyway, here's the code:

public DataSet GetRemarks(string sku, long entryDate)
{
connection.Open();
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = connection;
cmd.CommandText = "SELECT * FROM " + TableName + " " +
"WHERE " + Fields.EntryDate + " = " + entryDate +
"AND " + Fields.SKU + " = '" + sku + "' "+
"ORDER BY " + Fields.EntryDate + ", " + Fields.LineNum;

OdbcDataAdapter da = new OdbcDataAdapter(cmd);
OdbcDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Console.WriteLine(dr.GetString(5));
}
return dr;
}

[Lord_Rat]

Place a break point on your console.writeline and when it breaks there, add a watch to your dr object.

Does the watch show the full text within the object?

[ey316]

yes. i already tried that. it does not show the full text. that's the reason why i thought it's related with the odbc driver. because immediately after retrieving the records from the database using odbc objects, the large strings surprisingly become shortened.