Re: how to connect oracle reports to MS-sql server DB

"Juchny" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> > Hi,
> >   I need to connect oracle reports 6i to MS-sql server-2000.oracle
> > reports is  in o/s windows2000 professional. I installed odbc driver,
> > created user DSN, tested. I'm able to connect from oracle sql plus to
> > sql server, but when im trying to connect from oracle
> > reports(username/[EMAIL PROTECTED]:dsn_name:databse), im geting error
> > "service handle not initialised'. How to solve this?
> 
> Have U added your service into tnsnames.ora in oracle home dictionary?
> 
> Juchny

Hi,
   only if I'm connecting to oracle DB i need to add service in
tnasnames.ora file, isn't? Is it necessary to sdd service if I'm
connecting to sql server? If so whats the syntax?whether to specify
the dsn name ?(as we r connecting thro' odbc)
shanmugam