subject:"\[sqlite\] vbscript and sqlltie"

Re: [sqlite] vbscript and sqlltie

2013-10-29 Thread Olaf Schmidt

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 t

Re: [sqlite] vbscript and sqlltie

2013-10-28 Thread Tiago Rodrigues

Hi, Joe, Now, it's been years since I've touched VBScript, but I think the syntax of attributing the connection string to the Open method is wrong. You should probably use objConn.Open "Provider=System.Data.SQLite; Data Source=C:\DATA\SQLLite\mydb.db3" or (better) objConn.Open("Provider=System

[sqlite] vbscript and sqlltie

2013-10-27 Thread Joe Fuller

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 Both 64 and 32 bi