Hi,
I'm trying to connect Discoverer 10g to MS SQL Server 2000.
I think I know what to in the username and password fields but I can't
figure out what to put in the "Connect" field.
I tried a DSN name, connection string, server name... nothing works!
Please help me out..
TIA,
jake

On 26 mrt, 11:59, yako... (AT) gmail (DOT) com wrote:
It should be the TNS alias; it's the part defined in tnsnames.ora,
before the first equal ("=") sign.

I seriously doubt whether you can connect to SQL Server.

On Mar 26, 12:59 pm, "frank.van.bor... (AT) gmail (DOT) com"
<frank.van.bor... (AT) gmail (DOT) com> wrote:
Thanks.
I guess now I have to figure out how to write the part after the equal
sign, eh?
jake

<yakov.b (AT) gmail (DOT) com> wrote

You can connect to MSSQL only indirectly via heterogeneous services, which
means you have to create database link in Oracle database using either
Oracle Transparent Gateway or Generic Database Connectivity (ODBC, OLE DB).

Before you query data in any data source, you must define it in Discoverer's
End User Layer, which is metadata repository. The EUL must be stored in an
Oracle database, unless you use some older version of Discoverer. It means
you need at least one Oracle instance. You can find more details in
Discoverer help, chapter "Discoverer support for non-Oracle databases and
Oracle Rdb".

If you want direct access to non-Oracle data sources, you can try Siebel or
some other BI tool.

Regards

On Mar 27, 3:15 pm, "Marino Ljubic" <mlju... (AT) globalnet (DOT) hr> wrote:
Thanks.