have a look at sqlnet.ora and see if it is tring to use nts authentication.
if so disable it.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Jerry D" <jdubuke_at_notme.gpdservices.com> wrote in message
news:3dd1732c$0$11057$724ebb72_at_reader2.ash.ops.us.uu.net...
> Hi all,
> We had a meltdown of an Oracle database running on NT Server 4.0. We
> rebuilt the server from scratch, installed Oracle from scratch, recreated
> our database and imported a .dmp file from the previous night to get back
> online.
> Amazingly, the only problem we are now facing is the fact that connecting
> via ODBC takes a *lot* longer than it used to. For example, a Microsoft
> Excel sheet with an ODBC query in it will stay onscreen with "connecting
to
> datasource" fro anywhere between 10 and 45 seconds. It will eventually
> connect, but take such a long time, which never happened before the
rebuild.
> I figure I missed sumthin pretty important, and I have not got a cluse as
to
> where to look, since I was sortat thrown into the deep end here.
> Could someone point me in the right direction to start looking? I would
> appreciate it!
>
> Jerry D
>
>
>
Received on Tue Nov 12 2002 - 16:06:27 CST
