Version work with Oracle 11G

[DelphiRox]

Can you tell me the earliest version of DOA that will work with 11G. It doesn't have to take advantage of new features. I just need to be able to do a quick demo with 11G.

 

[DelphiRox]

fyi, I am using Delphi 6,

 

[stef]

I'm using the normal version 4.1 of DOA for 11G in Borland C++ 5.
And the new Version for CBuilder 2010.

That is working just fine.

Br

 

[Marco Kalter]

Version 4.0 and later support 11g.

 

[DelphiRox]

When I try to connect I get error reading oraclesession1.connected: Initialization error SQL*NET not properly installed

OracleHomeKey: software\oracle
OracleHomeDir

 

[Marco Kalter]

Which Oracle Client version and edition are you using?

 

[DelphiRox]

This is running on the PC where Oracle is installed so I assume that the client was installed with the database. The OCI.dll version is 11.1.0.1 and was installed with the database installation.

 

[Marco Kalter]

And you are using Direct Oracle Access 4.0 or later? Can you send me your hkey_local_machine\software\oracle registry export? Please send it as an e-mail attachment with a .txt extension. You can also post it here if you want.

 

[DelphiRox]

I just did another test and found out the the session component was not properly set on my test app. It appears to be working now.

 

[Felix]

I am getting the same error (Initialization error SQL*NET not properly installed) with my Windows 7 Ultimate (32-bit) and Oracle 11gR2 (11.2.0.1.0). I am using Delphi 5 with DOA 4.1.1 on a Windows 2K Pro and Oracle 9iR2 (9.2.0.8.0) to compile and run my app ok.

Here are the Reg Entries from My Windows 7:

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"inst_loc"="C:\\Program Files\\Oracle\\Inventory"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home1]
"ORACLE_HOME"="C:\\app\\oracle\\product\\11.2.0\\client_1"
"ORACLE_HOME_NAME"="OraClient11g_home1"
"ORACLE_GROUP_NAME"="Oracle - OraClient11g_home1"
"ORACLE_BUNDLE_NAME"="Enterprise"
"NLS_LANG"="AMERICAN_AMERICA.WE8MSWIN1252"
"OLEDB"="C:\\app\\oracle\\product\\11.2.0\\client_1\\oledb\\mesg"
"OO4O"="C:\\app\\oracle\\product\\11.2.0\\client_1\\oo4o\\mesg"
"ORACLE_HOME_KEY"="SOFTWARE\\ORACLE\\KEY_OraClient11g_home1"
"MSHELP_TOOLS"="C:\\app\\oracle\\product\\11.2.0\\client_1\\MSHELP"
"SQLPATH"="C:\\app\\oracle\\product\\11.2.0\\client_1\\dbs"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home1\OLEDB]
"CacheType"="Memory"
"EnableCmdTimeout"="0"
"ChunkSize"="100"
"DistribTX"="1"
"FetchSize"="100"
"OSAuthent"="0"
"PLSQLRset"="0"
"PwdChgDlg"="1"
"SchRstLng"="10000"
"UserDefFn"="0"
"DisableRetClause"="1"
"VCharNull"="1"
"TraceCategory"="0"
"TraceFileName"="c:\\OraOLEDB.trc"
"TraceLevel"="0"
"TraceOption"="0"
"SPPrmDefVal"="0"
"StmtCacheSize"="0"
"MetaDataCacheSize"="0"
"DBNotifications"="0"
"DeferUpdChk"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home1\OO4O]
"CacheBlocks"="20"
"FetchLimit"="100"
"FetchSize"="4096"
"HelpFile"="C:\\app\\oracle\\product\\11.2.0\\client_1\\oo4o\\doc\\oraclec.chm"
"PerBlock"="16"
"SliceSize"="256"
"TempFileDirectory"="c:\\temp"
"OO4O_HOME"="C:\\app\\oracle\\product\\11.2.0\\client_1\\oo4o"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ODP.NET]

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ODP.NET\2.112.1.0]
"DllPath"="C:\\app\\oracle\\product\\11.2.0\\client_1\\bin"
"TraceFileName"="C:\\odpnet2.trc"
"TraceLevel"="0"
"TraceOption"="0"
"PromotableTransaction"="promotable"
"SelfTuning"="1"
"StatementCacheWithUdts"="1"
"UdtCacheSize"="4096"
"PerformanceCounters"="0"
"MaxStatementCacheSize"="100"
"DemandOraclePermission"="0"

 

[Marco Kalter]

Does this file exist?

C:\app\oracle\product\11.2.0\client_1\bin\oci.dll

 

[Felix]

Yes, I have it installed C:\app\oracle\product\11.2.0\client_1\BIN and is in my path. I works now after rebooting. The only difference is that I did recompile the app yesterday, but it still did not work, but this was before the reboot.

Is ok now.

Thanks