Shaz Mar 13, 2009   6:14 AM GMT

Thanks Carlosdl for giving me the answer ,i will work out with this

255 pointsBadges:

Shaz Mar 13, 2009   7:19 AM GMT

Imports Oracle.DataAccess.Client Dim oradb As String = "Data Source=localhost;User Id=shazia;Password=shazia;" Dim oradb As String = "Data Source=(DESCRIPTION=" _ + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))" _ + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));" _ + "User Id=shazia;Password=shazia;" Dim conn As New OracleConnection(oradb) Dim conn As New OracleConnection() ' Visual Basic conn.ConnectionString = oradb conn.Open() MsgBox("connected successfully") iam getting errors such as Error 1 Statement is not valid in a namespace. C:Documents and SettingsShazia (Delonti)My DocumentsVisual Studio 2005ProjectsschoolschoolAdd Admission.vb 4 1 school plz give me a solution for this .iam new vb.net Thanks once again

255 pointsBadges:

carlosdl Mar 13, 2009   2:26 PM GMT

In .NET, everything have to be inside a class or module (excluding the imports). Also, there are some unnecessary lines in your code, for example the lines where you set the connection string. If you want to avoid the use of the TNSNAMES.ORA file then use your second option: Dim oradb As String = “Data Source=(DESCRIPTION=" _ + “(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))” _ + “(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));” _ + “User Id=shazia;Password=shazia;” Otherwise, use this (but replace 'localhost' with the database alias defined in your tnsnames.ora file): Dim oradb As String = “Data Source=your_database_alias;User Id=shazia;Password=shazia;” Your code should look similar to this: Imports Oracle.DataAccess.Client Public Class MainClass Shared Sub Main() Dim oradb As String = “Data Source=(DESCRIPTION=" _ + “(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))” _ + “(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));” _ + “User Id=shazia;Password=shazia;” Dim conn As New OracleConnection(oradb) conn.Open() End Sub End Class

84,580 pointsBadges:

Shaz Mar 18, 2009   5:44 AM GMT

Hi Carlosdl, Thank u for helping me out .I have implemented the code which u have given .Now it is giving as error connection not open ora 6413.Plz give solution for that Thanks & Regards, shazia.

255 pointsBadges:

carlosdl Mar 18, 2009   3:29 PM GMT

I posted an answer here: Solution for ORA-6413 error showing connection not open See if it helps.

84,580 pointsBadges: