🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Database problem

#237
From: Tomislav Hundrić
Date: Sat, 28 Jul 2007 07:20
30 lines
2257 bytes
Hi,
I have the following situation. I have to develop application that will 
be used to display images and data from db. My first thought was I'll 
use ms access db because it is very simple to deploy, only one file and 
the best part is I don't have to install bde engine since it uses 
microsoft jet driver which is native in windows, but since ms access 
doesn't have blob field I have to use OLE object and I found out that it 
converts jpeg images to bmp and increases size of db dramatically. I 
know I can use save the path to file in db field and then retrieve the 
image stored locally, but this is not a good solution to me since I'll 
be storing hundreds of images so I want to avoid hundreds of files 
stored locally. My next thought was to use paradox db since it is able 
to store images in blob field, but I want to avoid installation of bde 
if possible. I've came across this article which says:

Jet 4.0 supports connections to Paradox 3, 4 and 5 only; we do not 
support later versions. The ADO connection string syntax would be:

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data
Source=c:\somepath;" & _ "Extended Properties=Paradox 5.x;"

I've tried the connection string above and I get error:
Could not find installable ISAM

Does anyone know is it possible to connect to paradox db using jet 
drivers (ADO Connection), or can anyone suggest me which is the best way 
to solve my problem.

Thanks in advance,
Tomislav
Technical Details
Message-ID: <46aaee61@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,723ca8957fa3ed73,start
X-Google-Attributes: gid10698b,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sat, 28 Jul 2007 09:20:32 +0200
From: Tomislav Hundrić <rifnet@gmail.com>
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Database problem
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 78.0.137.149
Message-ID: <46aaee61@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1185607265 78.0.137.149 (28 Jul 2007 00:21:05 -0700)
Lines: 30
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail