G
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.
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.