Subject Re: [ib-support] ODBC Question
Author Yves Glodt
> No, it's sufficient to know that you are using that old version of
> the BDE - which might be a source of your problem, since IB 6 didn't
> exist at the time it was produced.
>
> >More Info?
>
> Yes - it's a Delphi question rather than a driver one...it occurred
> to me because you mentioned you were using the same client program to
> connect to either Paradox or IB 6. How do you make the connectivity
> for the Paradox data access objects? From the info you provided
> earlier, I wonder if you created a separate ODBC datasource for each
> table connection...

I use a tdatabase and tquery.
All the database accesses are done by real sql (No ttable etc!)
The (bde)-alias I want to use is specified in an ini-file. I've got one
alias called iman_px that points to the paradox db, and one called
iman_ib that points to the firebird odbc driver (which points to the ib
database file).
This odbc works, since I can connect with winsql e.g. and query the db.
(Though I don't remember if I can do updates/insert by this way, will
check and tell you. (selects work well))

> In Interbase, you need to create one single ODBC datasource for the
> entire database. IB tables don't map to physical files as Paradox
> tables, Excel spreadsheets, etc. do.

I'm aware of that. Because of that I use queries and not tables.

> Just a thought.
>
> Helen
>
> All for Open and Open for All
> InterBase Developer Initiative ยท http://www.interbase2000.org
> _______________________________________________________
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Secure your servers with 128-bit SSL
> encryption! Grab your copy of VeriSign's FREE Guide: "Securing Your
> Web Site for Business." Get it Now!
> http://us.click.yahoo.com/n7RbFC/zhwCAA/yigFAA/dpFolB/TM
> ---------------------------------------------------------------------
>~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/

--
Linux 2.4.9 #1 Thu Aug 16 22:56:53 CEST 2001 i686
12:26pm up 1:07, 1 user, load average: 0.19, 0.05, 0.05