Difference between revisions of "Oracle"

From Team Developer SqlWindows Wiki
Jump to: navigation, search
(Added tip on Oracle 32 vs 64 bit Clients)
m
 
Line 3: Line 3:
  
 
__TOC__
 
__TOC__
 +
 +
 +
<!------------------------------------------------------------------------------------------------------------------------------>
 +
{{TipHeader|Oracle SQL.ini examples}}
 +
 +
 +
<pre>[win32client]
 +
clientname=MYCLIENT
 +
 +
[win32client.dll]
 +
comdll=sqlora32
 +
 +
[ORAGTWY]
 +
longbuffer=32767
 +
substitute=SYSSQL.,
 +
substitute=",
 +
substitute=SYSSQL.,SYS.
 +
fetchrow=20
 +
nodefparse=yes
 +
 +
 +
remotedbname=MYTDDBS,@ORCLDBS
 +
 +
 +
[win32client.ora32]
 +
 +
log=c:\SQLlog.txt
 +
</pre>
  
  

Latest revision as of 07:37, 25 July 2013

Oracle


Contents


Pointer2.png Oracle SQL.ini examples Pointer.png


[win32client]
clientname=MYCLIENT

[win32client.dll]
comdll=sqlora32

[ORAGTWY]
longbuffer=32767
substitute=SYSSQL.,
substitute=",
substitute=SYSSQL.,SYS.
fetchrow=20
nodefparse=yes


remotedbname=MYTDDBS,@ORCLDBS


[win32client.ora32]

log=c:\SQLlog.txt


Pointer2.png Oracle Client: 32 vs 64 bit Pointer.png

You should be aware that 32bit applications can not use the 64bit Oracle Client installation.
For now, all TD build applications (TD 1.x up to TD 6.2) on Win32 platform are 32bit.
Only on the .NET platform, starting with TD 6.2, you are able to build 64bit .NET targets.


So rule is, always use 32bit Oracle Client installations when building Win32 TD applications.
When building TD 6.2 .NET targets on 64bit, you can use the Oracle 64bit Client.