Results 1 to 2 of 2

Thread: how to use orcale in vb dotnet

  1. #1

    Thread Starter
    Addicted Member Hammad's Avatar
    Join Date
    Mar 2003
    Location
    Pakistan
    Posts
    145

    how to use orcale in vb dotnet

    hello i want to use orcale in a project tell me how to use orcale in vb dot net
    thanks wit regards
    Hammad Umar

  2. #2
    Frenzied Member EyeTalion's Avatar
    Join Date
    Jul 2000
    Location
    New York
    Posts
    1,075
    VB Code:
    1. Try
    2.             strconn = "Provider=OraOLEDB.Oracle;Persist Security Info=False;User ID=APPLOGON;Password=APPPASSWORD; Data Sour" & _
    3.                             "ce=" & DropDowndb.SelectedItem.Text & ";OLEDB.NET=True;" & ";Extended Properties="""""
    4.             conn = New OleDb.OleDbConnection(strconn)
    5.             conn.Open()
    6.  
    7.         Catch ex As Exception
    8.             lblLoginError.Text = "Database " & DropDowndb.SelectedItem.Text & " is not working - Contact IT " & Err.Description
    9.             conn.Close()
    10.             Exit Sub
    11.         End Try
    12.         conn.Close()
    It's tough being an unhandled exception...

    ___________
    VB.NET 2008
    VB.NET 2010
    ORACLE 11g
    CRYSTAL 11

Posting Permissions

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



Click Here to Expand Forum to Full Width