🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #22

Running Vista -- getting cannot find installable isam

#22
From: 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!!!!!!!!!!!!!
Technical Details
Message-ID: <480b6981$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,ce35bad5644b282f,start
X-Google-Attributes: gid10698b,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Syscwl" <charlesleggette@earthlink.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Running Vista -- getting cannot find installable isam
Date: Sun, 20 Apr 2008 11:07:03 -0500
Lines: 32
MIME-Version: 1.0
Content-Type: text/plain;
 format=flowed;
 charset="iso-8859-1";
 reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18000
NNTP-Posting-Host: 66.60.79.20
Message-ID: <480b6981$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1208707457 66.60.79.20 (20 Apr 2008 09:04:17 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail