MDAC 2.8 support in WinPE 2004 (sp2)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anybody know how to activate the ODBC Excel driver in
WinPE 2004 as ADO doesn't support Excel connectivity.

I've got it working in WinPE 1.2

I try to connect via a HTA application with an excel sheet
using the following code.

; Set cnObj = CreateObject("ADODB.Connection")
; Set rsObj = CreateObject("ADODB.Recordset")
;
; cnObj.Open "Driver={Microsoft Excel Driver(*.xls)};DBQ="
& strFrameWorkDB & ";ReadOnly=1"
;
; strSQL = "Select * from [DataSource$]"
;
; rsObj.Open strSQL, cnObj, adOpenStatic, adLockOptimistic

This will result in a hanging HTA application.

Thanks in advance,
 
The files in Program Files\Common Files\System changed between WinPE
1.2 and WinPE 2004. A lot of files were deleted from that folder, I
can imagine that might cause the issue.

You can try adding them back in WinPE 2004 (from XP SP2 media) and
register them.

regards
Johan Arwidmark

Windows User Group - Nordic
http://www.wug-nordic.net
 
I've added all the extra files to WinPE 2004 with the extra.inf file and
pointed the entries directly to the winXP sp2 source. (As far as possible).
The missing files are added manual to the temporary image creation folder.

The registration of the dll's is done with the OC2.bat file.

When I try to start my MDAC layer in WinPE 2004 with odbcad32.exe, I have
only a Oracle driver available. Version 1.2 of winPE will shows all the
additional drivers.

I'm lost here, no idea how to get the excel driver working.


The following extra files are added to my WinPE version.

=======================================
REM - INSTALL EXTRA MSJET FILES
Regsvr32 "%SystemDrive%\Program Files\Common Files\Microsoft
Shared\DAO\dao360.dll" /S
Regsvr32 %SystemRoot%\system32\expsrv.dll /S
Regsvr32 %SystemRoot%\system32\msexch40.dll /S
Regsvr32 %SystemRoot%\system32\msexcl40.dll /S
Regsvr32 %SystemRoot%\system32\msjet40.dll /S
Regsvr32 %SystemRoot%\system32\msjetoledb40.dll /S
Regsvr32 %SystemRoot%\system32\msjint40.dll /S
Regsvr32 %SystemRoot%\system32\msjter40.dll /S
Regsvr32 %SystemRoot%\system32\msjtes40.dll /S
Regsvr32 %SystemRoot%\system32\msltus40.dll /S
Regsvr32 %SystemRoot%\system32\mspbde40.dll /S
Regsvr32 %SystemRoot%\system32\msrd2x40.dll /S
Regsvr32 %SystemRoot%\system32\msrd3x40.dll /S
Regsvr32 %SystemRoot%\system32\msrepl40.dll /S
Regsvr32 %SystemRoot%\system32\mstext40.dll /S
Regsvr32 %SystemRoot%\system32\mswdat10.dll /S
Regsvr32 %SystemRoot%\system32\mswstr10.dll /S
Regsvr32 %SystemRoot%\system32\msxbde40.dll /S
Regsvr32 %SystemRoot%\system32\vbajet32.dll /S


REM - INSTALL EXTRA MSSQL FILES
Regsvr32 %SystemRoot%\system32\cliconfg.dll /S
Regsvr32 %SystemRoot%\system32\corpol.dll /S
Regsvr32 %SystemRoot%\system32\dbmsadsn.dll /S
Regsvr32 %SystemRoot%\system32\dbmsrpcn.dll /S
Regsvr32 %SystemRoot%\system32\dbnmpntw.dll /S
Regsvr32 %SystemRoot%\system32\ds16gt.dll /S
Regsvr32 %SystemRoot%\system32\ds32gt.dll /S
Regsvr32 %SystemRoot%\system32\mscpx32r.dll /S
Regsvr32 %SystemRoot%\system32\mscpxl32.dll /S
Regsvr32 %SystemRoot%\system32\mslbui.dll /S
Regsvr32 %SystemRoot%\system32\msorc32r.dll /S
Regsvr32 %SystemRoot%\system32\msorcl32.dll /S
Regsvr32 %SystemRoot%\system32\sqlsrv32.dll /S
Regsvr32 %SystemRoot%\system32\sqlunirl.dll /S


REM - INSTALL EXTRA ADO FILES
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msader15.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msadomd.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msador15.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msadox.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msjro.dll" /S


REM - INSTALL EXTRA MSADC FILES
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadce.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadcer.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadcf.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadcfr.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadco.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadcor.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadcs.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadds.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msaddsr.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msdarem.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msdaremr.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msdfmap.dll"
/S


REM - INSTALL EXTRA OLE DB FILES
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole db\msdadc.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaenum.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole db\msdaer.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaora.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaorar.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaosp.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole db\msdasc.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdasql.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdasqlr.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole db\msdatt.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaurl.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msxactps.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\sqlxmlx.dll" /S

REM - REGISTER ODBC DRIVERS
odbcconf.exe /S /Lv odbcconf.log /F %systemroot%\system32\odbcconf.rsp

=================================================





Johan Arwidmark said:
The files in Program Files\Common Files\System changed between WinPE
1.2 and WinPE 2004. A lot of files were deleted from that folder, I
can imagine that might cause the issue.

You can try adding them back in WinPE 2004 (from XP SP2 media) and
register them.

regards
Johan Arwidmark

Windows User Group - Nordic
http://www.wug-nordic.net




Does anybody know how to activate the ODBC Excel driver in
WinPE 2004 as ADO doesn't support Excel connectivity.

I've got it working in WinPE 1.2

I try to connect via a HTA application with an excel sheet
using the following code.

; Set cnObj = CreateObject("ADODB.Connection")
; Set rsObj = CreateObject("ADODB.Recordset")
;
; cnObj.Open "Driver={Microsoft Excel Driver(*.xls)};DBQ="
& strFrameWorkDB & ";ReadOnly=1"
;
; strSQL = "Select * from [DataSource$]"
;
; rsObj.Open strSQL, cnObj, adOpenStatic, adLockOptimistic

This will result in a hanging HTA application.

Thanks in advance,
Click to expand...
Click to expand...
 
There is more to it than just copying and registering the files. You
probably need to add registry keys under
"HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI" for the drivers that you
have copied; this is where ODBC determines the list of drivers that are
installed and available. (There may be other requirements as well - don't
be surprised if this doesn't completely solve the problem.)

-Michael Niehaus
Senior Consultant
MCS US Centers of Excellence - Deployment AOS
(e-mail address removed)
This posting is provided "AS IS" with no warranties, and confers no rights.

René said:
I've added all the extra files to WinPE 2004 with the extra.inf file and
pointed the entries directly to the winXP sp2 source. (As far as
possible).
The missing files are added manual to the temporary image creation folder.

The registration of the dll's is done with the OC2.bat file.

When I try to start my MDAC layer in WinPE 2004 with odbcad32.exe, I have
only a Oracle driver available. Version 1.2 of winPE will shows all the
additional drivers.

I'm lost here, no idea how to get the excel driver working.


The following extra files are added to my WinPE version.

=======================================
REM - INSTALL EXTRA MSJET FILES
Regsvr32 "%SystemDrive%\Program Files\Common Files\Microsoft
Shared\DAO\dao360.dll" /S
Regsvr32 %SystemRoot%\system32\expsrv.dll /S
Regsvr32 %SystemRoot%\system32\msexch40.dll /S
Regsvr32 %SystemRoot%\system32\msexcl40.dll /S
Regsvr32 %SystemRoot%\system32\msjet40.dll /S
Regsvr32 %SystemRoot%\system32\msjetoledb40.dll /S
Regsvr32 %SystemRoot%\system32\msjint40.dll /S
Regsvr32 %SystemRoot%\system32\msjter40.dll /S
Regsvr32 %SystemRoot%\system32\msjtes40.dll /S
Regsvr32 %SystemRoot%\system32\msltus40.dll /S
Regsvr32 %SystemRoot%\system32\mspbde40.dll /S
Regsvr32 %SystemRoot%\system32\msrd2x40.dll /S
Regsvr32 %SystemRoot%\system32\msrd3x40.dll /S
Regsvr32 %SystemRoot%\system32\msrepl40.dll /S
Regsvr32 %SystemRoot%\system32\mstext40.dll /S
Regsvr32 %SystemRoot%\system32\mswdat10.dll /S
Regsvr32 %SystemRoot%\system32\mswstr10.dll /S
Regsvr32 %SystemRoot%\system32\msxbde40.dll /S
Regsvr32 %SystemRoot%\system32\vbajet32.dll /S


REM - INSTALL EXTRA MSSQL FILES
Regsvr32 %SystemRoot%\system32\cliconfg.dll /S
Regsvr32 %SystemRoot%\system32\corpol.dll /S
Regsvr32 %SystemRoot%\system32\dbmsadsn.dll /S
Regsvr32 %SystemRoot%\system32\dbmsrpcn.dll /S
Regsvr32 %SystemRoot%\system32\dbnmpntw.dll /S
Regsvr32 %SystemRoot%\system32\ds16gt.dll /S
Regsvr32 %SystemRoot%\system32\ds32gt.dll /S
Regsvr32 %SystemRoot%\system32\mscpx32r.dll /S
Regsvr32 %SystemRoot%\system32\mscpxl32.dll /S
Regsvr32 %SystemRoot%\system32\mslbui.dll /S
Regsvr32 %SystemRoot%\system32\msorc32r.dll /S
Regsvr32 %SystemRoot%\system32\msorcl32.dll /S
Regsvr32 %SystemRoot%\system32\sqlsrv32.dll /S
Regsvr32 %SystemRoot%\system32\sqlunirl.dll /S


REM - INSTALL EXTRA ADO FILES
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\ado\msader15.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msadomd.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\ado\msador15.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msadox.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msjro.dll"
/S


REM - INSTALL EXTRA MSADC FILES
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msadce.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msadcer.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msadcf.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msadcfr.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msadco.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msadcor.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msadcs.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msadds.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msaddsr.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msdarem.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msdaremr.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msdfmap.dll"
/S


REM - INSTALL EXTRA OLE DB FILES
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdadc.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaenum.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaer.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaora.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaorar.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaosp.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdasc.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdasql.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdasqlr.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdatt.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaurl.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msxactps.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\sqlxmlx.dll" /S

REM - REGISTER ODBC DRIVERS
odbcconf.exe /S /Lv odbcconf.log /F %systemroot%\system32\odbcconf.rsp

=================================================





Johan Arwidmark said:
The files in Program Files\Common Files\System changed between WinPE
1.2 and WinPE 2004. A lot of files were deleted from that folder, I
can imagine that might cause the issue.

You can try adding them back in WinPE 2004 (from XP SP2 media) and
register them.

regards
Johan Arwidmark

Windows User Group - Nordic
http://www.wug-nordic.net




Does anybody know how to activate the ODBC Excel driver in
WinPE 2004 as ADO doesn't support Excel connectivity.

I've got it working in WinPE 1.2

I try to connect via a HTA application with an excel sheet
using the following code.

; Set cnObj = CreateObject("ADODB.Connection")
; Set rsObj = CreateObject("ADODB.Recordset")
;
; cnObj.Open "Driver={Microsoft Excel Driver(*.xls)};DBQ="
& strFrameWorkDB & ";ReadOnly=1"
;
; strSQL = "Select * from [DataSource$]"
;
; rsObj.Open strSQL, cnObj, adOpenStatic, adLockOptimistic

This will result in a hanging HTA application.

Thanks in advance,
Click to expand...
Click to expand...
Click to expand...
 
You can try firing up regmon and filemon from sysinternals (add pe to
harddrive first, or boot from a non-write proteced RIS image), launch
the script and then compare the logs between 1.2 and 2004. That might
lead you to what information is missing.

regards
Johan Arwidmark

Windows User Group - Nordic
http://www.wug-nordic.net


I've added all the extra files to WinPE 2004 with the extra.inf file and
pointed the entries directly to the winXP sp2 source. (As far as possible).
The missing files are added manual to the temporary image creation folder.

The registration of the dll's is done with the OC2.bat file.

When I try to start my MDAC layer in WinPE 2004 with odbcad32.exe, I have
only a Oracle driver available. Version 1.2 of winPE will shows all the
additional drivers.

I'm lost here, no idea how to get the excel driver working.


The following extra files are added to my WinPE version.

=======================================
REM - INSTALL EXTRA MSJET FILES
Regsvr32 "%SystemDrive%\Program Files\Common Files\Microsoft
Shared\DAO\dao360.dll" /S
Regsvr32 %SystemRoot%\system32\expsrv.dll /S
Regsvr32 %SystemRoot%\system32\msexch40.dll /S
Regsvr32 %SystemRoot%\system32\msexcl40.dll /S
Regsvr32 %SystemRoot%\system32\msjet40.dll /S
Regsvr32 %SystemRoot%\system32\msjetoledb40.dll /S
Regsvr32 %SystemRoot%\system32\msjint40.dll /S
Regsvr32 %SystemRoot%\system32\msjter40.dll /S
Regsvr32 %SystemRoot%\system32\msjtes40.dll /S
Regsvr32 %SystemRoot%\system32\msltus40.dll /S
Regsvr32 %SystemRoot%\system32\mspbde40.dll /S
Regsvr32 %SystemRoot%\system32\msrd2x40.dll /S
Regsvr32 %SystemRoot%\system32\msrd3x40.dll /S
Regsvr32 %SystemRoot%\system32\msrepl40.dll /S
Regsvr32 %SystemRoot%\system32\mstext40.dll /S
Regsvr32 %SystemRoot%\system32\mswdat10.dll /S
Regsvr32 %SystemRoot%\system32\mswstr10.dll /S
Regsvr32 %SystemRoot%\system32\msxbde40.dll /S
Regsvr32 %SystemRoot%\system32\vbajet32.dll /S


REM - INSTALL EXTRA MSSQL FILES
Regsvr32 %SystemRoot%\system32\cliconfg.dll /S
Regsvr32 %SystemRoot%\system32\corpol.dll /S
Regsvr32 %SystemRoot%\system32\dbmsadsn.dll /S
Regsvr32 %SystemRoot%\system32\dbmsrpcn.dll /S
Regsvr32 %SystemRoot%\system32\dbnmpntw.dll /S
Regsvr32 %SystemRoot%\system32\ds16gt.dll /S
Regsvr32 %SystemRoot%\system32\ds32gt.dll /S
Regsvr32 %SystemRoot%\system32\mscpx32r.dll /S
Regsvr32 %SystemRoot%\system32\mscpxl32.dll /S
Regsvr32 %SystemRoot%\system32\mslbui.dll /S
Regsvr32 %SystemRoot%\system32\msorc32r.dll /S
Regsvr32 %SystemRoot%\system32\msorcl32.dll /S
Regsvr32 %SystemRoot%\system32\sqlsrv32.dll /S
Regsvr32 %SystemRoot%\system32\sqlunirl.dll /S


REM - INSTALL EXTRA ADO FILES
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msader15.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msadomd.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msador15.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msadox.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\ado\msjro.dll" /S


REM - INSTALL EXTRA MSADC FILES
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadce.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadcer.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadcf.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadcfr.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadco.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadcor.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadcs.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msadds.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msaddsr.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msdarem.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common
Files\System\msadc\msdaremr.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\msadc\msdfmap.dll"
/S


REM - INSTALL EXTRA OLE DB FILES
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole db\msdadc.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaenum.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole db\msdaer.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaora.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaorar.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaosp.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole db\msdasc.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdasql.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdasqlr.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole db\msdatt.dll"
/S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msdaurl.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\msxactps.dll" /S
Regsvr32 "%SystemDrive%\Program Files\Common Files\System\Ole
db\sqlxmlx.dll" /S

REM - REGISTER ODBC DRIVERS
odbcconf.exe /S /Lv odbcconf.log /F %systemroot%\system32\odbcconf.rsp

=================================================





Johan Arwidmark said:
The files in Program Files\Common Files\System changed between WinPE
1.2 and WinPE 2004. A lot of files were deleted from that folder, I
can imagine that might cause the issue.

You can try adding them back in WinPE 2004 (from XP SP2 media) and
register them.

regards
Johan Arwidmark

Windows User Group - Nordic
http://www.wug-nordic.net




Does anybody know how to activate the ODBC Excel driver in
WinPE 2004 as ADO doesn't support Excel connectivity.

I've got it working in WinPE 1.2

I try to connect via a HTA application with an excel sheet
using the following code.

; Set cnObj = CreateObject("ADODB.Connection")
; Set rsObj = CreateObject("ADODB.Recordset")
;
; cnObj.Open "Driver={Microsoft Excel Driver(*.xls)};DBQ="
& strFrameWorkDB & ";ReadOnly=1"
;
; strSQL = "Select * from [DataSource$]"
;
; rsObj.Open strSQL, cnObj, adOpenStatic, adLockOptimistic

This will result in a hanging HTA application.

Thanks in advance,
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WinPE + HTA + SQL = Error 0
ADO adStateOpen = 0 2
error while runnning ado vbs in Windows PE 4
troubles not bringing in the first row of a ado query to another spreadsheet... 2
Reading Excel file using VB 3
Class does not support automation (err 430) - on copyfromrecordset 3
ADODB Connection Problem 3
Excel VBA & ADO - retreiving data from Approach dBase IV .dbf files 1

Back
Top