DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2001


    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
    Waterloo, On
    You haven't given the full VB code, but I use the following code in VB to connect successfully to personal oracle via ADO:
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.