Can anyone solve this one?

Results 1 to 2 of 2

Thread: Can anyone solve this one?

  1. #1
    Join Date
    Dec 1969

    Default Can anyone solve this one?

    Here&#039;s the scenario: <BR><BR>I have an Access database on a local server, this has tables which are linked to an oracle database sitting somewhere else on the network. When I open these tables in the Access database I get asked for a username and password which I enter and then gain access to the tables. The problem is, when I open a connection to this Access database in ASP and then subsequently try to query the linked tables, I get an error message saying the link has failed. I think this is because it needs the username and password, how do I pass the usrename and password to the Oracle database?<BR><BR>(Confused yet?!)

  2. #2
    Join Date
    Dec 1969

    Default Why would you do this?

    Running your database calls to an Oracle database "through" Access is an enormous overhead.<BR><BR>Is there a reason you aren&#039;t connecting directly to the Oracle database?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts