dimanche 8 mai 2016

Opening a sqlite database connection from asp

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>

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

Aucun commentaire:

Enregistrer un commentaire