Results 1 to 8 of 8

Thread: How to connect to Oracle 10g XE

  1. Jul 14th, 2008, 11:28 PM #1
    Winanjaya
    Winanjaya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    784

    Question How to connect to Oracle 10g XE

    Dear All,

    How to connect to Oracle 10g XE ? .. I didnot find correct connectionstring..

    please help

    TIA

    Winanjaya
    Reply With Quote Reply With Quote
  2. Jul 15th, 2008, 01:59 AM #2
    Fazi
    Fazi is offline
    PowerPoster Fazi's Avatar
    Join Date
    Aug 2005
    Location
    Underworld
    Posts
    2,525

    Re: How to connect to Oracle 10g XE

    hai winanjay,
    http://www.connectionstrings.com
    blog
    Reply With Quote Reply With Quote
  3. Jul 15th, 2008, 02:14 AM #3
    Winanjaya
    Winanjaya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    784

    Re: How to connect to Oracle 10g XE

    yes, I also have visited there and I followed the connectionstrings from that site.. but it doesnot work.. ;<(

    regards
    Reply With Quote Reply With Quote
  4. Jul 15th, 2008, 02:16 AM #4
    Fazi
    Fazi is offline
    PowerPoster Fazi's Avatar
    Join Date
    Aug 2005
    Location
    Underworld
    Posts
    2,525

    Re: How to connect to Oracle 10g XE

    oh, sorry
    blog
    Reply With Quote Reply With Quote
  6. Jul 15th, 2008, 09:26 AM #5
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: How to connect to Oracle 10g XE

    Moved to Database Development

    What is the code/connection string that you are using?

    When you say it didn't work, what does that mean? Did you get an error? If so, what was it?
    Reply With Quote Reply With Quote
  7. Jul 15th, 2008, 09:34 AM #6
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: How to connect to Oracle 10g XE

    Is the database on the same machine as the code? Is there a TNSNames entry for the database? Is there a listener running on the machine the database is on?

    What is doesn't work? Is there an error? If there is what is the error message?

    Can you connect to the database using SQL*Plus?
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  8. Jul 15th, 2008, 09:22 PM #7
    Winanjaya
    Winanjaya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2003
    Posts
    784

    Re: How to connect to Oracle 10g XE

    Just want to share..
    it solved already by using connectionstring below..

    mConnStr = "Provider=MSDAORA.1;User ID=myuser;Password=myuserpasswd;Data Source=10.0.0.10;Persist Security Info=False"

    any way.. thanks for any reply..

    Regards
    Winanjaya
    Reply With Quote Reply With Quote
  9. Jul 16th, 2008, 07:28 AM #8
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: How to connect to Oracle 10g XE

    I would shift from the MS Oracle driver to the Oracle supplied one. It has a few more fetaures for Oracle
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
« Previous Thread | Next 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


Click Here to Expand Forum to Full Width