connecting to oracle database in vb.net

hi
i am new to oracle i need a connection string to connect to oracle database in vb.net 2005. I am using oracle 9i database and odp.net facility.
i have written connection string like this but it is giving error


dim SMS_DATA As String = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myip)(PORT=myport))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));User Id=SMS_TEST;Password=SMS_TEST;"
Dim con As OracleConnection = New OracleConnection()
con.ConnectionString = "Data Source=SMS_DATA;"
con.Open()
MsgBox("connected successfully")

error is
ORA-12154: Message 12154 not found; No message file for product=RDBMS, facility=ORA
can anybody help me in this
thanks in advance

Comments

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion