Results 1 to 9 of 9

Thread: Help needed for creating Dynamic Oracle Query using Excel VBA and Forms

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-14-2013, 07:02 PM #3
    vijaysram
    vijaysram is offline
    VBAX Regular
    Joined
    Jun 2013
    Posts
    6
    Location
    Thank you Kenneth for your quick response.

    I used Record macro to get the VBA code for connecting the Oracle Database and Got the VBA Code,

    But when i am running the recorded macro, it is giving error.

    From your link, i think the below connection string will suit,

    Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword

    but my recorded macro is showing different,

    Source = _ oLEDB;Provider=msdaora.1;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword

    Can you please help connecting to the Database thru VBA first, so i can make progress on this work?
    Last edited by vijaysram; 08-14-2013 at 07:03 PM. Reason: Spelling Mistake
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules