fixing ORA-12154 after making oraoledb appear

I had to replace a hard drive, reinstall win 7, reinstall Delphi XE2, Interbase, and reinstall the Oracle client. Done. Delphi runs perfectly using Interbase.

The first major problem was when using an ADO Connection, when I went to build the connect string, there was no option to select "ORACLE Provider for OLEDB" . I checked after the Oracle  client installation (done 3 times), and the path was set, the ORAOLEDB10US.DLL and several similarly named dlls were in the path.

I kept thinking there must be a way to tell delphi where the oledb choices are located, but I found a solution that makes no sense but it worked. I am running Oracle personal on a different pc. I then installed ORACLE11 XE from a 5 year old or older CD I have on the Delphi PC, and after the installation, Delphi now offers "Oracle provider for oledb" as a choice when building the connection string.

I then tried to write programs that could connect to either Oracle - the OracleXE on the same PC, or Oracle Personal on another machine. Here comes the mystery: When I build a connection string in Delphi and click the TEST button it always fails with ORA-12154. I searched the web and found a lot of people have this problem and I did not find anything useful. I spent a lot of time changing the tnsnames.ora file, but not my connection string with fail the test on either Oracle.
Then I discovered the fix for me - I found that after building the connection string, and even after the test of it fails with ORA-12154, if I run the program after compiling it, it works. This works for either Oracle.

Does anyone have an explanation of this - an ADOCONNECTION that fails in the IDE when using the "TEST" button when building the string, but then works fine if you compile it and run the EXE file? And any explanation on why Delphi did not see the Oracle Provider for OLEDB even after several installations of Oracle Client, yet it started working after installing Oracle XE?

I hope that this info is useful for others who may be stuck for days like I was. Everything seems to be running fine for me, but I still would like to understand why.
0
steve
6/22/2015 5:04:57 AM
embarcadero.delphi.ado 597 articles. 1 followers. Follow

0 Replies
732 Views

Similar Articles

[PageSpeed] 39

Reply:

Similar Artilces:

superreview granted: [Bug 415319] Make the feedhandlers appear like part of Camino (no alerts on launching, auto-appear in the menu) : [Attachment 310633] full fix
Mike Pinkerton (not reading bugmail) <mikepinkerton@mac.com> has granted Stuart Morgan <stuart.morgan@alumni.case.edu>'s request for superreview: Bug 415319: Make the feedhandlers appear like part of Camino (no alerts on launching, auto-appear in the menu) https://bugzilla.mozilla.org/show_bug.cgi?id=415319 Attachment 310633: full fix https://bugzilla.mozilla.org/attachment.cgi?id=310633&action=edit ------- Additional Comments from Mike Pinkerton (not reading bugmail) <mikepinkerton@mac.com> sr=pink we seem to have so much going on at startup on separa...

superreview requested: [Bug 415319] Make the feedhandlers appear like part of Camino (no alerts on launching, auto-appear in the menu) : [Attachment 310633] full fix
Stuart Morgan <stuart.morgan@alumni.case.edu> has asked Mike Pinkerton (not reading bugmail) <mikepinkerton@mac.com> for superreview: Bug 415319: Make the feedhandlers appear like part of Camino (no alerts on launching, auto-appear in the menu) https://bugzilla.mozilla.org/show_bug.cgi?id=415319 Attachment 310633: full fix https://bugzilla.mozilla.org/attachment.cgi?id=310633&action=edit ------- Additional Comments from Stuart Morgan <stuart.morgan@alumni.case.edu> Smokey found LSBackgroundOnly; between that and setting an explicit background launch flag usin...

superreview granted: [Bug 340119] [FIX]Changing print preview settings makes <noscript> tags appear : [Attachment 224204] Maybe this will make life better?
Jonas Sicking <bugmail@sicking.cc> has granted Boris Zbarsky <bzbarsky@mit.edu>'s request for superreview: Bug 340119: [FIX]Changing print preview settings makes <noscript> tags appear https://bugzilla.mozilla.org/show_bug.cgi?id=340119 Attachment 224204: Maybe this will make life better? https://bugzilla.mozilla.org/attachment.cgi?id=224204&action=edit ...

Convert Delphi 5 ADO App to Delphi 2007 ADO.NET
I have an appliction tha that is writen in Delphi 5 with ADOConnetion, ADOTable, and ADOQuery components. I need to upgrade to Delphi 2007 and use ADO.NET. I have the program building in with Delphi 2007. Is there anything I need to do to convert the ADO to ADO.NET? > I need to upgrade to Delphi 2007 and use ADO.NET. Why ? -- With best regards, Dmitry Arefiev AnyDAC (www.anydac.com) - Oracle, MS SQL Server, IBM DB2, MySQL, Firebird, Interbase, PostgreSQL, Sybase ASA, SQLite, MS Access, DBX, ODBC, InMem - universal high-speed native data access engine Reasons for ...

Fixes fixes fixes
Here we go again. Find attached version 1.2 of my Java wrapper classes. Dave Wolf Internet Applications Division begin 666 JavaWrappers.ssc M/"$M+5-#4DE05"!*879A5W)A<'!E<G,N<W-C(&-R96%T960@;VX@5&AU+" P M-2!!=6<@,3DY.2 P,3HT.3HT,0T*+RH@("HO#0H-"@T*+R\O+R\O+R\O+R\O M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O M+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\O+R\-"@T*+R\@2F%V82 M/B!0 M;W=E<D1Y;F%M;R!(96QP97(@8VQA<W-E<PT*+R\@5F5R<VEO;B Q+C(-"B\O M($1A=F4@5V]L9@T*+R\@8V]P>7)I9VAT(#$Y.3D@4WEB87-E($EN8R!...

Delphi code makes an appearance in the Daily WTF
As per subject line: http://thedailywtf.com/Articles/That-Kind-of-Security.aspx -- Dave Nottage [TeamB] Dave Nottage wrote: > As per subject line: > > http://thedailywtf.com/Articles/That-Kind-of-Security.aspx Probably one of the guys complaining that upgrading to D2009 is a PITA ;-) -- Pieter Wow... Hope the original author isn't still in the business. The list of procedures they are joking about in the comments sections looks like VB syntax Buyit(); useit(); breakit(); fixit(); Trashit(); changeit(); mail_upgradeit(); Chargeit(); ...

Re: Delphi code makes an appearance in the Daily WTF
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --JivePart=_19445.zeB8CwDOH5aMJzMl Content-Type: text/plain; charset="Utf-8" "Andy Syms" <asyms@technosoft.co.uk> wrote in message news:104150@forums.codegear.com... > Kevin Frevert wrote: > >> Probably the bigger WTF is why the original developer put it there >> (I'll reply for those curious). > > We're waiting... The code is somewhat a line-for-line conversion of the 'converted&#...

Make Porting/expand-macro.pl work with a make other than `make`, also Win32 compatibility fixes
--------------040507080907060101050501 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit Hello, recently it came to my attention that `Porting/expand-macro.pl` does not work if your `make` tool is named anything other than `make`. The first attached patch changes it so that it loads Config.pm and uses the configured $Config{make} from there. I presume that anybody running `Porting/expand-macro.pl` also knows about how to give `perl` the appropriate Config.pm resp. how to invoke the proper Perl. The second patch assumes that `Porti...

Delphi 6 to Delphi 2010 upgrade and ADO
We have an application written in Delphi 6 Professional that uses ADO to access databases servers that may be on other PCs in our network. We want to move to Delphi 2010 but can't decide if we need Professional or Enterprise. 2010 Pro has dbGO - will this give us the same functionality as the ADO components we use in Delphi 6 Pro? Thanks, Keith > 2010 Pro has dbGO - will this give us the same functionality as the > ADO components we use in Delphi 6 Pro? Yes. > {quote:title=Joachim Uersfeld wrote:}{quote} > > 2010 Pro has dbGO - will this give us the same func...

ASA7 ADO & Delphi ADO ?? Anyone is using it?
Any comments? Is it working? Any Problems? Thanks Hi, PR <noemail@no.com> schrieb in im Newsbeitrag: BoTThJaq$GA.89@forums.sybase.com... > Any comments? Is it working? Any Problems? I tried to connect to ASA7 via the new OLE DB - Provider and ADOExpress from Delphi 5.01. No chance. Only the error message 'Invalid Enum Value'. About the new provider I haven't heard anything good until now... Regards Frank Frank, I've experienced the same problem with the ASA 7 OLEDB Provider. I'm not sure if this is a bug in the AsaProvider or Delp...

How to make a link button appear without the underline appearance?
Can some tell me how I could change the appearance of a link button, so that it appears just like normal text without any underlined link appearance?sun21170 In your css, you can set the a:hover   text-decoration: none;  this will take the underline away from all linkbuttons and hyperlinks. You can create a css class.will appear without being underlined. Hope this helps. www.hopeasp.net you could just use a CSS style<asp:LinkButtom id="Link" CssClass="ClassSomething" runat="server" />  a.ClassSomething {color: Black;    text-underli...

fix not fixed?
http://www.infoworld.com/article/03/09/08/HNhackersjump_1.html ...

ORA
Hello, I have a problem to access to oracle database with asp.net 1.1. I have a database server Oracle 8i on a machine. I have an other machine with a IIS server and Oracle CLIENT 9i. I try to access with the Oracle Data Provider (ODP 9.2) OR whith system.data.oracleclient but i have alway the same error message: ORA-12154: TNS Symbolic adress could not be resolved I can log on database with SQLPlus or with VB.net application but not with asp.net. I give to IUSR, IWAN and ASPNET user right on ORACLE920 directory. code part:Dim con As New Oracle.DataAccess.Client.OracleCo...

ORA-12154
--0-1375756846-1091566308=:54889 Content-Type: text/plain; charset=us-ascii Hi list Command line script test2-cgi works fine but when I try from the browser it is giving the following error DBI connect('db1','report',...) failed: Error while trying to retrieve text for error ORA-12154 (DBD ERROR: OCIServerAttach) at /home/report/www/cgi-bin/test2-cgi line 72 I have complete ORACLE environment set, I can connect using sqlplus and also can run tnsping the database without any issues at command prompt. Anyone know how to fix this issue?. Thanks in advance ...

Web resources about - fixing ORA-12154 after making oraoledb appear - embarcadero.delphi.ado

热门搜索 - 我的异常网
我的异常网之热门搜索专题提供权威的各类程序问题解决方案,欢迎您的到来。

Classic MetaLink vs. My Oracle Support
Jared Still's Ramblings Here you will find posts that are mostly about my work as an Oracle DBA. There may occasionally be other topics posted, ...

Resources last updated: 1/21/2016 2:50:02 AM