DSN less Connections

[kfschaefer]

I am new to DSN Less connections - and not exactly sure how they work. I currently have the Oracle table linked and it was linked via the Get External Data - Linked Table - ODBC Connection to the DSN I created. My query uses this table.

I also created vba to use the DSN Less Connection and then created a simple openquery statement in my code - since I am using the simple openquery and this query is using the DSN connected table is this overriding my DSN Less connection - IF so how do I modify my code to run the complex append query that should append records from Access to Oracle with the DSN Less connection - so when other users access this mdb they do not have to worrry about the DSN connection or the tnsnames.ora file is correct.

K

 

[FoFa]

Even using a DSN less connection, you still need the Oracle client and a TNSnames file. Your DSN less connection still has to point to an entry in the TNSnames file. A DSN less connection is nothing more than DSN connection defined internally to the program. It only buys you not having to setup a DSN on each computer.