cannot open Excel(*.xls) or Access(*.mdb) files in XPE, but OK in

[Guest]

Hello, everyone,

I have a problem in xpe need help. (maybe two).

I developed a win32 program with VC and MFC, in the application, I used
CDatabase of MFC to open a Excel file (myfile.xls ) to read my prepreserved
data, In the same application, I also used ADO (ActiveX Database Object) to
open a Microsoft Access file (myfile2.mdb).

In My windows xp pro, my application runs just fine. There is No Microsoft
Office installed, my application do open and read/write correct data from/to
the Excel and Access files。


Now when I move the application into XPE (xp embedded) platform, there are
troubles..
The application shown errors when I　try to open and read/write Excel.

I imported the following component into xpe already:

Microsoft Data Access Componet （MDAC）
Jet Database ODBC support

Still, when trying to open the excel file (myfile.xls)
It said:

Could not find installable ISAM
Invalid connection string attribute FIRSTROWHASNAMES
Invalid connection string attribute CREATE_DB.

I checked, in my source code, my DSN related Excel is:

m_sDsn.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s", m_sExcelDriver, m_sFile, m_sFile);




As for trying to open the Access file（myfile2.mdb）

My code:
_ConnectionPtr m_pConnection;
AfxOleInit();
try
{
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=d:\\dir\\myfile2.mdb","","",adModeUnknown);

}
catch(_com_error e)
{
CString str;
str.Format("Error Message is %s",e.ErrorMessage());
AfxMessageBox(str);
return FALSE;
}

I get error message:

Unknown Error 0x800A0E7A


But in XP pro, my whole application is just ok,,

Please tell me, what components I should import further.

I don’t believe I have to install Microsoft office or there is license
problem, because on the xp pro platform, I did not install Microsoft office,
it’s OK..

I don't know how to run FileMon in xpe as many poster mentioned,since my xpe
system has no startup, no start screen alltogether, besides, i think Excel
and Access files should be common files. the related component should be
quite easy to locate, but I just don't know how. please help me.

Thank you very much!

Winston.

 

[Guest]

Thanks for your attention, the problems solved

I just added the following components, because they look like they have
something to do with Database…ïŠ

Jet Database Dao,
Jet Database Data Extension
Jet Database Engine
Jet ODBC support
Jet OleDB Support

Thanks.

 

[Robin Hickmott]

Yes you need the JET support in order to link in with Access and Excel
files. This comes by default with XP