Lantica Software Support Center
Lantica Software Home Page


Knowledgebase

Setting Up The Sesame ODBC (Open Database Connectivity) drive on Windows 7 (64-bit)


"How can I set up the Sesame ODBC drive on Windows 7, 64-bits? I am using a 32 bit program Crystal Report that I want to connect to Sesame with ODBC driver."

Be very careful in following these steps:

  1. Copy sesodbc.dll from the Setup32 directory to C:\Windows\SysWOW64
  2. Open the Windows Registry Editor
  3. Make a backup of every key before you change it just in case
  4. Browse to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers
  5. Right click on ODBC Drivers and choose New->String Value
  6. Name the new string value "Sesame ODBC Driver", without the quotes.
  7. Set the value data of that new string value to "Installed", without the quotes.
  8. Browse to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI
  9. Right click on ODBCINST.INI and choose New->Key
  10. Name the new key "Sesame ODBC Driver", without the quotes.
  11. Right Click on Sesame ODBC Driver and choose New->String Value
  12. Name the new string value "Driver", without the quotes.
  13. Set the value data of Driver to "C:\Windows\SysWOW64\sesodbc.dll", without the quotes.
  14. Right Click on Sesame ODBC Driver and choose New->String Value
  15. Name the new string value "Setup", without the quotes.
  16. Set the value data of Driver to "C:\Windows\SysWOW64\sesodbc.dll", without the quotes.
  17. Right Click on Sesame ODBC Driver and choose New->String Value
  18. Name the new string value "CPTimeout", without the quotes.
  19. Set the value data of Driver to "", without the quotes.
  20. Close the windows Registry Editor
  21. Open a command line and browse to C:\Windows\SysWOW64\
  22. Type "odbcconf REGSVR C:\Windows\SysWOW64\sesodbc.dll"

At this point, you should see the Sesame under the Drivers tab when you execute C:\Windows\SysWOW64\odbcad32.exe