Re: connect string for oracle7

From: Michael Krolewski <vandra_at_u.washington.edu>
Date: Tue, 02 Jun 1998 22:23:42 -0700
Message-ID: <3574DDDE.C4F63266_at_u.washington.edu>


I could be completely wrong but as far as I know you need to talk to the MS Commerce Server group. Oracle has a variety of connection software for talking to other databases. They generally use native Oracle SQL to talk to the foreign database and use SQLNet as the connection software.
This type of software is pricy -- $10,000's. It is generally speaking one way. One can read or write
data of the foreign database from within Oracle, however the foreign database has no knowledge of
the Oracle database.

One could use ODBC with its inherent penalties of performance. If you are using ODBC, the
server connection is the TNSNAME alias that is part of the SQLNet client setup.

Mike Krolewski

Stephen Mai wrote:

> Hi,
>
> I need to know the format for the connect string from MS Commerce Server
> to an Oracle Database.
>
> I know that it must be different from the SQL Net format because that
> format does not include a password, which has to be a part of this
> remote connection.
>
> Thanks,
> --Steve
Received on Wed Jun 03 1998 - 07:23:42 CEST

Original text of this message