-
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]
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|