How to connect an sqlite database in javascript ASP

Question

Hi I've got this code which uses Access to open/store data in database. I need to convert this to use SQLite. However I'm finding it difficult to find the appropriate connection string. How should I go about doing this? Thanks

var dbaseConnection = Server.CreateObject("ADODB.Connection");          
var pathToDbase = Server.MapPath("contacts.mdb");            
var connectionString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + pathToDbase;
dbaseConnection.Open(connectionString);

This is just test code but I am trying to just read and display information from an sqlite database.

    <table>
        <tr><th>Name</th><th>Surname</th></tr>

        <%

              var dbaseConnection = Server.CreateObject("ADODB.Connection");


              var connectionString = "DRIVER=SQLite3 ODBC Driver; Database= path to test.db; LongNames=0; Timeout=1000; NoTXN=0; SyncPragma=NORMAL; StepAPI=0;";
              dbaseConnection.Open(connectionString);

              var query = "Select * from test order by name asc";
              var recordSet = dbaseConnection.Execute(query);


              while (!recordSet.Eof) {
                 Response.write("<tr><td>" + recordSet("name") + '</td><td>' + recordSet("surname") + "</td></tr>");
                 recordSet.moveNext();
              }

              recordSet.Close();
              dbaseConnection.Close();

        %>

    </table>
</body>

I am now getting this error Microsoft OLE DB Provider for ODBC Drivers error '80004005' connect failed. Any thoughts? I've activated 32 bit apps in IIS.

Ali Sheikhpour · Accepted Answer · 2016-05-06 15:01:37Z

1

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

Reference: https://www.connectionstrings.com/sqlite/

answered May 6, 2016 at 15:01

Ali Sheikhpour

11.4k5 gold badges53 silver badges100 bronze badges

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

1 Comment

John Over a year ago

That's only half the story though. The driver doesn't ship with Windows, you need to install it yourself. web.synametrics.com/SQLite.htm

Collectives™ on Stack Overflow

How to connect an sqlite database in javascript ASP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related