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 forum is a space to discuss coding in VBScript including Windows Script Host, WMI, ADSI, and technical issues related to development.

- Question about a licensed SAPIEN product? Post here: Product Support for Registered Users
- Question about a trial SAPIEN product? Post here: Former and Future Customers - Questions
This topic is 7 years and 2 weeks 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
  • Print view
    • paulbrown@emerson.com
    Posts: 1
    Last visit: Wed Nov 07, 2018 8:42 am
    Answers: 0

    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."
    Top
    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.
    Top
    This topic is 7 years and 2 weeks 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
  • Print view

    • Return to “VBScript”