Recently I was helping a scripter out in one of the many scripting forums I frequent. He had a script that uses ADODB to parse information from a CSV file. It works fine on 32 bit platforms. But when he went to run it on an x64 platform, no luck. You’ll get an error about no provider found. And there isn’t. Microsoft did not port the 32 bit JET database drivers to the 64 bit platform, nor are there any plans to. The only 64 bit driver you’ll likely find installed by default is for SQL.<\/p>\n
If you have scripts that use code like this:<\/p>\n
objConnection.Open “Provider=Microsoft.Jet.OLEDB.4.0;” & _ objRecordset.Open “SELECT * FROM ” & strFile, _ they will not run on a 64 bit platform. Unless…..you run your script in 32 bit mode. To do this you need to use the versions of CSCRIPT.EXE or WSCRIPT.EXE that reside in %WINDIR%\\SysWOW64:<\/p>\n %windir%\\syswow64\\cscript c:\\scripts\\parsecsv.vbs<\/font><\/p>\n This should work. In the SysWOW64 directory you should see a number of odbc 32 bit drivers. If you run odbcad32.exe from this directory you should see all your familiar drivers. <\/p>\n So, you can still use your old scripts; they just have to be run in 32 bit mode. If you have other issues running your scripts on an x64 platform, please start a discussion thread at ScriptingAnswers.com<\/a>.<\/p>\n I’m just now getting into the 64 bit world myself so I expect there will be many more surprises.<\/p>\n<\/p>\n <\/p>\n Recently I was helping a scripter out in one of the many scripting forums I frequent. He had a script that uses ADODB to parse information from a CSV file. It works fine on 32 bit platforms. But when he went to run it on an x64 platform, no luck. You’ll get an error about no provider found.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-116","post","type-post","status-publish","format-standard","hentry","category-vbscript"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=116"}],"version-history":[{"count":0,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/116\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
“Data Source=” & strPathtoTextFile & “;” & _
“Extended Properties=”“text;HDR=YES;FMT=CSVDelimited”“”<\/p>\n
objConnection, adOpenStatic, adLockOptimistic, adCmdText<\/font><\/p>\n