How can I connect to Oracle7.3.4 using OraDirect Mobile
How can I connect to Oracle7.3.4 using OraDirect Mobile
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.
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.
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
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()
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()
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
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.
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
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
Please/Thanks
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
The problem may be here:
We are investigating this problem.
I'll let you know our progress.
Code: Select all
NLS_CHARACTERSET ZHS16GBK
I'll let you know our progress.