Skip to content

Instantly share code, notes, and snippets.

@pmgreen

pmgreen/strawn_vger_test.md

Created March 18, 2016 15:38
Show Gist options
  • Save pmgreen/e7e26bfb0e69fe391749 to your computer and use it in GitHub Desktop.
Save pmgreen/e7e26bfb0e69fe391749 to your computer and use it in GitHub Desktop.
Download ZIP
Getting Gary Strawn's programs to work with Voyager Test db at PUL
Raw
strawn_vger_test.md

How to get Gary Strawn's programs to work with Test db

Tested with Record Reloader and VgerSelect on Windows 7 machine, Voyager BatchCat2009-11 (C:\Voyager\System)

  • Edit tnsnames.ora (indentation is important!). Under VGER config put:
TEST =
 (DESCRIPTION = 
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = test.ip.addr)(PORT = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = VGER)
 )
)
  • Use 32-bit Data Source program (sysWOW32\odbcad32.exe) to set database to 'TEST'
  • C:\Voyager\voyager.ini needs to point to Test ip address
  • Configure Strawn program to point to 'TEST'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment