[DUG] Use of ODBC drivers

[Kyley Harris]

ODBC is just a generic way of communicating with a database using SQL.
If you can provide a ODBC driver for your dbisam then they will be
able to access your data, but I don't believe you can do Cross joins
over databases using it. (I could be wrong) Generally, if they are
referring to your data they will store referential keys from your DB
in their DB. and run 2 DB connections from their middleware etc.

As long as it is readonly, and there is a viable DBISAM SQL driver for
ODBC you should have no problems at all, as long as you provide them
the meta data.

R.
Kyley

On 6/16/05, Mark Howard <mhoward at pslog.co.nz> wrote:
> Hi All
> 
> At one client site I have my application (written in D7) is connected to a DBISAM database behind a DBISAM server.
> This site wants to develop an in-house (Net/MS-SQL) application which accesses other MS-SQL tables as well as my DBISAM tables (read-only).
> 
> Rather than convert my app to MS-SQL it seems that a low cost alternative would be for them to gain access to my data through an ODBC driver.
> 
> I have had no experience with ODBC and so I would be very interested in hearing the experiences of others who do have direct experience in reading data and presumably joining tables between MS-SQL databases and other databases accessed through ODBC (not necessarily DBISAM).
> 
> What IS possible?  What is not?
> Is it robust?
> Are there any gotchas?
> 
> Are there any good resources that I can read up on?
> 
> Thanks
> 
> Mark
> 
> 
> --
> Forest Production Systems Ltd
> Creators of PSLog - A harvesting information system
> www.pslog.co.nz
> 
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.7.4/16 - Release Date: 15/06/2005
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 


-- 
Kyley Harris
Harris Software
+64-9-8455274
+64-21-671-821