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 »

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."

Posts: 14668
Joined: Tue May 22, 2007 9:57 am
Answers: 5
Has voted: 1 time
Been upvoted: 5 times

Re: ADODB error

Post by jvierra »

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