Re: MDAC 2.8 support in WinPE 2004 (sp2)
From: Michael Niehaus [MS] (mniehaus_at_online.microsoft.com)
Date: 01/18/05
- Next message: nospam: "Re: XP Workgroup to 2003 Domain"
- Previous message: Michael Niehaus [MS]: "Re: XP Workgroup to 2003 Domain"
- In reply to: René: "Re: MDAC 2.8 support in WinPE 2004 (sp2)"
- Next in thread: Johan Arwidmark: "Re: MDAC 2.8 support in WinPE 2004 (sp2)"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 Jan 2005 09:55:55 -0600
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
mniehaus@microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.
"René" <rene.van.de.waardt@rabobank.com> wrote in message
news:F2853B0B-8823-486F-A5A3-D2033A3FDBA5@microsoft.com...
> 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" wrote:
>
>> 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
>>
>>
>>
>>
>> On Mon, 17 Jan 2005 06:23:05 -0800, "René"
>> <rene.van.de.waardt@rabobank.com> wrote:
>>
>> >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,
>>
>>
- Next message: nospam: "Re: XP Workgroup to 2003 Domain"
- Previous message: Michael Niehaus [MS]: "Re: XP Workgroup to 2003 Domain"
- In reply to: René: "Re: MDAC 2.8 support in WinPE 2004 (sp2)"
- Next in thread: Johan Arwidmark: "Re: MDAC 2.8 support in WinPE 2004 (sp2)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
