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