exception while connected to oracle 8i

Christian · Post by **Christian** » Mon 20 Nov 2006 08:41

Hi , all
There's an problem that i counld not solved

I had successfully connected to a datasource(oracle 9i) by oradirect.net compact framework(version 3.5) on symbol MC3000(wince.net 4.2) mobile device, but when the datasource be changed to ver. oracle8i , the same code can not work correctly , and an error happend .
I found that every property of the exception be throwed this time is nothing except error code "1017".
i tried it on winform plantform , with same connection configration , it could work correctly.

it seems i can not sloved it now , if anyone kindly knows that what happened even how to deal with it , pls. let me know , thanks.

with my best wishes

!

Christian
Nov 20 , 2006

source code following:

Code: Select all

Dim ocnTemp As New OracleConnection

        Try

            With ocnTemp
                .Server = "200.19.19.5"
                .Sid = "PVS"
                .Port = 1521
                .UserId = "HZPVS"
                .Password = "HZPVS"
            End With

            ocnTemp.Open()

        Catch ex As OracleException
            MsgBox(ex.Message)
        Catch ex As Exception
            MsgBox(ex.Message)

        End Try

it will throw an exception when app. running "ocnTemp.Open".
except "ex.code" = 1017 , every property of "ex" is nothing

Alexey · Post by **Alexey** » Mon 20 Nov 2006 09:53

Do you use OraDirect .NET for СF 2.0 or for СF 1.1?

Christian · Post by **Christian** » Mon 20 Nov 2006 15:19

Thanks for your attention ~
I used OraDircet.NET for CF 1.1
---------------------------------------
Developping Condition:
window xp sp2
MS VS.Net 2003
.Net 1.1

Testing condition:
Window CE 4.2
.Net CF 1.1

Alexey · Post by **Alexey** » Wed 22 Nov 2006 07:16

We cannot reproduce any problem with connecting to Oracle8i.
Please check your settings.
Try to connect using another provider (ODP, OracleClient, etc.).