Custom OLEDB provider - Non-nullable column cannot be updated to N
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Folks,
I have written a custom OLEDB provider using ATL for our own data.
The metadata (list of tables and columns) as well as the data seem to be
coming through when this provider is used with Excel 2007.
However, when I use a third party reporting product, I am running into an
error when metadata fetch request is made. The error is "Non-nullable column
cannot be updated to Null."
The column that I am returning is indicated as containing nulls:
memset(&col, 0, sizeof(ATLCOLUMNINFO));
col.dwFlags = DBCOLUMNFLAGS_ISFIXEDLENGTH | DBCOLUMNFLAGS_ISNULLABLE;
....
A little background on the reporting product. It has two modes to build
query - designable mode and advanced mode. In the designable mode, you use
drag-n-drop to build the query. In the advanced mode, you just type the SQL
statement.
The provider is working as expected in the advance mode. The data is being
fetched for the specified SQL query.
The error happens when I am in the design mode and a request to get the list
of tables is made.
I would appreciate it someone can suggest me what is it that I am missing.
Thank you in advance for your help.
Regards,
Peter
.
Relevant Pages
- Re: Finally which ORM tool?
... method used INSIDE the query is passed as the value immediately, ... That's also info not NEEDED to write correct queries on the ... Sequence and set aren't equal, true, but in this case, where linq ... to use the subquery train, I have to use joins, or rely on the provider ...
(microsoft.public.dotnet.languages.csharp) - Re: Finally which ORM tool?
... of a query;), hence my question. ... IEnumerabledirectly but instead having an Execute method taking ... But it's not a problem with LINQ itself. ... Every Linq provider will implement ...
(microsoft.public.dotnet.languages.csharp) - Re: sorting by a formula
... I currently do have a query setup that tries to get most of my ... Specifically what I have is a crosstab query with the first field ... displaying the provider and it is a row heading, ... has about 3 sets of formulas that total up the number of No responses. ...
(microsoft.public.access.reports) - Re: sorting by a formula
... Just create a new Row Heading in the crosstab with an expression ... Specifically what I have is a crosstab query with the first field ... query list the provider and then out to the side it list the total number ... has about 3 sets of formulas that total up the number of No responses. ...
(microsoft.public.access.reports) - Re: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The operation could
... JDBC to run a query against a linked server that uses our SQLOLEDB provider. ... I would suggest narrowing down the troubleshooting and trying your query through Query Analyzer. ...
(microsoft.public.sqlserver.jdbcdriver) |
|
