Page 1 of 1
OraDirect .net mobile problem
Posted: Mon 09 Jul 2007 11:05
by halmo
CoreLab.Oracle.OracleConnection' does not contain a definition for 'Direct'
Why?
Help me!
Halmo
Posted: Mon 09 Jul 2007 11:59
by Alexey
Mobile applications cannot connect to Oracle in non-direct mode. So there is no need in having 'Direct' attribute in the connection. Just erase it out of your connection string.
Posted: Mon 09 Jul 2007 12:35
by halmo
The ConnectionString is "Data Source=192.168.1.211;User Id=kmok;Password=ct;Port=1521;Pooling=false;Unicode=true;SID=ecostat10g".
The error message: "NET: Invalid SID".
Do you have any idea what is the reason of this exception?
Thanks
Halmo
Posted: Tue 10 Jul 2007 07:17
by Alexey
Do you have any idea what is the reason of this exception?
Yes. Your SID is invalid. Please check it carefully. Try to connect to your Oracle server from desktop application or using another client.
Posted: Tue 10 Jul 2007 07:36
by halmo
My tnsnames.ora :
ECO10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.211)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ecostat10g)
)
)
The PL/SQL Developer and another desktop application works fine.
Posted: Tue 10 Jul 2007 08:25
by Alexey
I've sent you our Ping demo project (zipped and renamed to *.txt file). Please try to connect to your server using this demo. If you don't succeed, this would mean that the problem somewhere in your connection settings and not in OraDirect .NET itself.
If you don't receive it, inform me and provide me with another e-mail address that would not reject attachments.
Posted: Tue 10 Jul 2007 09:11
by halmo
Alexey wrote:If you don't receive it, inform me and provide me with another e-mail address that would not reject attachments.
I don't receive it, pls. try this:
[email protected]
Posted: Tue 10 Jul 2007 11:16
by Alexey
Re-sent.
Please wait a bit, we have minor network problems.
Posted: Wed 11 Jul 2007 06:05
by halmo
Alexey wrote:Re-sent.
Please wait a bit, we have minor network problems.
I don't receive it.
Posted: Wed 11 Jul 2007 06:42
by Stada
Try to set a ";" to the end of your connection string!
Posted: Wed 11 Jul 2007 07:22
by halmo
I tried, doesnt resolve
Posted: Wed 11 Jul 2007 09:58
by Alexey
halmo wrote:Alexey wrote:Re-sent.
Please wait a bit, we have minor network problems.
I don't receive it.
Please check your mail.
Posted: Wed 11 Jul 2007 10:48
by halmo
You were right!
The service_names is ecostat10g, but the instance_name is ecostat1.
New connectionstring: "Data Source=192.168.1.211;User Id=kmok;Password=ct;Port=1521;SID=ecostat1".
OracleConnections works fine.
Thanks
Posted: Wed 11 Jul 2007 14:04
by Alexey
Not at all.