Wednesday, March 7, 2012

DTS not connecting to oracle

It tells me client for Oracle not installed. I found an installation of the
client but it's 200MB!!! Is this really it?!!
tia
ZarkoYou need to install Oracle ODBC connectivity on the box(es) that connect to
Oracle. I think it is called SQL *NET ?
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"®arko Jovanoviæ" <zarko.jovanovic_protiv_spama_@.fina.hr> wrote in message
news:1071583104.91341@.internet.fina.hr...
> It tells me client for Oracle not installed. I found an installation of
the
> client but it's 200MB!!! Is this really it?!!
> tia
> Zarko
>|||reinstall oracle client and make sure you can TNSPING the oracle server you want to connect to...
tnsping servername
>--Original Message--
>You need to install Oracle ODBC connectivity on the box
(es) that connect to
>Oracle. I think it is called SQL *NET ?
>-- >--
>Allan Mitchell (Microsoft SQL Server MVP)
>MCSE,MCDBA
>www.SQLDTS.com
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>"=AEarko Jovanovi=E6" <zarko.jovanovic_protiv_spama_@.fina.hr> wrote in message
>news:1071583104.91341@.internet.fina.hr...
>> It tells me client for Oracle not installed. I found an installation of
>the
>> client but it's 200MB!!! Is this really it?!!
>> tia
>> Zarko
>>
>
>.
>

No comments:

Post a Comment