Article View: borland.public.cppbuilder.database.ado
Article #22Running Vista -- getting cannot find installable isam
From: 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!!!!!!!!!!!!!
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-mailShow 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