Is it possible to read .db files without database toolkit?

[Eric1977]

http://www.connectionstrings.com/

[JBoydFL]

---

@tst wrote:

---

The DB toolkit can't read ANY file. It uses ADO or ODBC,....

---

Yes, Ok, but you know what I meant

---

tst wrote:

In the case of SQLite, you need to find and install a small free driver which provide ODBC support, which then allows you to access it through ODBC.

---

Ah ... I was hoping I didn't need to do that, but that's good to know.  I'll try that, but the toolkit mentioned above may work out too.  Thanks !

[JBoydFL]

---

@Eric1977 wrote:

http://www.connectionstrings.com/

---

I have been there and have tried lots and lots of the examples, but no joy   ... yet

[Dennis_Knutson]

Can you connect with the odbc administrator utility? You can also right click in Windows Explorer and create a udl file. If that works, you have your connection string.

[dkfire]

So what have you tried ?

Did you install the ODBC drivers for SQLite ?

Did you try this string:
DRIVER=SQLite3 ODBC Driver;Database=c:\mydb.db;LongNames=0;Timeout=1000;NoTXN=0;
SyncPragma=NORMAL;StepAPI=0;

What was the errors when you tried all these steps?

[JBoydFL]

Sorry, bad SQL query ... fixed here...

[JBoydFL]

---

@dkfire wrote:

Did you install the ODBC drivers for SQLite ?

---

I can't at the moment, no admin privilege

It's at this link, right?

http://www.ch-werner.de/sqliteodbc/

---

@dkfire wrote:

Did you try this string:
DRIVER=SQLite3 ODBC Driver;Database=c:\mydb.db;LongNames=0;Timeout=1000;NoTXN=0;
SyncPragma=NORMAL;StepAPI=0;

---

No that's one of the millions of connection strings I haven't tried, not one of the hundreds I did try  ... if I request admin privilege for my PC, I can try that.  OTOH, I would like to find an option that doesn't require admin privilege on the customers' end.

[tst]

---

@JBoydFL wrote:

OTOH, I would like to find an option that doesn't require admin privilege on the customers' end.

---

If that's a requirement, then you're going to have to use the toolkits which call the DLL directly, as that's the only thing which doesn't require installation. That said, shouldn't you already have admin priviliges to install your application? Why can't the DB driver be part of that installation?

[JBoydFL]

I was hoping to keep the installation simple by limiting it to just our one LabVIEW application.  But "SQLite ODBC Driver" may be the only way for us to go, since I'm having issues with "SQLite for OpenG" handling some of our more complex queries.  And even "SQLite Browser" on the target machine does not support "RIGHT JOIN", for example.

[JBoydFL]

---

@dkfire wrote:

Did you install the ODBC drivers for SQLite ?

---

Yes, on the target machine -- which has admin privilege but not LabVIEW, so I make an application on the LabVIEW development machine (no admin priv) and copy it over.

---

@dkfire wrote:

Did you try this string:
DRIVER=SQLite3 ODBC Driver;Database=c:\mydb.db;LongNames=0;Timeout=1000;NoTXN=0;
SyncPragma=NORMAL;StepAPI=0;

---

Yes, and it worked !  I see the needle in the haystack now -- way at the bottom of https://www.connectionstrings.com/sqlite/  Thanks...

-john