Results 1 to 4 of 4

Thread: Direct connect Oracle without ODBC

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2000
    Posts
    1

    Question


    Hi:

    Is it possible to connect Oracle without ODBC or Sql Net using ADO?
    I need to develop a vb application witch run on desktop, and no need to configure DSN or sql net.
    My oracle 8i is install in a linux server, and client side running win98.

    Thanks fro any help!
    Lam


  2. #2
    Addicted Member ShIzO's Avatar
    Join Date
    Apr 1999
    Location
    Bartlett, IL
    Posts
    189
    oracle has it's own odbc tool you can use for remote connections.

    btw: i think you can get microsoft ODBC to talk to oracle. you better check that.
    www.HardFind.com -buy/sell/trade your used hardware.

  3. #3
    Lively Member
    Join Date
    Oct 2000
    Location
    Leicestershire; ENGLAND
    Posts
    71
    If you do not wish to be configuring SQL Net for every database on every client, the accepted way is to configure Net/8 to use a central names server. You can then configure the names and locations of your databases in a central location and they will automatically propogate out to the clients.

    You could use server host names in older versions of Oracle, however I have had a lot of problems making this work under 8i, hence the above solution. The older host name system also experienced problems when there was more than one instance of the Orale database server running on a single host.

  4. #4
    Guest

    Answer

    yes it is possible to connect oracle without any odbc using ADO !!, but you allways need the oracle Client (Net8).

    when you install the Oracle Client the setup install an Oracle-Provider too (the name of the componet in the setup.menue= Oracle Objects for OLE 8.x.x.x.x)

    Sample for the connection if you have the Provider

    Code:
    Public Function GetConnOracle() As ADODB.Connection
    On Error GoTo Err_GetConn
    
        Dim cn As ADODB.Connection, strConnect As String, strUserId As String
        Dim strDatabase As String, strServer As String
        
        strConnect = "Provider=MSDAORA.1;Password=YourPassword;" & _
                     "User ID=YourUsername;Data Source=Database Alias (Declare in TNSNames.Ora)" & _
                     ";Persist Security Info=True"
                     
        Set cn = New ADODB.Connection
        cn.CursorLocation = adUseClient
        cn.Open strConnect
        
        Set GetConnOracle = cn
        Set cn = Nothing
    
        Exit Function
        
    Err_GetConn:
        Set cn = Nothing
        Set GetConnOracle = Nothing
        Select Case Err
            Case Else:  Err.Raise Err, "GNSDataImport.MGlobal.GetConnOracle", Err.Description
        End Select
    
    End Function

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