Our Powerbuilder application uses the SQL Anywhere database through an 32-bit ODBC setting. In the past we rarely had more than 20-25 users and were happy just to install the SQL Anywhere network client from a SQL Anywhere CD setup, but now we are getting into deploying many more, and this is becoming unfeasible.
I can see on several websites that a group of files we need for a SQL Anywhere 32-bit driver are
or for SQL Anywhere 16 just "16" instead of "11" in those names.
We would like to copy these (and if necessary, any other files) just in a subfolder of our application, say C:\OurSystem\Drivers, as a part of a deployment to the new client, but what other steps do we need to carry out regarding registry (or otherwise) to make sure that we can open ODBC Administrator and create an ODBC Data source?
On one Windows 8 machine we tried regsvr32 dbodbc11.dll but we got a complex looking error message.
Do we need additional registry entries to
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Anywhere 11
and similar, I keep finding few websites, but not one clear document with full instructions, or is there a utility that will do this that we can download?