🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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
#22
Author: Syscwl
Date: Sun, 20 Apr 2008 16:07
31 lines
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