You must Sign In to post a response.
  • Category: .NET

    connection string for oracle in VB.NET

    In VB.NET application i need to accesss a database located in another machine's Oracle server.

    The details of Oracle server are:
    ------------------------------
    server'same:\\orcl
    username=developer
    pwd:dev
    dsn:emr(System DSN)

    I use Microsoft ODBC for Oracle driver.Can anyone help with the connection string.
  • #261379
    Dim OraStr As String = "Data Source=Oracle8i;Integrated Security=yes"

    OR

    dim OraStr As String = "Provider=""MSDAORA.1"";User ID=dev;Data Source=testdb;Password=dev"


    http://www.daniweb.com/forums/thread26939.html
    i hope this may help u



    Thanks & Regards
    G.Renganathan
    Nothing is mine ,Everything is yours!!!

  • #261469
    if u are using oracle data adapter use this string

    dim OraStr As String = "User ID=scott;Data Source=testdb; Password=tiger"

    other than oracle adapter (like Oledb or ODBC)

    dim OraStr As String = "Provider=MSDAORA.1;User ID=scott;Data Source=testdb;Password=tiger"

    Regards,
    Pavan Ravi Kumar.

    "Complex problems have simple, easy to understand wrong answers."

  • #261470
    Hi,

    Dim con As String="provider=msdaora.1;user id=scott;password=tiger";

    Thanks and Regards
    S.S.Bajoria


    Thanks & Regards


    Bunty


This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.