Greetings Alex P.
Thank you so much for your guiding hand. I truely do appreciate it.
Issue: On set SQLConnection1.Active to 'True', I receive the ubiquitous 'ORA-12154' exception
(TNS: could not resolve the connect identifier specified)
Here is the information you requested:
1) - the exact version of dbExpress driver for Oracle
1) dbexpress140.bpl
2) Version: 14.0.3615.26342
3) Location: C:\Windows\system32\
2) - the exact version of Oracle server and client
1) Server:
1) Product Name: Oracle 10g XE
2) Version: 10.2.0
3) Service Name: OracleServiceXE
4) File Name:
1) Windows Explorer: oracle.exe
2) However, from the Windows Services dialgue, the Properties
dialogue, in the General tab lists this as the file name:
ORACLE.EXE XE
Note the addidional ' XE' at the end
5) Location: c:\oraclexe\app\oracle\product\10.2.0\server\bin\
2) Client:
1) Name: oci.dll
2) File Version: 10.2.0.1
3) Location: C:\oraclexe\app\oracle\product\10.2.0\server\BIN
4) Date modified: 2006.2.1
5) Permissions:
1) Auth Users: Read & execute, Read
2) SYSTEM: Full control
3) Admins: Full control
Here is other infornmation that might help you:
GENERAL:
1) Oracle 10g XE is running on my local machine
2) My machine is not connected to any network
3) There two Profiles on my Windows 7 machine (Administrator, Owner)
1) The Owner Profile is the only one I use
4) The Delphi app is minimal: one form with TSQLConnection component
(app compiles)
5) Project Location: C:\Users\Owner\Documents\RAD Studio\Projects\
VERIFICATIONS:
1) I have verified that the following Windows Services are running:
1) OracleServiceXE
2) OracleXEClrAgent
3) OracleXETNSListener
2) I have verified the tnsnames.ora by connecting to Oracle with PL/SQL
Developer dev tool
1) This commercial app is written in Delphi
2) However, they have written their own Oracle driver
HARDWARE:
1) CPU: Intel Core 2 Duo CPU 07350 @ 2.00GHz
2) Available Memory: >4Gig
SOFTWARE:
1) OS:
1) Windows Ultimate
2) Version: 7.6.1 (Build 7600)
2) Delphi:
1) Delphi 2010 Architect edition
2) Version 14.0.3593.25826
3) tnsnames.ora:
1) There is one and only one tnsnames.ora on my entire C drive
2) Location: C:\oraclexe\app\oracle\product\10.2.0
\server\NETWORK\ADMIN
3) This is the first entry in my tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Owner-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
4) There are only two other tnsnames.ora entries:
1) EXTPROC_CONNECTION_DATA =
2) ORACLR_CONNECTION_DATA =
TSQLConnection properties:
1) Connected: False
2) ConnectionName: ORACLECONNECTION
3) GetDriverFunc: getSQLDriverORACLE
4) KeepConnection: True
5) LibraryName: dbxora.dll
6) LoadParamsOnConnect: False
7) LoginPrompt: False
Name: SQLConnection1
9) Params:
1) DriverName: Oracle
2) Database: (I have tried the following)
1) XE
2) localhost:1521:XE
3) DEDICATED:1521:XE
3) UserName: (I have tried the following)
1) hr (the oracle-suggested user)
2) SYSDBA
3) SYSOPER
4) Password: hr (oracle default)
5) RowsetSize: 20
6) BlobSize: -1
7) ErrorResourceFile: (this is blank)
LocaleCode: 0000
9) IsolationLevel: ReadCommitted
10) OS Authentication: I have tried the following:
1) True
2) False
11) Multiple Transaction: False
10) Tag: 0
11) VendorLib: oci.dll
NOTE: I have tried all combinations of Params properties with multiple values listed above.
OTHER:
1) The Delphi docs say that double-clicking on TSQLConnection
component, that a dialog should open. This does NOT happen.
1) I don't know if the docs are wrong or the component is not working
If you need any other info, please let me know.
Again, Alex, thank you for all your hard work.
Keith
ps. I had this in a nice outline, but in Preview mode, all formatting is lost