ODBC Connection String works ...sort of????

[dschomburg]

I'm using A97 on WNT 4.0 and trying to connect to an Oracle database using ODBC and the TransferDatabase Method. Here is my connection string;

DoCmd.TransferDatabase acLink, "ODBC", "ODBC;DSN=reporting;SERVER=rpt.world;UID=A0219833;PWD=mojo01;TABLE=GWYDB.V_VEHICLE_RETIREMENT_HISTORY", acTable, "GWYDB.V_VEHICLE_RETIREMENT_HISTORY", "GWYDB_V_VEHICLE_RETIREMENT_HISTORY", False


This works...IF I have previously already logged on using the DSN. BUT if I shut down Access and restart it then try to Link the table I get an ODBC error. The DSN connection box doesn't even pop up.
But like I said if I manualy do it first, then there's no problem.

Any help would help a heap as I'm pulling my hair out!!

Thanks,
Dave

 

[dschomburg]

Sorry to have to respond to my own message but I really have been struggling with this.

Anyone?