Difference between revisions of "Oracle"

From Team Developer SqlWindows Wiki
Jump to: navigation, search
m (New page: {{PageHeader|Oracle}} __TOC__ <!------------------------------------------------------------------------------------------------------------------------------> {{TipHeader|Enter new ti...)
 
m
 
(One intermediate revision by one user not shown)
Line 6: Line 6:
  
 
<!------------------------------------------------------------------------------------------------------------------------------>
 
<!------------------------------------------------------------------------------------------------------------------------------>
{{TipHeader|Enter new tip title here}}
+
{{TipHeader|Oracle SQL.ini examples}}
Enter new tip description here
+
 
 +
 
 +
<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>
 +
 
 +
 
 +
<!------------------------------------------------------------------------------------------------------------------------------>
 +
{{TipHeader|Oracle Client: 32 vs 64 bit}}
 +
You should be aware that 32bit applications can not use the 64bit Oracle Client installation.<br>
 +
For now, all TD build applications (TD 1.x up to TD 6.2) on Win32 platform are 32bit.<br>
 +
Only on the .NET platform, starting with TD 6.2, you are able to build 64bit .NET targets.<br>
 +
 
 +
 
 +
So rule is, always use 32bit Oracle Client installations when building Win32 TD applications.<br>
 +
When building TD 6.2 .NET targets on 64bit, you can use the Oracle 64bit Client.

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.