Re: Linking SQL Server tables to Oracle Tables DSN-Less

gonkowonko_at_gmail.com wrote:

> i have an oracle database and an SQL Database i query both and at the
> mo i have to query one then put records in an array then query the
> other than update the array.
>
> Is there a method in VB6 that i can simply link the two (dsn-less
> connection)??

BDE (Borland Database Engine) is similar to ODBC and it allows heterogenous database joins - e.g. you can select a table from one BDE data source and joined it (using SQL) with another BDE data source. Have done this a few times in Delphi (but never put that code into production). The vast majority of times this type of thing is not a bright idea. It can (and usually do) cause havoc with performance.

> If anyone as a solution you would save me hours !!

I would rather solve this at server side then in VB at the client side. Oracle provides a transparent interface into other databases, including SQL-Server. From the client side the SQL-Server table will look like a normal Oracle table.

--
Billy