Re: How to connect to Oracle 8i using VS.NET 2002

From: Carlos J. Quintero [MVP] (carlosq_at_NOSPAMsogecable.com)
Date: 05/06/04 

Date: Thu, 6 May 2004 13:06:50 +0200

There must be something wrong in your Oracle installation because:

1) ORA-12514 error is "TNS Listener could not resolve SERVICE_NAME given in
conect descriptor"

2) Your client installation could not give that description, only the error
number and the message "Message 12514 not found"

So, check your client installation. Try to connect with native SQL*Plus
before trying with OLEDB providers. 

-- 
Carlos J. Quintero (Visual Developer - .NET MVP)
FAQs, Knowledge Base, Files, Docs, Articles, Utilities, etc. for .NET
addins:
http://groups.yahoo.com/group/vsnetaddin/ (free join)
"Adeeb Ashraf" <adeeb@techlogix.com> escribió en el mensaje
news:%23cA8gbyMEHA.808@tk2msftngp13.phx.gbl...
> I am using "Tool" -> "Connect to Database" option in the menubar of Visual
> Studio .NET 2002 to connect to Oracle 8i database. For this I am using
> "Microsoft OLE DB Provider for Oracle" Provider. When I give machine name
> and username/password on the next tab and click "Test Connection" it gives
> me following error:
>
> Test connection failed because of an error in initializing provider.
> ORA-12514: Message 12514 not found; product=RDBMS80; facility=ORA
>
> image is attached.
>
> Any ideas about how to connect to Oracle 8i using Visual Studio .NET 2002?
>
> Thanks
> Adeeb Ashraf
>
>
>
>

Relevant Pages

  • Re: OLEDB Error
    ... I am able to use the Add Data Source and Add Connection wizards in VS to add a SQL Compact database as a data source, for example, or are you referring to some other functionality you get by adding this registry key yourself? ... I assume that by removing the key and then repairing the SQL Compact installation not fixing it, that VS installs that key so perhaps a repair of VS might return it after it's removed. ... the OleDb support in SQL Compact doesn't ... Also the SQLCE OleDB provider does not show up in the listed OleDB ...
    (microsoft.public.sqlserver.ce)
  • Re: TSP is not getting Started after installation
    ... delete the provider and add it again using manage providers, ... Is TSPI_providerInstallcalled during installation? ... TAPI / TSP Developer and Tester ... resolved after adding the provider through control panel. ...
    (microsoft.public.win32.programmer.tapi)
  • [HPADM] SUMMARY INstalling Oracle on HP 11.0
    ... "What I have found is that the oracle installation itself, ... semaphore and shared memory related kernel parameters. ...
    (HP-UX-Admin)
  • Re: TSP is not getting Started after installation
    ... delete the provider and add it again using manage providers, ... Is TSPI_providerInstallcalled during installation? ... TAPI / TSP Developer and Tester ... resolved after adding the provider through control panel. ...
    (microsoft.public.win32.programmer.tapi)
  • Re: OLEDB Error
    ... I just reread your message and see you are trying to access SQL Compact from Visual Objects. ... If I remove the complete key and repait the SqlCE installation, the OLE DB Provider-entry it is not added. ... the OleDb support in SQL Compact doesn't ... Also the SQLCE OleDB provider does not show up in the listed OleDB ...
    (microsoft.public.sqlserver.ce)