vbs 64 bit csv connection error

Posted on 2012-09-13
Last Modified: 2012-09-13
I currently have a nightly job that reads a csv file and then applies a few equations and imports into a msSQL server express. We we are moving to a Win 7 64 bit computer and having issues with the script.

Below is the connection string we use in 32 bit:

sconnstring= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\xml;Extended Properties=""text;HDR=Yes;FMT=Delimited"""

This is the error we are getting:
"Provider cannot be found. It may not be properly installed"

Access is not installed on this machine.

Thanks in advance for any assistance.
Question by:panhead802
    LVL 89

    Expert Comment

    by:John Hurst
    What operating system are you moving from?  XP perhaps?  Compared to (say) XP, Windows 7 Pro 64-bit institutes much more security. You generally cannot write files in Program Files, Programs Files (X86), and Windows.

    Are you trying to write data into a restricted area?  And if so, you need to change the folder you use for this activity.

    ... Thinkpads_User

    Author Comment

    XP 32 bit to Windows 7 64 bit. The write part is no problem as the data is being pushed into a SQL server. I also have another script that reads data from a SQL server and generates an XML file.

    It is reading from a csv file that throws the error.

    LVL 89

    Expert Comment

    by:John Hurst
    Can you read the CSV with Excel?  That is, is the Read operation having a permission issue?  Or is there a change in the CSV file?  

    If it is an SQL error, I cannot help with that part. .... Thinkpads_User

    Author Comment

    I can read the file with Excel, There is no issue with SQL. The connection string works on a 32 bit XP machine. I have stripped everything out of the script except the connection string and a msgbox to output each record.

    It is an error with the Microsoft.Jet.OLEDB.4.0 driver and I am not sure how to solve.
    LVL 89

    Expert Comment

    by:John Hurst
    Thanks. We are into an area where I have little expertise. Sorry.

    I do see the following Microsoft article about updating the Jet driver.

    You may need to update for your current machine.  ... Thinkpads_User
    LVL 35

    Accepted Solution

    I have run into this in the past and not been able to get JET to work on 64 bit, although there may have been an update since.

    Alternatively, download and install the 32 bit (I think necessary because you use vbs) ACE driver from here:

    Then change the provider in your connection string to:
    sconnstring= "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\xml;Extended Properties=""text;HDR=Yes;FMT=Delimited"""

    Open in new window

    The biggest problem with that is you have to choose 32 or 64, they can't work side by side i think but you already said Access is not on the server so that shouldn't be a problem.

    Author Closing Comment

    Worked perfectly. Thank you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Suggested Solutions

    Title # Comments Views Activity
    endX challenge 2 31
    A macro to Count the number of rows across all worksheets 3 47
    mapAB Challlenge 35 46
    Check version 13 38
    This article will show, step by step, how to integrate R code into a R Sweave document
    If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now