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.
Post Reply
paulbrown@emerson.com
Posts: 1
Joined: Fri Oct 26, 2018 11:14 am

ADODB error

Post by paulbrown@emerson.com » 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
jvierra
Posts: 12895
Joined: Tue May 22, 2007 9:57 am
Contact:

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.

Post Reply