Results 1 to 9 of 9
  1. #1
    Join Date
    Jul 2003
    Posts
    59
    Provided Answers: 1

    Question Unanswered: Connection string in VB.net help

    Hey all i am having problems with deploying my app over the windows server. When i click "install" on the publish.htm page, it does install just fine but once it starts the program and trys to access the oracle database, it comes back with my messagebox saying "cant connect to database". Although i can connect to it just fine on my deveoplment machine.

    This is the connection code:
    Code:
    myConnection = New OleDbConnection("Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS_LIST=" & _
                       "(ADDRESS=(PROTOCOL=TCP)(HOST=" & dbHost & ")(PORT=" & dbPort & ")))" & _
                       "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" & dbServiceName & ")));" & _
                       "User Id=" & dbUserId & ";Password=" & dbPassword & ";OLEDB.NET=true")
        Try
            myConnection.Open()
            Return True
        Catch ee As Exception
            myConnection.Close()
            Return False
        End Try
    It returns TRUE on my pc but FALSE on any other machine that installs the app via that web page.

    Did i forget to add a .dll or something for the Oracle db to connect? Is it something that any machine that wants to run my app needs to install the Oracle client software? I hope thats not the case since i figured using OraOLEDB that it would provide the needed .dll's to connect to it.

    And also, when i use this code:
    Code:
    Dim myConnection As String = "Data Source=(DESCRIPTION=(ADDRESS_LIST=" & _
             "(ADDRESS=(PROTOCOL=TCP)(HOST=" & dbHost & ")(PORT=" & dbPort & ")))" & _
             "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" & dbServiceName & ")));" & _
             "User Id=" & dbUserId & ";Password=" & dbPassword & ""
    Dim conn As New OracleConnection(myConnection)
    It will run on my dev machine but then exit the program back to VS.net. Not sure why the first connection string above works just fine but this one, using OracleConnection, does not???

    But any help would be great on this matter.

    David

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I don't know a whole great deal about oracle, but I do know that the solution I'm working in now requires that I have an oracle client installed. Have you verified you have everything you need to connect on the client machines?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jul 2003
    Posts
    59
    Provided Answers: 1
    Well that is what i am trying not have the user do-download software and set it up in order to use the program. I was hoping that a .dll would be only needed in my case to connect to the Oracle DB.

    David

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I don't think it works that way. I'm fairly certain you need a full on client install.
    Last edited by Teddy; 02-01-11 at 13:26.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Jul 2003
    Posts
    59
    Provided Answers: 1
    Quote Originally Posted by anacedent View Post
    Would i just need for them to download this? *Instant Client Package - ODBC: Additional libraries for enabling ODBC applications?

    David

  7. #7
    Join Date
    Jul 2003
    Posts
    59
    Provided Answers: 1
    Anyone?

    David

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    problem & solution have nothing to do with Oracle RDBMS.

    You might get more/better assistance from VB forum.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Whatever it is that lets your machine connect will also need to be bundled with your deployment package. Have a look at redistributable packages on the oracle site. My environment came prepped so I'm not sure what's available for redist...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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