ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

connecting to oracle database in vb.net

612243Dec 6 2007 — edited Dec 7 2007

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

<code>
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")
</code>
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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2008

Added on Dec 6 2007

#odp-net

4 comments

3,794 views