Page 1 of 1

ADODB error

Posted: Wed Oct 31, 2018 2:46 pm
by paulbrown@emerson.com
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."

Re: ADODB error

Posted: Wed Oct 31, 2018 2:53 pm
by jvierra
Perhaps you need to run as 32 bit for FP. Almost no installations are 64 bit.