Oracle Lite 9i connection (newbie)

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

brettke
Thu Jan 22 12:43:51 CST 2004

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
brettke@online.microsoft.com

This posting is provided "AS IS" with no warranties, and confers no rights.

Eric
Fri Feb 06 11:30:55 CST 2004

Dean Slindee wrote:

> 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

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.