Devart Forums

Dears,
I try to use Oracle database by Mobile,Oracle10G is no problem,but when try to connect Oracle7.3.4 version,it is not successful,Somebody can help me.

Try to connect in Direct mode.

I download the latest Mobile version(4.35),try to use Direct=true,but it is not support this mode. How to do,downgrade to the old version?Thanks

We tested the last build of OraDirect .NET Mobile(4.35.28.1) with Oracle server version 7.3.4 and haven’t encounter the problem with connection.
Could you specify the error message?

The big problem is only showing me one attention message window,no detail message and error code.
Ok,I try to get the New mobile one for CF1.1,and test again,later reply the result.Now say"Thanks" .

Now,I got the images ,please check the follow,thanks
this one is to oracle 7.3

this one is to Oracle10G

We couldn't get this error.
Try running your project in runtime and see the text of OracleException.
If there is no text send us please the callstack, where this exception occurred.
Could you reproduce this error on the installed Oracle client (for example using SQL Plus application)?

I try to test all the parameters,I can get this ex.GetHashCode=322977,ex.message="",So how to do my next step.
Thanks

code=1017
errorcode=-2147483648
CoreLab.Oracle.OracleException
CoreLab.Oracle.g.e()
CoreLab.Oracle.a1.c()
CoreLab.Oracle.u.c()
CoreLab.Oracle.av..ctor()
CoreLab.Oracle.ac.e()
CoreLab.Common.DbConnectionFactory.k() CoreLab.Common.DbConnectionPoolGroup.i() CoreLab.Common.DbConnectionPool.a() CoreLab.Common.DbConnectionPool.GetObject() CoreLab.Common.DbConnectionFactory.j() CoreLab.Common.DbConnectionClosed.Open() CoreLab.Common.DbConnectionBase.Open() CoreLab.Oracle.OracleConnection.Open() DeviceApplication1.FormConnection.Button1_Click() System.Windows.Forms.Control.OnClick() System.Windows.Forms.Button.OnClick() System.Windows.Forms.ButtonBase.WnProc() System.Windows.Forms.Control._InternalWnProc() Microsoft.AGL.Forms.EVL.EnterMainLoop() System.Windows.Forms.Application.Run() DeviceApplication1.FormConnection.Main()

I try to search the code=1017 in this forums,I get two people's questions like mine
Christian:exception while connected to oracle8i
qhonge:Can I use OraDirect.Net to develop pocket Pc(with wireless) application?
How to solved it?

This is the reason of connection failure:
ORA-01017 invalid username/password; logon denied
Cause: An invalid username or password was entered in an attempt to log on
to Oracle. The username and password must be the same as was specified in a
GRANT CONNECT statement. If the username and password are entered together,
the format is: username/password.

What exactly causes this failure is still questionable.
What Windows regional settings do you have on the server and the client?
What charsets do you have in your database? (select * from nls_database_parameters)

Try connecting to the server v. 7.* via client.

by sql/plus,I used this username/password@sid format,work good,by oracle client and toad tool,It's work well,and I get the server parameter by"select * from nls_.....",the total list like this:
PARAMETER VALUE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_CALENDAR GREGORIAN
NLS_RDBMS_VERSION 7.3.4.3.0

I try others wrong username/password as you say.Yes when I execute it,will popup the same error null charater message,but as you say I should type the username/password together,how to define the connection string?please/thanks,now my connection string is "user id=inventory;password=inventory;sid=rt;server=127.20.11.1",But I use this one to Oracle10G connection and work good.
Please/Thanks

The problem may be here: We are investigating this problem.
I'll let you know our progress.

Ok,Thanks your attention this,I waiting,maybe can mail me

jian zhou@auchan com cn
thanks