Normal Topic Install/Config Sesame odbc on windows 7 (Read 3970 times)
alex_smits
Member
*
Offline


No personal text

Posts: 27
Location: Arnhem, The Netherlands
Joined: Dec 15th, 2003
Install/Config Sesame odbc on windows 7
Feb 25th, 2011 at 7:00pm
Print Post Print Post  
How can i setup the sesame odbc drive on windows 7 64-bits
The setup give the message that's not compatible.

When i start drvstp32.exe it's starts but when i click next the message apears SQLinstallODBc is not supported.

Kind regards

Alex
  
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Install/Config Sesame odbc on windows 7
Reply #1 - Feb 28th, 2011 at 5:55pm
Print Post Print Post  
Hello Alex,

What kind of program are you going to be using to connect through ODBC to Sesame? If it is a 32 bit program than what you are after is possible, but since the ODBC installer is 32 bit it won't run on your system. This means you have to do the install of the ODBC driver by hand. This requires modifying the windows registry as well as registering a few dlls.

If the program you wish to connect to Sesame is a 64 bit program, There is a very high chance it can not read our 32 bit ODBC driver. I know that the 64 bit version of Microsoft Office will not connect to our ODBC driver.

You may be better off looking into using the Sesame API which can be found at http://www.lantica.com/Products/sesame_api.html

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
alex_smits
Member
*
Offline


No personal text

Posts: 27
Location: Arnhem, The Netherlands
Joined: Dec 15th, 2003
Re: Install/Config Sesame odbc on windows 7
Reply #2 - Feb 28th, 2011 at 6:32pm
Print Post Print Post  
Hello Ray,

It's a 32 bits program Crystal Reports that i want to connect to sesame with the ODBC driver.

Kind Regards.

Alex
  
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Install/Config Sesame odbc on windows 7
Reply #3 - Feb 28th, 2011 at 7:20pm
Print Post Print Post  
Hello Alex,

Below are steps that I have gotten to work. 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.
16. Right Click on Sesame ODBC Driver and choose New->String Value
17. Name the new string value "Setup", without the quotes.
18. Set the value data of Driver to "C:\Windows\SysWOW64\sesodbc.dll", without the quotes.
19. Right Click on Sesame ODBC Driver and choose New->String Value
20. Name the new string value "CPTimeout", without the quotes.
21. Set the value data of Driver to "<not pooled>", without the quotes.
22. Close the windows Registry Editor
23.  Open a command line and browse to C:\Windows\SysWOW64\
24.  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

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
alex_smits
Member
*
Offline


No personal text

Posts: 27
Location: Arnhem, The Netherlands
Joined: Dec 15th, 2003
Re: Install/Config Sesame odbc on windows 7
Reply #4 - Mar 14th, 2011 at 9:37am
Print Post Print Post  
Thank you it works perfect  Smiley
  
Back to top
IP Logged