SQlite db remote file Connection

Question

I have a SQLite DB hosted on my local network

I want to connect to these SQLite DB through python with the following code

import sqlite3

conn = sqlite3.connect('http://172.24.3.171:18080/db/SCdatabase.sq3')
cursor1 = conn.execute("select* from OlcConfig_Actual where LogReporterPointer = '1970-01-01T00:00:00Z'")

rows = cursor1.fetchall()
lista =[]

if len(rows) >= 1:
    for eachrow in rows:

        for eachcol in eachrow:
               lista.append(str(eachcol))

    print lista

print "Opened database successfully";

But I get an error that says:

OperationalError: unable to open database file

Can someone help me out with the error on the code?

Larry Lustig · Accepted Answer · 2014-11-01 14:39:27Z

1

SQlite does not communicate over HTTP, it requires a file on your local file system. If you can "reach" your file with ls (on *X) or dir (on Windows) then use the full path to the file in your connect statement.

answered Nov 1, 2014 at 14:39

Larry Lustig

51.2k16 gold badges119 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQlite db remote file Connection

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related