Transfer Database link to Oracle

[logeng]

I am trying to establish a table link to a Oracle database via ODBC. I am trying to use the Transfer Database method.

DoCmd.TransferDatabase acLink, "ODBC", "odbc;uid=user;pwd=password;server=servername", acTable, "library.table", "corder"

When I run this it brings up the dialogue box and forces me to select the DSN. I select my DSN it adds the table nicely.

However, I want this to be seamless to my user so I don't want the dialogue. I add the DSN=DSNAME and it will refuse my connection?

I have tried a DSN Less connection and I get the ISAM error and that is its own can of worms. I think I am close I just need some help.

Thanks.

 

[lameid]

I'm not sure if there is an ADO way to do this but you could use DAO. Just add a tabledef and set its connectproprty and use the refreshlink method.