Difference between revisions of "Oracle"
From Team Developer SqlWindows Wiki
DaveRabelink (Talk | contribs) (Added tip on Oracle 32 vs 64 bit Clients) |
DaveRabelink (Talk | contribs) 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 |
Oracle SQL.ini examples 
[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
Oracle Client: 32 vs 64 bit
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.
