Hi, Hope someone can help.
I’m trying t access sqllite database via vbscript. I don’t want to use odbc just ado.net. I’ve downloaded the and installed ado.net driver for .net 3.5 from this site <http://system.data.sqlite.org/index.html/logo> http://system.data.sqlite.org Both 64 and 32 bit versions but I cannot get it to work in my script. This is the sort of thing I’ve tried. Set objConn = CreateObject("ADODB.Connection") objConn.Open = "Provider=System.Data.SQLite; Data Source=C:\DATA\SQLLite\mydb.db3" I get the error “Provider cannot be found. It may not be properly installed” How can I confirm the driver is properly installed? And Is my syntax correct? Can anyone help? Suggest other drivers? Anything? Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
