Post reply

linked servers being being used by an access app

  • July 5, 2005 at 1:19 pm

    #102623

     HI. I have a linked server in sql that connects to our oracle database. There is a developer that has an application written in access and he wants to set up the odbc connection on his pc to the sql server to retrieve some data thru the linked server.  When he is trying to set up the odbc connection, it is asking him for a default database. Since the data is not in sql but in the oracle database, what does he put here? To me, there is no default database?

    Can someone help me here?

     Juanita 

     

  • July 5, 2005 at 1:40 pm

    #570994

    I think what is happening here is that the linked server does not have his account mapped on the security tab of it (which it is needed!)

    THE ODBC DSN using a SQL authentication , right ?

     

     


    * Noel

  • July 5, 2005 at 1:43 pm

    #570997

    HI. Well actually we have 1 account set up to access the linked server so i

    had the option set so that any user not defined in the security tab you are referring to would use that option. I'm not sure what authentication he is choosing. I bet it is Windows authentication. So it should be sql authentication, correct?

    Thanks so much,

    Juanita

     

  • July 5, 2005 at 2:27 pm

    #571026

    Correct!

    If if using Windows authentication the linked server would have to be set up after you have Account delegation in place which implies a bunch of other things and on top of that, I am not sure your Oracle DB will work on that one

    So, make sure he is using SQL authentication

     

     


    * Noel

  • July 5, 2005 at 2:29 pm

    #571029

    Thanks so much ! I will have him give it a try !

    Juanita 

  • July 6, 2005 at 9:43 am

    #571326

    Hi,

    you also could create views on the sql server that use OPENQUERY statements. That way thee end user needs only rights for the view, and you could use an appropriate account to get into the oracle server...

    karl

    Best regards
    karl

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply