ADODB error
Posted: 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."
'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."