Connecting to a SQLServerCE database through vbscript

Is it possible to talk to a SQLServerCE database from a vbs script? If so, does anyone have an example?

Thanks,
Mike

Have a look at ADOCE: http://msdn2.microsoft.com/en-us/library/ms826696.aspx

Connecting to a named SQL2000 db instance from vbscript

My previous connection string looked like this:

strConnect = "Provider=SQLOLEDB.1;Password=Password=password;Per sistSecurity Info=True;User ID=TestUser;Initial Catalog=JabilDB;DataSource=corsqlv02;Use Procedure for Prepare=0"

The new connection string (that doesn't work) looks like this:

strConnect = "Provider=SQLOLEDB.1;Password=Password=password;Per sistSecurity Info=True;User ID=TestUser;Initial Catalog=JabilDBDev;DataSource=corsqlv02\JabilDB;Us e Procedure for Prepare=0"

Do i need to upgrade to the latest MDAC ?

Thanks

Digital_fXForget this. I just needed to install MDAC 2.6 and that solved the problem.

Cheers