Re: VB.Net connection to Oracle 10G database

Dave,

add a where clause to your query:
SELECT sid, serial#, client_identifier, service_name, action, module FROM
V$SESSION where type='USER'

That will only show user sessions, not the background (Oracle system) sessions, too.

As for your service_name, try:
select * from global_name;

Try whatever that delivers for a service_name in your tnsnames.ora

If you are sure your network is set up correctly, post tnsnames.ora, sqlnet.ora and listener.ora Received on Tue Mar 21 2006 - 02:30:11 CST