I have a text file that ends with .vbs that I have written the following in:

    Set Conn = CreateObject(&quot;ADODB.Connection&quot;)
    Conn.Provider = &quot;Microsoft.ACE.OLEDB.12.0&quot;
    Conn.Properties(&quot;Data Source&quot;) = &quot;C:\dummy.accdb&quot;
    Conn.Properties(&quot;Jet OLEDB:Database Password&quot;) = &quot;pass&quot;
    Conn.Open
    Conn.Close
    Set Conn = Nothing

- When I execute this on a Windows 32-bit machine it runs and ends without any notion (expected). 
- When I execute this on a Windows 64-bit machine it gets the error 
  &gt; Provider cannot be found. It may not be properly installed.

But it is installed. I think the root of the problem is that the provider is a 32-bit provider, as far as I know it doesn&#39;t exist as 64-bit.

If I run the VBScript through IIS on my 64-bit machine (as a ASP file) I can select that it should run in 32-bit mode. It can then find the provider.

How can I make it find the provider on Windows 64-bit? Can I tell CScript (which executes the .vbs text file) to run in 32-bit mode somehow?

All Adodb Solutions on Gang of Coders

Total of 1 Adodb Solutions

How do I run a VBScript in 32-bit mode on a 64-bit machine?