Re: VB.Net connection to Oracle 10G database

On Tue, 21 Mar 2006 15:22:51 +0800, Dave Baker <newsgroup_poster_at_jodael.com> wrote:

>"ORA-12514: TNS:listener does not currently know of service requested in
>connect descriptor"
>
>I believe my username & password are correct, but am completely unsure about
>what should go into the 'SERVICE_NAME=' field.

Further to this, I did the following:

SELECT sid, serial#, client_identifier, service_name, action, module FROM V$SESSION and get the following:

"SID","SERIAL#","CLIENT_IDENTIFIER","SERVICE_NAME","ACTION","MODULE"
"26","1","","SYS$BACKGROUND","",""
"28","54","SYSTEM:1589891410295048","SYS$USERS","PAGE 1204","APEX:APPLICATION
4500"
"29","204","","SYS$USERS","",""
"30","2","","SYS$BACKGROUND","",""
"33","1","","SYS$BACKGROUND","",""
"39","1","","SYS$BACKGROUND","",""
"40","1","","SYS$BACKGROUND","",""
"41","1","","SYS$BACKGROUND","",""
"42","1","","SYS$BACKGROUND","",""
"43","1","","SYS$BACKGROUND","",""
"44","1","","SYS$BACKGROUND","",""
"45","1","","SYS$BACKGROUND","",""
"46","1","","SYS$BACKGROUND","",""
"47","1","","SYS$BACKGROUND","",""
"48","1","","SYS$BACKGROUND","",""
"49","1","","SYS$BACKGROUND","",""
My SID of 28 has a Service Name of 'SYS$USERS', but using that doesn't make any difference in the connection string.

What worries me now is that I have 3 tables (vessel_data, vessel_group and vessel_properties) but it doesn't appear that my connection string is pointing to any of them anywhere, and I don't see any reference to them above)

Thanks,

Dave Received on Tue Mar 21 2006 - 01:58:12 CST