<div>
See the accepted solution here and see if it helps:<br />
<a href="https://www.experts-exchange.com/questions/27587886/Microsoft-Jet-OLEDB-4-0-in-a-Logon-Script.html?anchorAnswerId=37795001#a37795001" rel="ugc">https://www.experts-exchange.com/questions/27587886/Microsoft-Jet-OLEDB-4-0-in-a-Logon-Script.html?anchorAnswerId=37795001#a37795001</a><br />
<br />
Regards,<br />
<br />
Rob.
</div>


<div>
Thanks, Rob, but I don't think that gives me what I need. &nbsp;I think I need an example of how you use a driver other than Jet to open a CSV file in vbScript so that this is able to run on Windows Server 2008 R2. &nbsp;If there's some alternative construct that can be used to cycle through the CSV file, then I think I'm good to go.
</div>


<div>
Thanks for the grade. &nbsp;If you need assistance rewriting your code, let me know.<br />
<br />
Rob.
</div>


<div>
<div class="content wysiwyg-content">
I have a VB Script script that used to work on Windows Server 2003, but now it won't work in 2008. &nbsp;It uses Jet to read a CSV file. &nbsp;The lines that are failing are as follows:<br />
<br />
set oConnection = createobject(&quot;adodb.connec<wbr />tion&quot;)<br />
set oRecordSet = createobject(&quot;adodb.record<wbr />set&quot;)<br />
oConnection.open &quot;Provider=Microsoft.Jet.OL<wbr />EDB.4.0;Da<wbr />ta Source= &quot;&nbsp;&amp; sCSVFileLocation &amp;&nbsp;&quot;;Extended Properties=&quot;&quot;text;HDR=yes;<wbr />FMT=Delimi<wbr />ted&quot;&quot;&quot;<br />
oRecordSet.open &quot;SELECT * FROM &quot;&nbsp;&amp; sCSVFile ,oConnection<br />
<br />
How can I make this work in 2008 R2? &nbsp;Thanks.
</div>
</div>


I have a VB Script script that used to work on Windows Server 2003, but now it won't work in 2008.  It uses Jet to read a CSV file.  The lines that are failing are as follows:

set oConnection = createobject("adodb.connection")
set oRecordSet = createobject("adodb.recordset")
oConnection.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & sCSVFileLocation & ";Extended Properties=""text;HDR=yes;FMT=Delimited"""
oRecordSet.open "SELECT * FROM " & sCSVFile ,oConnection

How can I make this work in 2008 R2?  Thanks.

See the accepted solution here and see if it helps:
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/Q_27587886.html#a37795001

Regards,

Rob.

Thanks, Rob, but I don&#39;t think that gives me what I need.  I think I need an example of how you use a driver other than Jet to open a CSV file in vbScript so that this is able to run on Windows Server 2008 R2.  If there&#39;s some alternative construct that can be used to cycle through the CSV file, then I think I&#39;m good to go.

Thanks for the grade.  If you need assistance rewriting your code, let me know.

Rob.

Read CSV file in VBScript on Windows Server 2008 R2

I have a VB Script script that used to work on Windows Server 2003, but now it won&#39;t work in 2008.  It uses Jet to read a CSV file.  The lines that are failing are as follows:

set oConnection = createobject(&quot;adodb.connection&quot;)
set oRecordSet = createobject(&quot;adodb.recordset&quot;)
oConnection.open &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source= &quot; &amp; sCSVFileLocation &amp; &quot;;Extended Properties=&quot;&quot;text;HDR=yes;FMT=Delimited&quot;&quot;&quot;
oRecordSet.open &quot;SELECT * FROM &quot; &amp; sCSVFile ,oConnection

How can I make this work in 2008 R2?  Thanks.

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.