We have a installation with SQL anywhere 11 on an Intel 32 bit Server with about 60 windows clients using ODBC access scattered around the company.
The company wants to move to SQL Anywhere 12.0.1 on Windows 64 bit in a virtual environment.
There are no changes to the database schema or application being made.
Can we safely move the Server to SQL Anywhere 12.0.1 and continue to keep some or all of the users on the existing V11 32 Bit ODBC Client Drivers. (not changing the ServerName)
Additionally, is there a simple way to deploy new 32 Bil Version 12 ODBC Client drivers and Connection specification in the enterprise without having to execute msi's on each machine?
asked 19 Mar '12, 22:31
Your existing DSNs should continue to work provided it is not using anything that uniquely identifies the machine hosting the database (i.e., HOST=<machine_name_or_ip> ).
Deployment does not require going through an installer. You can manually copy the required files into the deployment and run
This will install the 32 bit ODBC driver. The dbdsn command line utility can be used to create the DSN for your application.