ODBC failed Win2000 Acc97 Transferdatabase

[maryjo2001]

We just upgraded to a Win2000 under NT machine using access97. When we used to use a regular NT machine with access97 i used a module with the transferdatabase method to import data from an oracle table. This worked just fine till we got the upgrade to Win2000. Now it tell me that "ODBC - call failed to "SourceDSN." I checked the connections and they are just fine. I made sure there were primary keys defined. I can see the data no problem but when I try to run the link automatically with the transferdatabase method I get the error. Is there something I am missing? I just don't understand how it can work when you manually enter the username and password to connect to the DSN but when you put in this code it won't work?

DoCmd.TransferDatabase acImport, "ODBC Database", _
"ODBC;DSN=B-Ora73;UID=xx;PWD=xx;LANGUAGE=us_english;" _
& "DATABASE=B-Ora73", acTable, "tbl", "tbl1", _
0, -1

HELP!

 

[vbajock]

You've checked to make sure this DSN, B-Ora73, is set up on the new machine in ODBC Admin?

 

[maryjo2001]

yes it is setup in admin. i also checked in the tsnames.ora file and it appears to be fine as well. in the mean time i have reverted back to my old machine till we can figure out this issue. thanks for the reply i do appreciate it.

 

[vbajock]

Did you re-run the Oracle client install?

 

[maryjo2001]

we did reinstall oracle on the machine but not sure what "client install" means? maybe we missed something.

 

[vbajock]

It's been a while since I did an oracle job, but if I remember right there are some gotchas when setting up the client for ODBC. You might want to look at this web page, for some reason its in my notes. It's a couple of years old.

http://www.wisc.edu/drmt/configureODBC.html