SEO

#1 (**permalink**) 02-24-2008, 01:50 PM

Hi,

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)??

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

Cheers

Gaz

#2 (**permalink**) 02-24-2008, 01:50 PM

gonkowonko@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

#3 (**permalink**) 02-24-2008, 01:51 PM

Hey Gaz,

You can use Oracle Heterogeneous Services to allow ODBC based Database
Links to be created in the Oracle Server, after which you can query the
SQL Server tables via oracle and perform all standard ANSI sql
statements.

Cheers,

Shaun.

#4 (**permalink**) 02-24-2008, 01:51 PM

think i may of sorted the issue

basically you are able to link an oracle database to SQL server via the
SQL Server Enterprise manager all you need to do is to instal the
oracle client on the server with the SQL Server Database. THis is to
set up the drivers and the TNS stuff

Cheers for your suggestions

Gaz

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Linking SQL Server tables to Oracle Tables DSN-Less