Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
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.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - VB scripts seem to of stopped working since office 2007 Visual stu

Reply
 
Old 08-18-2009   #1 (permalink)
MoiD


 
 

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 SpecsSystem Spec
Reply

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


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46