Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Post Unanswered: Microsoft And Oracle Oledb Providers Not Working Together

    Hi !

    Is it possbile to enable both Microsoft OLE DB Provider for Oracle
    and Oracle Provider for OLE DB on a single machine.

    here with me , if i make Oracle Provide to run , Microsoft cannot connect and if i make Micorsoft provider to run , oracle provider stops connecting to database server....

    has anybody idea why is it so and let me know if there is a work around for this.

    Regards ...

    Amit Bhavsar
    =========

  2. #2
    Join Date
    Apr 2003
    Location
    Zagreb Croatia
    Posts
    2

    Re: Microsoft And Oracle Oledb Providers Not Working Together

    In VB 6.0 when I use this code, it works OK so try.I believe that help you
    Conn.Open "Provider=MSDORA.1;Data Source=YourServer;" & _
    "DNS=Pubs;User Id=sa;Password=;"
    That is for Oracle, if you want to do it with Microsoft driver, you have to change Provider and DNS.
    Also, you have to create DNS in File DNS for each driver.

  3. #3
    Join Date
    Apr 2003
    Posts
    2

    Re: Microsoft And Oracle Oledb Providers Not Working Together

    Originally posted by nightrider
    In VB 6.0 when I use this code, it works OK so try.I believe that help you
    Conn.Open "Provider=MSDORA.1;Data Source=YourServer;" & _
    "DNS=Pubs;User Id=sa;Password=;"
    That is for Oracle, if you want to do it with Microsoft driver, you have to change Provider and DNS.
    Also, you have to create DNS in File DNS for each driver.

    what u r talking @ is microsoft driver. MSDAORA is from microsoft. and what the problem with me is while developing connectionstring in visual basic IDE for adocn1 , i can connect to microsoft and not oracle one. in fact i cannot make it connect for both the providers on a single machine.

  4. #4
    Join Date
    Apr 2003
    Location
    Zagreb Croatia
    Posts
    2

    Re: Microsoft And Oracle Oledb Providers Not Working Together

    Originally posted by amitbhavsar
    what u r talking @ is microsoft driver. MSDAORA is from microsoft. and what the problem with me is while developing connectionstring in visual basic IDE for adocn1 , i can connect to microsoft and not oracle one. in fact i cannot make it connect for both the providers on a single machine.
    Like I wrote you, I used providers MSDORA and OraOLEDB.Oracle.1 on a single machine both at the same time.
    If you get error number 430 then you have to instll some patches which you can find on microsoft pages.

Posting Permissions

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