Transferdatabase acImport with Oracle

[Jose]

I need to import several table from Oracle 9i db.

I get popup:

ODBC -- Connection to "oracle database" fialed

Here is my code:
=====================

Sub Linktbls()
On Error GoTo Err_Linktbls

DoCmd.TransferDatabase
acImport, "ODBC", "ODBC;DSN=Oracle
database;UID=extractor;PWD=xxxx;DATABASE=LoanNext",
acTable, "pub.borradr", "Borradr", True, False

Exit_Linktbls:
Exit Sub

Err_Linktbls:
MsgBox Err.Description
Resume Exit_Linktbls

End Sub