On Wed, Nov 15, 2017 at 7:14 PM, Paul H. Tarver paul@tpcqpc.com wrote:
Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to Bypass The 2GB .DBF Filesize Limit" for a project I'm trying to develop and I have some weird behavior going on.
I read that book, too! <g>
If I create a DSN using the ODBC drive and then use SQLCONNECT('dsn-name'), the connection is made and if the database file "trnslate.db" doesn't already exist it is created in the folder I designated in the Database Name field of the DSN.
That's good.
However, if I create DSN-Less connection (SQLSTRINGCONNECT) using the connection string I get back using SQLGETPROP(lnhandle,"ConnectString") , I get a handle, but it is to a "trnslate.db" database that doesn't contain the table I previously created and if the "trnslate.db" table doesn't already exist in the designated folder, it is NOT created on the hard drive. However, it apparently IS created in memory. I can create a table and issue a select command and get back the results I expect, but a database file is NEVER physically created on the hard drive which I need to do for my purposes.
/*snip*/
HELP!
I'm away from Windows machines right now. Let me check into this later in the day.