Oracle Lite 9i connection (newbie)

  • Thread starter Thread starter Dean Slindee
  • Start date Start date
D

Dean Slindee

I have installed Oracle Lite 9i at:
C:\Oracle\OraLite9i\Mobile\sdk\OLD40\polite.odb (virgin install). Have also
installed ODP.NET in Visual Studio.NET (Framework 1.1). Now I try to open
the database with the following code:
Imports Oracle.DataAccess.Client

Public Function OpenOracleLite() As DataSet

Dim cnOracleLite As String

Dim cn As New OracleConnection(cnOracleLite)

Try

'Oracle Lite 9i (ODP.NET)

cnOracleLite = "Data Source=POLITE;" & _

"User Id=SYSTEM;" & _

"Password=;"

cn.Open()

Catch exc As Exception

Debug.WriteLine(Err.Number, Err.Description)

Finally

cn.Close()

cn = Nothing

End Try

End Function

Getting the following error:

Error: 5 ORA-12154: TNS:could not resolve service name

This is my first Oracle install. Please note the connection string
parameters. Are they correct for after a virgin install of Oracle Lite 9i?

What else is needed (probably in the way of database administration) to get
the connection to see the oracle lite db in the path above, or another
oracle lite database on another drive?

Also: does 9i have any GUI user interface, or is it like MSDE?

Thanks,

Dean Slindee
 
Hi Dean,

Thanks for using the Microsoft Newsgroups. While I can not personally help
you with this issue, I am working on finding someone who can.

Please be aware that as of right now, I feel your best bet would be to go
to the Oracle message boards or contact Oracle support. In the meantime, I
will work on finding someone who may know the answer to your question today.

Brett Keown
Microsoft Support
(e-mail address removed)

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Dean said:
I have installed Oracle Lite 9i at:
C:\Oracle\OraLite9i\Mobile\sdk\OLD40\polite.odb (virgin install).
Have also installed ODP.NET in Visual Studio.NET (Framework 1.1).
Now I try to open the database with the following code:
Imports Oracle.DataAccess.Client

Public Function OpenOracleLite() As DataSet

Dim cnOracleLite As String

Dim cn As New OracleConnection(cnOracleLite)

Try

'Oracle Lite 9i (ODP.NET)

cnOracleLite = "Data Source=POLITE;" & _

"User Id=SYSTEM;" & _

"Password=;"

cn.Open()

Catch exc As Exception

Debug.WriteLine(Err.Number, Err.Description)

Finally

cn.Close()

cn = Nothing

End Try

End Function

Getting the following error:

Error: 5 ORA-12154: TNS:could not resolve service name

This is my first Oracle install. Please note the connection string
parameters. Are they correct for after a virgin install of Oracle
Lite 9i?

What else is needed (probably in the way of database administration)
to get the connection to see the oracle lite db in the path above, or
another oracle lite database on another drive?

Also: does 9i have any GUI user interface, or is it like MSDE?

Thanks,

Dean Slindee
Click to expand...

Maybe ODP.NET doesn't work with the personal version of Oracle?

If it does, then maybe you need to check your TNSNAMES.ORA file to make
sure you have defined "POLITE" and pointed it to your server.
 
Back
Top