Access OBDC connect string without pre-configured DSN

[cully651]

Hi Guys, I'm a n00b to VBA and Tek-Tips. Gotta say up front, this place is great. I find all sorts of useful info here, so thanks.

Also, I apologize up front because I'm sure this topic has been covered but I can't find it. I'm probably not searching for the right words.

What I really need to do is connect Access 2007 to an Oracle database using an ODBC driver without pre-configuring the DSN. My current connect string is

CurrentDb.QueryDefs("qryOracleDual").Connect = "ODBC;DSN=MART;UID=MART_USER;PWD=MART_PWD;"

Please, if you can point me in the right direction of some resource to help me, I'd really appreciate it!

 

[PHV]

Have a look here:

http://www.connectionstrings.com/oracle

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

or

http://www.carlprothman.net/Default.aspx?tabid=81

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[cully651]

No matter what I try, I get

Error 3305: Invalid connection string in pass through query