none
Field being truncated when returned from OleDBCommand RRS feed

  • Question

  • This is a very strange situation.
    
    Using OLEDB in C# I query a MS Project file. If I select ONLY the Project 
    field (which returns the filename and path), then I get the entire filename 
    and path back.
    
    However, if I query multiple fields, including Project, then the filename is 
    truncated.
    
    Example queries:
    
    SELECT Project FROM Project
    
    SELECT Project, ProjectTitle FROM Project
    
    The first query works, the second one returns only about half of the path 
    for the Project field.
    
    I'm using C#, an OleDBCommand to execute the query, and a DataReader to read the data.

     

    Tuesday, November 6, 2007 8:01 PM

All replies

  • Actually, I've tried this with several different data sources and the result is the same with all of them, so it appears to be an issue with the Project OLEDB provider.

     

    Still, if anyone knows of what the issue is or a solution I would greatly appreciate it.

     

    Tuesday, November 6, 2007 10:32 PM