• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 833
  • Last Modified:

vbs 64 bit csv connection error

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.
0
panhead802
Asked:
panhead802
  • 3
  • 3
1 Solution
 
JohnBusiness Consultant (Owner)Commented:
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
0
 
panhead802Author Commented:
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.

Thanks
0
 
JohnBusiness Consultant (Owner)Commented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
panhead802Author Commented:
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.
0
 
JohnBusiness Consultant (Owner)Commented:
Thanks. We are into an area where I have little expertise. Sorry.

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

http://support.microsoft.com/kb/239114

You may need to update for your current machine.  ... Thinkpads_User
0
 
Robert SchuttSoftware EngineerCommented:
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: http://www.microsoft.com/en-us/download/details.aspx?id=13255

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.
0
 
panhead802Author Commented:
Worked perfectly. Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now