Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 805
  • 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
 
John HurstBusiness 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
 
John HurstBusiness 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
 
John HurstBusiness 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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