Hi
I am sorry if my initial post was unclear.
I have a lot of data held in a number of SOLID instances (on Windows 2000
servers), and I have been asked to copy some of this data into Oracle (on
Solaris server). The only to access SOLID remotely is by ODBC, hence on
my Solaris server I have installed DBD::ODBC, UnixODBC and Solid SDK.
The UnixODBC isql programme connects to teh remote SOLID databases ok and
performs queries ok.
A Peer DBD::ODBC takes a long time to connect, but executes the query ok.
I hope this is clearer,
Simon
> Oracles Login Process is relatively slow, there is nothing you can do.
> But 20 seconds are too slow, it seems you have problems with the Oracle
> client setup. Check DNS and TNSNAMES.ORA. Check if
> $ORACLE_HOME/NETWORK/ADMIN/TNSNAMES.ORA (or
> $ORACLE_HOME/NET80/ADMIN/TNSNAMES.ORA) contains the line
> "SQLNET.AUTHENTICATION_SERVICES= (NTS)". If it does, comment it out
> (change the line to "# SQLNET.AUTHENTICATION_SERVICES= (NTS)"). This may
> accelerate your login, unless your Oracle setup uses NTS, in that case,
> you cannot login any more.
>
> You should also think about using DBD::Oracle instead of DBD::ODBC,
> which removes the overhead introduced by the ODBC layer.
>
> Alexander
>
> On 04.05.2006 11:45, [EMAIL PROTECTED] wrote:
>
>>Hi
>>
>>I have been asked to add DBD::ODBC to an Solaris server so that I can
>> copy
>>data from a number of Windows Solid databases to Oracle.
>>
>>Everything works, but the
>>
>>my $Dbh = DBI->connect("DBI:ODBC:<db>","<user>","<pass>");
>>
>>is very slow, typically 20s, whilst the rest of the script with
>>(prepare,execute,fetch loop) is much faster.
>>
>>I have checked the unixODBC isql command, and the connection is much
>>faster(<<1s), and the query takes approximately the same time as using
>>DBD::ODBC.
>>
>>Any ideas on the best way to investigate the cause of the slow
>> connection?
>>
>>All the best
>>
>>Simon
>>
>>
>>
>
>
> --
> Alexander Foken
> mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/
>
>