Oracle connection in asp.net??

[anand]

Hi friends i am getting a stupid error in asp.net ..pls give me a idea what mistakei did..



Sub BindReport1()
Dim con1 As New OleDb.OleDbConnection()
con1.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=orcl;user id=scott;pass word=tiger;"
Dim cmd As New OleDb.OleDbCommand()
cmd.Connection = con1
cmd.CommandText = "select * from dept"
cmd.CommandType = CommandType.Text
Dim DA As New OleDb.OleDbDataAdapter()
DA.SelectCommand = cmd
Dim myDS As New DataSet()
DA.Fill(myDS, "dept")

Response.Write(myDS.Tables(0).TableName)
End Sub


i am getting the error in the bellow line

con1.ConnectionString = "Provider=OraOLEDB.Oracle;user id=scott;pass word=tiger;"



pls tell me my mistake and give me the correct syntax for connection string..........

Thanks
Satya
gummadi009@yahoo.com

 

[anand]

Its ok ..i got it now...