How to improve Windows performance and solve some of virtual memory issues 
Wednesday, May 24, 2006, 03:06 PM
After cleaning, defragmenting, and all usual things didn't do much I found PageDefrag freeware tool which did miracles in combination with extending size for the pagefile.sys


  |  [ 0 trackbacks ]   |  permalink  |  related link
How to setup The Object Type Translator (OTT) on Windows 
Tuesday, May 23, 2006, 12:43 AM
Location: ...\Oracle\instantclient_10_2\sdk\ott.bat

Add to Path:

C:\...\jdk\bin and C:\...\Oracle\Instant_client_10_1

(Yes, strangely enough, the OTT works only when linked to the directory with that version of the InstantClient...)

Add to CLASSPATH:

ojdbc14.jar
orai18n.zip
ottclasses.zip

Format for running OTT:

> ott userid=username/password@sid intype=demoin.typ outtype=demoout.typ code=cpp hfile=demo.h cppfile=demo.cpp mapfile=RegisterMappings.cpp

Despite that initially ott command ran OK without arguments there were some Java errors when it tried to connect the database.

The solution:

Copy classes12.jar and ojdbc14.jar
to the ott directory from ...\instantclient10_1 (!). Yes, it didn't work when I tried to use the same libraries from InstantClient 10_2....

OTT directory also needed a copy of the TNS file of course.


  |  [ 0 trackbacks ]   |  permalink  |  related link
Free wi-fi directory 
Wednesday, May 17, 2006, 09:41 PM
http://anchorfree.com/ has a good free wi-fi spots search. Unfortunately, there are not that many around where I live now....
  |  [ 0 trackbacks ]   |  permalink  |  related link
How to make Oracle OCCI work with MS Visual Studio 7 
Wednesday, May 17, 2006, 01:00 AM
...took me some time with all that variety of OCCI libraries available from Oracle site.

- Download the following from Oracle site:

instantclient-sdk-win32-10.2.0.1-20050930.zip

instantclient-basic-win32-10.2.0.1-20050930.zip


You can find them at http://www.oracle.com/technology/tech/o ... index.html

- Create empty Win32 Console Project.

- Create folder myproject\src in the new project directory.

- Create myproject\src\include and myproject\src\lib

- Unzip the sdk and basic client files and copy:

-- all *.h files ftrom instantclient_10_2\sdk\include to myproject\src\include

-- copy two libraries oci.lib and oraocci10.lib from \instantclient_10_2 to myproject\src\lib

- Put your myproject.cpp into \myproject\src

- In the VS7 UI:

1. Project Properties -> C/C++ -> General -> Additional Include Directories ->

add ...\myproject\src\include

2. Project Properties -> C/C++ -> Preprocessor -> Preprocessor Definitions ->

add WIN32COMMON;_DLL;_MT to the existing value

3. Project Properties -> Linker -> General ->Additional Library Directories ->

add ...\myproject\src\lib

4. Project Properties -> Linker -> Input -> Additional Dependencies ->

add: oci.lib msvcrt.lib msvcprt.lib oraocci10.lib

5. Project Properties -> Linker -> Input -> Ignore All Default Libraries ->

change it to Yes(/NODEFAULTLIB)

- Copy instantclient_10_2\oci.dll and instantclient_10_2\oraocci10.dll from the unzipped basic client directory to \myproject\Debug


6. Add to the Windows Path env variable
C:\...\Oracle\instantclient_10_2


this is all... works for me now



  |  [ 0 trackbacks ]   |  permalink  |  related link

Back