Visual Basic 6 and Personal Oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Visual Basic 6 and Personal Oracle 8i

  1. #1
    Join Date
    Oct 2001
    Posts
    1

    Cool

    I'm making one aplication with Visual Basic 6 and Personal Oracle 8i under Windows 98. I want to connect me from Visual Basic to Personal Oracle via ADO but, when I run the application, she send me the folowing error:
    "Run time error -2147467259 (80004005)
    [Microsoft ODBC Driver Manager]
    Driver's SQL set connect attr failed"
    I used the folowing structure: "UID=****;PWD=****;DRIVER{Microsoft ODBC for ORACLE};SERVER=****"
    Well, I don't have some idea. If you can help me, I thank you very much.

    [Edited by jcurie on 10-10-2001 at 02:38 PM]

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    You haven't given the full VB code, but I use the following code in VB to connect successfully to personal oracle via ADO:
    Code:
    Dim con As ADODB.Connection
    Dim rs1 As ADODB.Recordset
    
    Private Sub Form_Load()
    Set con = New ADODB.Connection
    Set rs1 = New ADODB.Recordset
    con.Open "Provider=MSDAORA.1;Password=xyz;UserID=raminder;Persist Security Info=True"
    rs1.CursorLocation = adUseClient
    rs1.Open "Tablename", con, adOpenStatic, adLockOptimistic, -1
    End Sub
    Hope this is a pointer. Before writing this code, make sure Microsoft ActiveX Data Objects library is selected from References.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

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