View Single Post
  #1 (permalink)  
Old August 9th, 2004, 12:30 PM
prasadp prasadp is offline
Registered User
 
Join Date: Aug 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default database problem

hi

I am trying to give a connection string to get the records from the oracle9i database. I have put my database in useraccount scott. When i try to retrieve record through this code it is troubling me. Can anybody help? Thanks in advance.

Public con As adodb.connection
Public Sub connection()
Set con = New adodb.connection
con.Open = "Provider=MSDAORA.1;User ID=scott; Persist Security Info=False"
End Sub