tns listener

kalharas · Post by **kalharas** » Wed 22 Aug 2007 14:42

Good day,
i am using OraDirect.NET Mobile Standart Edition...trying the develop a softare for PDAs and working on emulators right now. My problem is cant open connection...i see the table results etc during the implementation on design screen if i use dataadapter but when i try to debug i get tns:listener not found error if i try it on my local db and network unreachable host error if i use another computer with the same db (both same network and outside of network) on connection.Open() function
is it something related with the DB or am i missing anything?

Alexey · Post by **Alexey** » Thu 23 Aug 2007 06:53

Specify your connection string, please.

kalharas · Post by **kalharas** » Thu 23 Aug 2007 07:17

the error code is ORA-12541
there goes :

User Id=ps;Password=psp;Server=127.0.0.1;Connect Mode=Default;Pooling=False;Sid=XE;

PS: I am having the same trouble with the samples you provide...also the DB is being used by another project that is implemented java/jsp so we can not find anything faulty yet

edit : i just changed the connection string for my localserver...

kalharas · Post by **kalharas** » Thu 23 Aug 2007 12:03

I think i forgot to mention that,
on design screen when i setup the connection properties on the window when i click on the test connection button i see Successfully Connected message so i really don't know what to do...please this is urgent

Alexey · Post by **Alexey** » Thu 23 Aug 2007 12:11

You should put the real IP address instead of 127.0.0.1.
Please try.

kalharas · Post by **kalharas** » Thu 23 Aug 2007 12:29

using a real IP changes the error to
"Network error:: A socket operation was attempted to an unreachable host"

Alexey · Post by **Alexey** » Thu 23 Aug 2007 12:55

What is the port number? If it has default value, then the problem should be in your emulator's network settings. Please check them carefully.
Is ActiveSync running? Can you go to the internet from the emulator?

kalharas · Post by **kalharas** » Thu 23 Aug 2007 14:18

port number is 1521...i can connect to internet using ActiveSynch at the moment yes

kalharas · Post by **kalharas** » Thu 23 Aug 2007 14:47

i wasnt actually able to use the ActiveSynch it seems :O now the connection works and its stable!
Thank you!

Alexey · Post by **Alexey** » Thu 23 Aug 2007 15:01

So what was the problem?

kalharas · Post by **kalharas** » Fri 24 Aug 2007 11:28

It was about ActiveSync...i was somehow gettng disconnected by it...it was a mistake by my side ^_^

Alexey · Post by **Alexey** » Mon 27 Aug 2007 06:27

OK, I see.