The SQL statement cannot be represented - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

The SQL statement cannot be represented

Last post 12-14-2006 07:30 AM by Matt Faus. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 12-13-2006 03:20 AM

    The SQL statement cannot be represented

    Reply Contact
    Hi,
    I am trying to link to a database on a shared drive within my network and just getting the error message "The SQL statement cannot be represented as a tree view. To remove the SQL statement, click Edit SQL, and then delete the statement."

    If the database is impoorted onto a blank database on my C: I do not get this problem. Is there something I am doing wrong or is there a way around this.

    PLEASE Help
    Keith Brittain

  • 12-13-2006 11:24 PM In reply to

    Re: The SQL statement cannot be represented

    Mark as Answer
    Reply Contact
    Hi Keith,
    I have read your post twice, but I have no idea. Sorry!
    Patrick Halstead
    Project Manager at Qdabra

  • 12-14-2006 07:30 AM In reply to

    Re: The SQL statement cannot be represented

    Mark as Answer
    Reply Contact
    Sometimes InfoPath needs to see some sample data so that it can derive a schema for the DB - maybe this is the problem?
    Matt Faus / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.