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.
This topic is 6 years and 4 days old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked
paulbrown@emerson.com
Posts: 1
Last visit: Wed Nov 07, 2018 8:42 am

ADODB error

Post 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."
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Re: ADODB error

Post by jvierra »

Perhaps you need to run as 32 bit for FP. Almost no installations are 64 bit.
This topic is 6 years and 4 days old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked