----- Original Message ----- From: "Samuel Neff" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 01, 2003 12:36 PM Subject: RE: connecting to linked ODBC data...
> You can have Access store the username/password in the links. There is > a checkbox when setting up the links that says store username/password. > > If you're not joining on Access tables, you're better off querying the > oracle tables directly, instead of going through an Access link. Hi Sam: unfortunately, there are a number of situations where I do need to join :\ i saw the option to store the username in the ODBC link...i did not see the option to store username and password. We are using Access '97 (if that matters....and yes, i know, i know) :) thx, charlie > > > > -----Original Message----- > > From: Charlie Griefer [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 01, 2003 2:24 PM > > To: CF-Talk > > Subject: connecting to linked ODBC data... > > > > > > hey all... > > > > i'm currently connecting to an Access .mdb file...which has > > linked tables in it. The linked tables are linked to an > > Oracle database, which requires a username and password. > > > > the .mdb file itself is not password protected. > > > > So...if I do not pass username/password attributes in my > > <cfquery> tag, I can get to the Access tables fine...but not > > the linked tables. If I *do* pass username/password > > attributes in my <cfquery> tag, well...same thing :) > > > > Apparently, Access doesn't take the username/password and > > pass it to the Oracle tables when prompted for authentication. > > > > Any easy solution that I'm overlooking? > > > > thx, > > Charlie > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
