![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | VB scripts seem to of stopped working since office 2007 Visual stu I have some scripts that i get the following error: Line: 21 Char: 1 Error: [Microsoft][ODBC Text Driver] Could not find installable ISAM. Code 80004005 Source: Microsoft OLE DB Provider For ODBC Drivers The script start is as follows: Option Explicit Dim rs, sDir, strConnect Dim iim1, iret set rs = createobject("ador.recordset") sDir = Replace(WScript.ScriptFullName, WScript.ScriptName, "") 'Get current directory strConnect = _ "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _ "DefaultDir=" & sDir & ";" Const adOpenStatic = 3 rs.open "select * from TPVBAddNewPSTNRecordNoOrder.csv", strConnect, adOpenStatic MsgBox "Input file information:" & vbCrLf & vbCrLf & _ "Recordcount: " & rs.recordcount & vbCrLf & vbCrLf & _ "Fields per record: " & rs.fields.count This same script works on another laptop i have, the only difference is that the one that does not work has had Office 2007 and visual studio 2008 (aqnd ms SQL server) installed. It is suggesting that connection strings are now different however i ran ms MDAC component checker version 2 and it says that there are 2 mismatched DLL's i thought that might help whoever looking into this: MSADCE.DLL Ver 2.81.3002.0 Expected version 2.81.1132.0 msxml3.dll ver 8.100.1048.0 Expected 8.90.1101.0 |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Start Menu Office 2007 shortcuts have stopped working | Vista performance & maintenance | |||
| 2007 Microsoft Office Word has stopped working | Microsoft Office | |||
| Microsoft office has stopped working | Vista General | |||
| Pointer stopped working in Office 2007 | Microsoft Office | |||
| Problem Report -Office Stopped Working - Office 2003 Pro | Vista General | |||