Re: Accessing an Oracle database with vb.net

"Patrick Steele" <patrick@xxxxxxxx> wrote in message
news:MPG.204d568125fcf102989721@xxxxxxxxxxxxxxxxxxxxxxx
In article <e#hQ7JfWHHA.1208@xxxxxxxxxxxxxxxxxxxx>, mbrown@xxxxxxxx
spam.org says...
I'm trying to access an Oracle database vb.net. I found several
examples.
I tried following each one, but I get the same error no matter what I
try.
I don't really understand what the error means (I've never tried
accessing
an Oracle database before). The error I get is:

ORA-12514: TNS:listener does not currently know of service requested in
connect descriptor

I installed the oracle dll and added it as reference (I get the same
error
if I use the Oracle reference that came with VS2003.) I figure it's
hitting
the database ok since if I change the name of the database it's
connecting
to, I get an error that it couldn't resove the name.

It's been a few years since I had to deal with Oracle, but I'll give it
a shot.

First, when you say you "installed the oracle dll", does that mean you
actually installed the oracle client? If not, I would install the
oracle client and include SQL plus during the installation. SQL Plus is
a kind of isql/w (if you're familiar with SQL Server).

Once the client is installed, make sure you tnsnames.ora file is
configured correctly. This, I can't help you with since I don't
remember what is necessary, but I do recall that was a source for
frequent frustration.

Third, make sure the Oracle listener service is running on the oracle
server.

Good luck!

Thanks for the reply. I do have the client installed and I can access the
database using Query Builder. But in my application, when it tries to
connect, I get that error, which from what I've been able to find out means
that I contacted the server, but not registered with the listener. But no
one ever seems to mention how to do that.

Mark


.

Relevant Pages

  • Re: AIX 4.3.3 , Oracle 7.3.4 coredumps at startup
    ... I cannot port the database to Oracle 8 or later since the app ... > the apps that are now reserved words in Oracle 8 and later. ... Put away your installation media and forget a new install for the moment. ...
    (comp.unix.aix)
  • Re: how to activate oracle text in 10g enterprise
    ... general purpose database, or if he wanted to study otext, and was ... 'Oracle Text' option from the DBCA screen. ... If you experienced oracle warnings and errors during the install ...
    (comp.databases.oracle.server)
  • Re: Unable to manually create RAC database
    ... some assistance with this as my RAC experience is very limited. ... I have managed to manually create a single instance database (on ... With the Partitioning, Real Application Clusters, OLAP and Oracle Data ... can get with a manual install. ...
    (comp.databases.oracle.server)
  • Re: Cant get Oracle OLE DB provider to work from SSIS on a 64-bit environment
    ... The project I'm trying to get running, consists of approx 25 seperate packages where 3-4 of them gets data from different Oracle sources, but I'm not even got to the point where I'm trying to run the whole lot. ... There are two issues in the topic that could be an issue, and that is to switch the whole project to 32-bit mode and then the part that says that the Designer only shows 32-bit versions of the provider. ... What I think I'll try now, it to install the 32-bit version of the Oracle ODAC to see if that makes any difference. ... uninstall ODAC and when I uninstall the regular Oracle Client with the ...
    (microsoft.public.sqlserver.dts)
  • Re: ADO connection to Oracle
    ... did you install mdac 2.7 on the machine? ... > The program always stops at the connection to the database. ... > connection is made using generic OLE DB, not the Oracle data provider. ...
    (microsoft.public.vb.database.ado)