Thread View: borland.public.cppbuilder.database.ado
1 messages
1 total messages
Started by Syscwl
Sun, 20 Apr 2008 16:07
Running Vista -- getting cannot find installable isam
Author: Syscwl
Date: Sun, 20 Apr 2008 16:07
Date: Sun, 20 Apr 2008 16:07
31 lines
2425 bytes
2425 bytes
CG2007,C++ Flavor, all patches [also have MS VS 2005] installed on
machine...this is the first time I've attempted to run this app on this
machine which is a Vista Ult 32 bit.
The Connected=true goes fine, but when it gets to the SQL->Active -- I get
the installable ISAM message.
Are there some dll's I'm missing...I searched Tamaracka, but most errors
there are syntactical...this works fine on my XP machine. So I'm thinking
its a dll issue.
>>>>>>>>>snippet
str.sprintf("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=i:\\mba3d\\data\\fund performance %s.xls;Mode=Read;"
"Persist Security
Info=False;Extended Properties='Excel 8.0;HDR=Yes;IMEX=2'",
endDate->Date.FormatString("mmmyy"));
ADOConnection1->ConnectionString = str;
ADOConnection1->Connected = true;//this goes OK
//The dollar sign is important. Don't delete it.
// str.sprintf("select ticker,category,index,[3 Month],Ytd ,[1 Year],[3
Year], [5 Year],[3 Month idx], [Ytd idx] ,[1 Year idx],[3 Year idx], [5 Year
idx] from [Fund Performance %s$] order by category",
// endDate->Date.FormatString("mmmyy"));
str.sprintf("select ticker,category,index from [Fund Performance %s$] order
by category",
endDate->Date.FormatString("mmmyy"));
ADOQuery1->SQL->Text = str;
ADOQuery1->Active = true;///I get "installable Isam" here!!!!!!!!!!!!!
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads