I was finally able to connect to the local orca db after I uninstalled the current oracle tools and reinstalled the full 10g oracle installation.
I have the latest BETA2 software for the Oracle Development tools for .Net installed within Visual Studio.
After connecting to the orcl db from within VS.net, I was able to view the tables inside the Oracle Explorer window. I simply tried to retrieve data from the HR table by right-clicking on it and selecting retrieve data. It started to go out and do the process,
then it crashed VS.Net. Ever since then, whenever I now connect to the db and try to view it in the Oracle Explorer, the window WILL NOT open up to show me the tables......
Does anybody know "what gives" with the ORACLE Development tools for .Net and whey I can't view the tables now in the Oracle Explorer (because it won't open up)???
Another question is how do I view the tables within the db from the Administration Assistant for Windows? I'm right-clicking on the orcl db from this tool, but there is no option to display the tables, stored procedures, etc...
While trying to establish a connection via an oracle dataadapter from within visual studio, I am getting the infamous : "ORA-12541: TNS:No Listener" msg.
I may also get the "ORA-12514:TNS:Listener does not currently know of service requested in connect descriptor"
I have allowed access to ORACLE.EXE with my mcAfee personal firewall.
I am able to TNSping my server.
The "OracleOraDb10g_home1TNSListener" windows service is Started. I've even tried restarting it.
The last time I was having a hard time with Oracle 10g I metalinked with Oracle and most of the problem was cleared by changing the Environment Variables in the operating system. Right click on my computer and click on Advanced and open the Environment Variables
and see what is in there it may solve your problems because if you have not changed that, changing the tnsnames.ora will not resolve your problem. Hope this helps.
It should be a simple "connect" (enter) command, then you will be asked for the username and password. Anyway, also check the files sqlnet.ora and tnsnames.ora. Do a google search on these files.
I'm trying to configure an oracle dataadapter within VS.NET 2003, and am having problems doing so.
I wanted to find out if the OracleDataAdapter is capable of generating Typed Datasets....
I keep getting the error:
"Microsoft DataLink Error
Test connection failed because of an error in initializing provider. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"
I am placing the server name of: DBTYZQ41 and a Username of: "SYSTEM" and my password as something else. When I try testing the connection, I get the above error.
Here is some more info:
While trying to establish a connection via an oracle dataadapter from within visual studio, I am getting the infamous : "ORA-12541: TNS:No Listener" msg.
I may also get the "ORA-12514:TNS:Listener does not currently know of service requested in connect descriptor"
I have allowed access to ORACLE.EXE with my mcAfee personal firewall.
I am able to TNSping my server.
I can connect to the DBTYZQ41 server via SQLPlus by typing in "SYSTEM" for the UserID and my password as something else.
The "OracleOraDb10g_home1TNSListener" windows service is Started. I've even tried restarting it.
When I also hover my mouse over the "Oracle Explorer" tab, just the Oralce Output window comes up and no databases are shown.
I'm really tearing my hair out on this one. Can someone please help me with this error.
I'm typing in "DBTYZQ41" as my server name within visual studio and entering my "SYSTEM" userid and my password which I know is correct.
I can't believe it's this hard to work with ORACLE and resolve a simple connection issue. I've unistalled and reinstalled the 10g database software 3 times, and I refuse to do it any further.
How can I properly configure this connection issue? No wonder why ORACLE needs a DBA to administer it. It's simply too cumbersome for a developer to configure and work with.
The above errors (ORA-12514 & ORA-12541) appear all over the internet, but there doesn't seem to be a definite resolution to fix any of them. Anything that you try, doesn't fix the problem.
I configured the "Listener.ora" file adding the "(SID_DESC =
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
"
I then went into a command prompt and tried the "tnsping orcl" command. I got the following result:
TNS-03505: Failed to resolve name
This is the contents of my Listener.ora file:
# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
This is the contents of my SQLNET.ora file:
# sqlnet.ora Network Configuration File: C:\Oracle\product\10.1.0\Client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
wsyeager
Participant
1733 Points
456 Posts
ORACLE Developer tools for .Net
May 04, 2005 05:00 PM|LINK
I was finally able to connect to the local orca db after I uninstalled the current oracle tools and reinstalled the full 10g oracle installation.
I have the latest BETA2 software for the Oracle Development tools for .Net installed within Visual Studio.
After connecting to the orcl db from within VS.net, I was able to view the tables inside the Oracle Explorer window. I simply tried to retrieve data from the HR table by right-clicking on it and selecting retrieve data. It started to go out and do the process, then it crashed VS.Net. Ever since then, whenever I now connect to the db and try to view it in the Oracle Explorer, the window WILL NOT open up to show me the tables......
Does anybody know "what gives" with the ORACLE Development tools for .Net and whey I can't view the tables now in the Oracle Explorer (because it won't open up)???
Another question is how do I view the tables within the db from the Administration Assistant for Windows? I'm right-clicking on the orcl db from this tool, but there is no option to display the tables, stored procedures, etc...
Bill Yeager MCP.Net, BCIP
wsyeager
Participant
1733 Points
456 Posts
Re: ORACLE Developer tools for .Net
May 04, 2005 06:57 PM|LINK
While trying to establish a connection via an oracle dataadapter from within visual studio, I am getting the infamous : "ORA-12541: TNS:No Listener" msg.
I may also get the "ORA-12514:TNS:Listener does not currently know of service requested in connect descriptor"
I have allowed access to ORACLE.EXE with my mcAfee personal firewall.
I am able to TNSping my server.
The "OracleOraDb10g_home1TNSListener" windows service is Started. I've even tried restarting it.
Here is the contents of my tnsnames.ora file:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBTYZQ41)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Here is the contents of my Listener.ora file:
# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBTYZQ41)(PORT = 1521))
)
)
)
I'm really tearing my hair out on this one. Can someone please help me with this error.
I'm typing in "DBTYZQ41" as my server name within visual studio and entering my "SYSTEM" userid and my password which I know is correct.
I can't believe it's this hard to work with ORACLE and resolve a simple connection issue.
Bill Yeager MCP.Net, BCIP
SreedharK
All-Star
18571 Points
3119 Posts
MVP
Re: ORACLE Developer tools for .Net
May 04, 2005 07:10 PM|LINK
Are you able to connect using SQL PLUS on the machine where your Applicaiton is running?
http://www.w3coder.org
weblog http://weblogs.asp.net/skoganti
Caddre
All-Star
26581 Points
5308 Posts
Re: ORACLE Developer tools for .Net
May 04, 2005 07:17 PM|LINK
Gift Peddie
wsyeager
Participant
1733 Points
456 Posts
Re: ORACLE Developer tools for .Net
May 05, 2005 12:20 AM|LINK
Bill Yeager MCP.Net, BCIP
wsyeager
Participant
1733 Points
456 Posts
Re: ORACLE Developer tools for .Net
May 05, 2005 12:23 AM|LINK
Bill Yeager MCP.Net, BCIP
SonuKapoor
Star
13757 Points
2655 Posts
MVP
Re: ORACLE Developer tools for .Net
May 05, 2005 12:26 AM|LINK
ASP.NET News and Articles For Lazy Developers |Ajax Data Controls Forum
wsyeager
Participant
1733 Points
456 Posts
Re: ORACLE Developer tools for .Net
May 05, 2005 03:19 PM|LINK
Yes, I am able to connect with SQLPlus:
SQL*Plus: Release 10.1.0.2.0 - Production on Thu May 5 11:16:52 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
Bill Yeager MCP.Net, BCIP
wsyeager
Participant
1733 Points
456 Posts
Re: ORACLE Developer tools for .Net
May 05, 2005 05:19 PM|LINK
I'm trying to configure an oracle dataadapter within VS.NET 2003, and am having problems doing so.
I wanted to find out if the OracleDataAdapter is capable of generating Typed Datasets....
I keep getting the error:
"Microsoft DataLink Error
Test connection failed because of an error in initializing provider. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"
I am placing the server name of: DBTYZQ41 and a Username of: "SYSTEM" and my password as something else. When I try testing the connection, I get the above error.
Here is some more info:
While trying to establish a connection via an oracle dataadapter from within visual studio, I am getting the infamous : "ORA-12541: TNS:No Listener" msg.
I may also get the "ORA-12514:TNS:Listener does not currently know of service requested in connect descriptor"
I have allowed access to ORACLE.EXE with my mcAfee personal firewall.
I am able to TNSping my server.
I can connect to the DBTYZQ41 server via SQLPlus by typing in "SYSTEM" for the UserID and my password as something else.
The "OracleOraDb10g_home1TNSListener" windows service is Started. I've even tried restarting it.
Here is the contents of my tnsnames.ora file:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBTYZQ41)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Here is the contents of my Listener.ora file:
# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBTYZQ41)(PORT = 1521))
)
)
)
When I also hover my mouse over the "Oracle Explorer" tab, just the Oralce Output window comes up and no databases are shown.
I'm really tearing my hair out on this one. Can someone please help me with this error.
I'm typing in "DBTYZQ41" as my server name within visual studio and entering my "SYSTEM" userid and my password which I know is correct.
I can't believe it's this hard to work with ORACLE and resolve a simple connection issue. I've unistalled and reinstalled the 10g database software 3 times, and I refuse to do it any further.
How can I properly configure this connection issue? No wonder why ORACLE needs a DBA to administer it. It's simply too cumbersome for a developer to configure and work with.
The above errors (ORA-12514 & ORA-12541) appear all over the internet, but there doesn't seem to be a definite resolution to fix any of them. Anything that you try, doesn't fix the problem.
Does anyone know how this can be resolved???
Bill Yeager MCP.Net, BCIP
wsyeager
Participant
1733 Points
456 Posts
Re: ORACLE Developer tools for .Net
May 06, 2005 05:31 PM|LINK
I configured the "Listener.ora" file adding the "(SID_DESC =
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
"
I then went into a command prompt and tried the "tnsping orcl" command. I got the following result:
TNS-03505: Failed to resolve name
This is the contents of my Listener.ora file:
# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBTYZQ41)(PORT = 1521))
)
)
)
This is the contents of my SQLNET.ora file:
# sqlnet.ora Network Configuration File: C:\Oracle\product\10.1.0\Client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Bill Yeager MCP.Net, BCIP