Connecting VB5 to ORACLE Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Connecting VB5 to ORACLE

  1. #1
    Join Date
    Oct 2000


    I'm trying to connect VB5 to Oracle8i locally. I don't want to use DSN (in ODBC) because I will distribute the app to the professor's PC and don't want to set it up.
    I've figured out how to create a tablespace in Oracle that will save the tables to a file called, for example, I'm trying to communicate with using ADO.

    This is what I've come up with so far:

    "Provider=MSDASQL; driver={Oracle8i ????}; Server = ???; Database = ????; UID=System;PWD= Manager"

    Where do I get the driver named Oracle8i ? What do I put in Server= ? If I'm not using a DSN connection, then what do I put in Database= ?

    Thanks for your help!!

  2. #2
    Join Date
    Oct 2000

    connection string

    Here is a DSN-less connection string.
    Below: put your userid, password and oracle server name.
    ex, UID= anagarur
    SERVER =
    Leave the driver part as it is.

    Cn = "UID=youruserid;PWD=yourpassword;driver=" _
    & "{Microsoft ODBC for Oracle};SERVER=youroracleserver;"

    Set Cn = New ADODB.Connection
    With Cn
    .ConnectionString = conn
    .CursorLocation = adUseClient
    End With

    Hope this helps.

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