DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ODBC

  1. #1
    Join Date
    Oct 2000
    Posts
    22

    Unhappy

    I have never used ODBC to connect to a database. Can any one show a good source or documentation from which I can learn that.

  2. #2
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Wink Hey Mr. "theDBA"

    Hey, you are "theDBA" - you should have all answers: I'm just messing with you.

    ODBC - I tried to find some source, but I was unsuccessful; but if you have any questions, please ask - I will try to help you.

    Here is the basics:
    (on NT)

    START > Settings > Control Panel > ODBC Data Source Adminstrator > (use the System DSN) tab > Add > (Select the correct driver) > (enter the ODBC name) > (enter the entry from the TNSNAMES.ora file here - Connect String)

    Now you can connect from (for ex.) MS Access, go to:

    File > Get External Data > Link Tables > then when the window opens us - select the "ODBC databases" as the file type > at the next window select the ODBC you setup from the Machine Data Source > you will be prompted for the userid/password.

    Hope this helps.

    [Edited by khussain on 11-03-2000 at 04:50 PM]

  3. #3
    Join Date
    Oct 2000
    Posts
    22
    Oh you are funny, but thanks for that. I appreciate it

  4. #4
    Join Date
    Oct 2000
    Posts
    22
    Are there any reasons why some people choose to connect through ODBC? I am asking because I don't know the reason why. All the client site that I have worked at don't connect through ODBC. Can you tell or explain to me the reason why some people choose ODBC? What's the significance

  5. #5
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Wink

    I guess it depends on the application connecting. I am not a developer, but I think it is easier, since the developers do not have to write any code to connect to oracle - the functionality is already provided by Microsoft/ Oracle and other vendors.

    If you have metalink, check out this writeup:
    [url]http://metalink.oracle.com/metalink/plsql/ml2_gui.startup[/url]


Posting Permissions

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


Click Here to Expand Forum to Full Width