Results 1 to 4 of 4

Thread: Vb.Net & Oracle

  1. #1
    Join Date
    Oct 2003
    Location
    Mexico
    Posts
    9

    Question Unanswered: Vb.Net & Oracle

    I need to make a connection from Vb.NET to an Oracle 8i or Oracle 9i Database, and I don't know how to do it. I tried using the Data Connection Wizard from the Server Administrator, but it did't show me the tables I had created in that Database.

    That is not my prefered way to connect to a database but I don't know how exactly to use the connection string for Oracle. Please help me.

    Thank You for your attention.

  2. #2
    Join Date
    Oct 2003
    Location
    Mexico
    Posts
    9
    Well, thank you very much, but I discovered that there are specific data access controls for Oracle in VB .Net. The connection string is pretty simple if you use those. It only needs the Service name, Username and an optional password wich for security it may not be added in the code.

    With these controls I can have access to the database with no problem. The only glitch, and confusion was that the server explorer from Vb.net could not read any info from the DB, not even the tables...

    Well as any other thing.. nothing is perfect..
    I'm sorry for bothering you, but I hope this may help someoane.

    Thanks again!

  3. #3
    Join Date
    Oct 2003
    Posts
    9

    Post

    If your .NET application (client) and oracle db (server) are on two different machines; in order for your client machine to recognize the oracle server you must install Oracle9i Database Release 2 Client for Microsoft Windows 98/2000/NT/XP on your client machine.

    Make sure listener is installed and running on your server.

  4. #4
    Join Date
    Feb 2004
    Location
    v v nagar
    Posts
    1

    Talking Re: Vb.Net & Oracle

    Originally posted by Ice_Crash
    I need to make a connection from Vb.NET to an Oracle 8i or Oracle 9i Database, and I don't know how to do it. I tried using the Data Connection Wizard from the Server Administrator, but it did't show me the tables I had created in that Database.

    That is not my prefered way to connect to a database but I don't know how exactly to use the connection string for Oracle. Please help me.

    Thank You for your attention.

Posting Permissions

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