vendredi 6 mai 2016

How to connect an sqlite database in javascript ASP

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);  

Aucun commentaire:

Enregistrer un commentaire