Results 1 to 4 of 4

Thread: Connecting to Oracle 8 w/ VB3 Prof.

  1. #1

    Thread Starter
    Hyperactive Member JazzBass's Avatar
    Join Date
    Jun 1999
    Posts
    393

    Post

    Good Morning all,
    I've been trying to figure out how to connect to and Oracle 8 database using VB 3. Is this even possible? I've read some help tips and stuff, but I can't figure out how to do it.
    Can someone please help me.

    Here is some info about the database I would like to connect to.

    Server=Myserver
    UID=APPS
    Password=MYAPPS

    Thanks,
    JazzBass

    ------------------
    21 yr old beginner VB Programmer
    VB 6 Professional @ Home
    VB 3 Professional @ the Office

  2. #2
    Guest

    Post

    Try this On ADO Connection:
    Set you ODBC first..{Microsoft ODBC Oracle Driver}.
    ------------------------------
    Set cn = New ADODB.Connection
    cn.Open "dsn=COMS;UID=ComsAdmin;PWD=coms"
    Set rs = New ADODB.Recordset
    rs.CursorType = adOpenDynamic
    rs.LockType = adLockOptimistic

    ------------------------------------
    I'm new in vb
    -Khamal-

  3. #3
    Addicted Member
    Join Date
    Oct 1999
    Posts
    232

    Post

    I think you need VB4/32 at the least.

    ------------------
    smalig
    [email protected]
    http://vbcode.webhostme.com/


  4. #4

    Thread Starter
    Hyperactive Member JazzBass's Avatar
    Join Date
    Jun 1999
    Posts
    393

    Post

    Thanks Guys,
    I think Smalig is right. I just may need a later version. Thanks for the help.
    JazzBass

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