Page 1 of 1
Can I use OraDirect .Net to develop Pocket PC(with wireless) application?
Posted: Wed 17 Aug 2005 03:06
by qhonge
Can I use OraDirect .Net to develop Pocket PC(with wireless) application?
I want use OraDirect .Net to develop Pocket PC application with .Net Compact Framwork, But I don't know how to do it.
Posted: Wed 17 Aug 2005 06:55
by Paul
Please use OraDirect .NET 3 Mobile version with Visual Studio 2003. Please see sample projects.
thank you!
Posted: Wed 17 Aug 2005 11:10
by qhonge
But It throw
An unhandled exception of type 'CoreLab.OracleExcepion' occurred in CoreLab.Oracle.dll
Why?
Error
Posted: Wed 17 Aug 2005 11:14
by qhonge
An unhandled exception of type 'CoreLab.Oracle.OracleException' occurred in DataReader.exe
errors in sample
Posted: Wed 17 Aug 2005 11:54
by qhonge
I connect my server with
ConnectionString = "user id=dev;password=dev;host=192.168.0.246;sid=test;";
It throw OracleException,I think so
But In Pocket PC can't handle the OracleException
Posted: Wed 17 Aug 2005 13:34
by Paul
Please write try...catch block around your code. Please check that sid value is correct as described in OraDirect .NET documentation. This value is different from "Data Source" parameter in general.
Do you have this problem with sample projects?
Yes
Posted: Wed 17 Aug 2005 14:39
by qhonge
Yes,I have this problem with sample projects.
My IDE is .Net Studio 2003
Is it just support 2005 or other problem?
but, I can connect my oracle server with sql*plus
I test it
Posted: Thu 18 Aug 2005 02:02
by qhonge
I have test my server with JDBC! It work well!
Is something wrong with your .Net Drivers? I can't sure so!
Posted: Thu 18 Aug 2005 02:26
by qhonge
Even I test the PC sample project!
It throw the same Exceptions!
Posted: Thu 18 Aug 2005 06:21
by Paul
What is the version of Oracle server, OraDirect .NET Mobile? Which line in code generates OracleException?
Can you write the next code to see error message?
Code: Select all
try {
...
}
catch(Exception ex) {
label1.Text = ex.Message;
}
Please check that you take SID from SERVICE_NAME parameter in tnsnames.ora. For
example SID='orcl920' for the next settings
Code: Select all
ORA920 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl920)
(FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES=100)
(DELAY=1))
)
)
thank you
Posted: Thu 18 Aug 2005 06:53
by qhonge
I use Oracle 8i and OraDirect .Net Mobile 3.0
I have debuged the sample code. When It run connection.open(), It will throw exception
I catch the message of the exception,but it is null,so I can't sure what is wrong with it.
I have check the tnsname.ora, The sid is right! and I can use the sid connect my server with JDBC driver
Code: Select all
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.246)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)
This is the sample code for test
Code: Select all
try {
Cursor.Current = Cursors.WaitCursor;
connection.Open();
Cursor.Current = Cursors.Default;
DialogResult = DialogResult.OK;
}
catch (OracleException exception) {
Cursor.Current = Cursors.Default;
// MessageBox.Show(exception.Message);
retries--;
if (retries == 0)
DialogResult = DialogResult.Cancel;
switch (exception.Code)
{
case 1005:
edPassword.Focus();
break;
case 1017:
ActiveControl = edPassword;
break;
case 12203:
case 12154:
edServer.Focus();
break;
}
throw;
}
Posted: Thu 18 Aug 2005 11:12
by Paul
We cannot reproduce your problem with OraDirect .NET Mobile 3.01.2, Oracle server 8.1.7
Try the last OraDirect .NET version
Disppointment
Posted: Fri 19 Aug 2005 03:41
by qhonge
I just download it last day! I think it is last version! I just want to test it!!
I'm so disppointed to know oraDirect can't Direct!
Posted: Thu 01 Sep 2005 08:51
by Paul
We found the problem with OraDirect .NET when it works in Windows with multibyte national charset. You can work in this situation when you set Unicode=true in OracleConnection.ConnectionString. (We will correct bug with updating strings in Unicode=true mode in the next OraDirect .NET build)
We cannot reproduce your problem with connection to Oracle 8.1.7 windows 2000 database. Possibly some settings are different. Please send us result of executing "select * from nls_database_parameters"