Article View: borland.public.cppbuilder.database.ado
Article #237Database problem
From: Tomislav Hundrić
Date: Sat, 28 Jul 2007 07:20
Date: Sat, 28 Jul 2007 07:20
30 lines
2257 bytes
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-mailShow 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