Am 27.10.2013 08:41, schrieb Joe Fuller:
I’m trying t access sqllite database via vbscript.
I don’t want to use odbc just ado.net.
I'm pretty sure vbScript doesn't support .NET class-instancing directly,
vbScript wants COM-(Dlls, to instantiate classes from).
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”
With your above: CreateObject("ADODB.Connection")
you create a "classic ADO" (COM) Connection-instance.
Well, what I do know for sure is, that such an ADO.COM instance can work
with the ODBC-driver you find here: http://www.ch-werner.de/sqliteodbc/
(proper connection-string: "DRIVER=SQLite3 ODBC Driver;Database=test.db"
Not sure, if the .NET-wrapper you mentioned can be accessed as a COM-
Object because it was compiled with the "COM Accessible" options -
and then in turn properly registered - but I'd doubt it.
Also not sure, if this wrapper possibly comes with an OleDB-Driver you
could use with classic ADO and the connection-string you've shown above:
("Provider=System.Data.SQLite; Data Source=C:\DATA\SQLLite\mydb.db3")
But I'd doubt that too (your error-message already hints at that).
Olaf
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
