in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Invalid storage type: DBNull

Last post 01-18-2007 5:57 PM by Taffarel. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-18-2007 5:12 PM

    Invalid storage type: DBNull

    I have a DB with a single table in it, and I'm trying to SELECT * from that table; but when I use a SQLiteDataAdapter to fill my DataTable, I keep getting this exception:

    Invalid storage type: DBNull

    I saw one post in this forum that suggested it might be related to UTF-8 vs. UTF-16 modes; but I have not specified this mode in my connection string, nor did I specify it when I created the DB. So I assume that UTF-8 (the default setting) is being used, right? So then why do I keep getting this exception?

    Perhaps I've just missed something in my code, since no one else seems to be complaining about it. Any help would be appreciated. Thanks!

    BTW - WinXP 32-bit, VS2005 SP1, SQLite 1.0.39.1

  • 01-18-2007 5:26 PM In reply to

    Re: Invalid storage type: DBNull

    First thing I need to see is the database schema for the table(s) involved in the query, and the query itself ...

    Robert

     

  • 01-18-2007 5:57 PM In reply to

    Re: Invalid storage type: DBNull

    Here is the SQL I used to create the table (converted from PL/SQL because it's my first time with SQLite):

    CREATE TABLE ORG_SITE_RENT_OBJECTS (UNIT_ID          NUMBER(18),
                                        SITE_ID          NUMBER(18),
                                        SITE_CLASS_ID    NUMBER(18),
                                        TAX_GROUP_ID     NUMBER(18),
                                        LEASE_GROUP_ID   NUMBER(18),
                                        RES_GROUP_ID     NUMBER(18),
                                        DEP_GROUP_ID     NUMBER(18),
                                        UNIT_NUMBER      VARCHAR2(20),
                                        WIDTH            NUMBER(10,2),
                                        DEPTH            NUMBER(10,2),
                                        HEIGHT           NUMBER(10,2),
                                        VOLUME           NUMBER(10,2),
                                        ATTRIBUTE01      NUMBER(3),
                                        ATTRIBUTE02      NUMBER(3),
                                        CLIMATE          NUMBER(3),
                                        DOOR             NUMBER(3),
                                        ACCESS_TYPE      NUMBER(3),
                                        DEL_MODEL_ID     NUMBER(18),
                                        ADMIN_FEE        NUMBER(7,2),
                                        FEATURES         NUMBER(3),
                                        SERIAL01         NUMBER(18),
                                        SERIAL02         NUMBER(18),
                                        NOTES            VARCHAR2(500),
                                        STATUS           NUMBER(3),
                                        WALK_THRU_ORDER  NUMBER(7),
                                        LINK_ID          NUMBER(18),
                                        VERSION          NUMBER(15,1),
                                        CREATED          VARCHAR2(200),
                                        CREATED_BY       NUMBER(18),
                                        UPDATED          VARCHAR2(200),
                                        UPDATED_BY       NUMBER(18),
                                        DB_CREATE        NUMBER(38),
                                        DB_UPDATE        NUMBER(38),
                                        MUX              NUMBER(7),
                                        ALARM            NUMBER(7))

    To retrieve the data, I'm simply using SELECT * FROM ORG_SITE_RENT_OBJECTS.

Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems