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

Glenn%20Barber's gravatar image

Glenn Barber
accept rate: 8%

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

 c:\windows\SysWOW64\regsvr32 %sqlany12%\bin32\dbodbc12.dll

This will install the 32 bit ODBC driver. The dbdsn command line utility can be used to create the DSN for your application.

permanent link

answered 20 Mar '12, 08:25

Chris%20Keating's gravatar image

Chris Keating
accept rate: 32%

edited 20 Mar '12, 10:54

Graeme%20Perrow's gravatar image

Graeme Perrow


More details on required files and configuring the ODBC driver can be found in the doc under deploying ODBC clients.

(20 Mar '12, 08:37) Bill Frier

I don't have a problem to access a V12 DB with V11 odbc even if host=... is used, so where would you see a problem with the host parameter?

(21 Mar '12, 07:12) Martin

The question indicated that the host is being changed to a vitual machine. If the DSN is using the HOST=, it must to updated to the host name or ip of the virtual machine.

(21 Mar '12, 07:21) Chris Keating
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 19 Mar '12, 22:31

question was seen: 3,471 times

last updated: 21 Mar '12, 07:21