ADODB error

Anything VBScript-related, including Windows Script Host, WMI, ADSI, and more.
Forum rules
Do not post any licensing information in this forum.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
Posts: 1
Joined: Fri Oct 26, 2018 11:14 am

ADODB error

Post by » Wed Oct 31, 2018 2:46 pm

I just upgraded from PrimalScript 2009 and my script works fine, but not in new version 2018. I am connecting to Foxpro database using

'Connection String for FoxPro
Set SBTConn = CreateObject("ADODB.Connection")
Set TablesSchema = CreateObject("ADODB.Recordset")
Set adoCmd = CreateObject("ADODB.Command")
SBTConn.Provider = "vfpoledb.1"
SBTConn.Open "DSN=SBT"

I get this error "ADODB.Connection: Provider cannot be found. It may not be properly installed."

User avatar
Posts: 13802
Joined: Tue May 22, 2007 9:57 am

Re: ADODB error

Post by jvierra » Wed Oct 31, 2018 2:53 pm

Perhaps you need to run as 32 bit for FP. Almost no installations are 64 bit.