I am querying 4D-Server, a Macintosh database, from .NET (c#). I have installed 4D odbc driver on my machine. In .NET I am using Odbc Data Provider and accessing with DataSet. I am applying a simple SELECT query and the momemt I call dataadapter.Fill method, I get the following exception:
=================================================
1/26/2007 1:21:31 PM: Executing Query...
EXCEPTION OCCURRED while executing query with DataSet: System.Data.Odbc.OdbcException: ERROR [S1000] [Simba][Simba ODBC Driver][Codebase File Library]
at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode)
at System.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C sqlctype, Int32 cb)
at System.Data.Odbc.OdbcDataReader.internalGetString(Int32 i)
at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i, TypeMap typemap)
at System.Data.Odbc.OdbcDataReader.GetValue(Int32 i)
at System.Data.Odbc.OdbcDataReader.GetValues(Object[] values)
at System.Data.Common.SchemaMapping.LoadDataRow(Boolean clearDataValues, Boolean acceptChanges)
at System.Data.Common.DbDataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at Test4DServer.Form2.btnExecuteDS_Click(Object sender, EventArgs ev)
=================================================
The query was:
SELECT Description_Long FROM ProdMkt
The Description_Long column type is 'text'.
This is the only column which is giving exception... other columns in the query just run fine.
Note: I accessed the data of this Description_Long column from DTS and didn't find any problem.
I also copied the contents of Description_Long column from 4D Server into a temporary table in SQL Server and accessed it in the same way using odbc data provider but didn't get such error.
Has anyone experienced similar problem and have any suggestions on how to correct this?
Regards,
Kamran