tns listener

tns listener

Postby 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?
kalharas
 
Posts: 11
Joined: Wed 22 Aug 2007 14:20

Postby Alexey » Thu 23 Aug 2007 06:53

Specify your connection string, please.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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...
Last edited by kalharas on Thu 23 Aug 2007 12:06, edited 2 times in total.
kalharas
 
Posts: 11
Joined: Wed 22 Aug 2007 14:20

Postby 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 :(
kalharas
 
Posts: 11
Joined: Wed 22 Aug 2007 14:20

Postby Alexey » Thu 23 Aug 2007 12:11

You should put the real IP address instead of 127.0.0.1.
Please try.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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"
kalharas
 
Posts: 11
Joined: Wed 22 Aug 2007 14:20

Postby 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?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby kalharas » Thu 23 Aug 2007 14:18

port number is 1521...i can connect to internet using ActiveSynch at the moment yes
kalharas
 
Posts: 11
Joined: Wed 22 Aug 2007 14:20

Postby 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! :D
kalharas
 
Posts: 11
Joined: Wed 22 Aug 2007 14:20

Postby Alexey » Thu 23 Aug 2007 15:01

So what was the problem?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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 ^_^
kalharas
 
Posts: 11
Joined: Wed 22 Aug 2007 14:20

Postby Alexey » Mon 27 Aug 2007 06:27

OK, I see.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle