[b]ODBC performance issue[/b]

[yearntolearn]

We have an Access application the is using ODBC to update an Oracle 9i database across a T1 WAN. The job runs for 5 hours when ran across the WAN but it only runs 30 minutes when it is run locally across the LAN. We think ODBC is the problem but we do not have a solution. I'm hoping someone can help.

 

[yearntolearn]

Did I not get a reply because no one has an answer or because my posting was unclear.

 

[SkipVought]

Without regard to your ODBC driver, have you compared the transfer rate for the LAN vs WAN?

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}