We have a customer in Saudi Arabia. Given the time difference and their security policies, it is difficult to effect a remote-in with them. I think they are running sqla 10 on a 32 bit server. They want to create a 64 bit odbc driver msi to install on a 64 bit workstation. Normally, I would just have them visit the sqla 10 Deployment directory and create a driver msi. However, since this is a 32 bit sqla on a 32 bit server, I don't think that sqla will offer the 64 bit option. Any ideas/suggestions for this customer? Thanks, Doug.

asked 09 Jul '13, 19:28

dejstone's gravatar image

dejstone
959395069
accept rate: 0%

edited 10 Jul '13, 06:48

Volker%20Barth's gravatar image

Volker Barth
30.8k308456665

Comment Text Removed

Some might ask "Are you kidding?" but stranger proposals have been made.

Like H.R. 2617 To establish the Apollo Lunar Landing Sites National Historical Park on the Moon.

Both are admirable but alas, I suspect neither is feasible.

(09 Jul '13, 19:53) Breck Carter

Breck, don't you think it's a little below the bar to compare the noble efforts of those in this community, in any way, to what emerges from our Congress? :)

(09 Jul '13, 20:12) dejstone
Replies hidden

Yes, I apologize, I could not resist because I had just read HR 2617 before your seeing your post and they both seemed... so... unlikely.

The good news is, Dietrich and Volker have suggestions... clearly they are skilled practitioners of the Dark Arts and I am but a muggle.

(10 Jul '13, 07:25) Breck Carter

skilled practitioners of the ...

No, for God's sake, the Deployment Wizard is the only "magical" tool I use.

Besides that, we're currently preparing for project "Luna migration":)

(10 Jul '13, 07:39) Volker Barth

The SQL Anywhere installer doesn't install the 64-bit binaries on a 32-bit installation - neither will an MSI file deployment.

You need to instead take these files from an existing 64-bit SQL Anywhere installation. If you don't want to create an distribution MSI via the Deployment Wizard from the 64-bit installation as Dietrich/Volker suggests, the command to manually install the ODBC driver is short if you are just copying the files:

  1. Install SQL Anywhere on a 64-bit machine, with the appropriate distribution license
  2. Take the required ODBC files listed in the documentation from \bin64 for the ODBC driver, and copy them to the target computer
  3. From a Command Prompt, type regsvr32 c:\path\to\bin64\dbodbc12.dll.
  4. Launch the 64-bit ODBC Administrator c:\Windows\System32\odbcad32.exe to see the 64-bit driver in the 'Drivers' section.

Also see: http://dcx.sybase.com/index.html#1201/en/dbprogramming/configuring-driver-client-deploy.html

Always ensure that you are licensed to distribute these client components and are limiting the number of installations to the number of seats that you are currently licensed for.

permanent link

answered 10 Jul '13, 09:41

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

Hi dejstone,

creating MSI, using the Deploymet Wizard, containing the 64bit binaries was introduced in SQL Anywhere 12. See http://dcx.sybase.com/index.html#1201/en/sachanges/newinnsbruck-s-5065038.html

So, you customer would need to either use the standard SQL Anywhere installer, manually install the components or create their own MSI installer.

Kind regards,

Dietrich

permanent link

answered 10 Jul '13, 03:13

Dietrich's gravatar image

Dietrich
13614
accept rate: 0%

And you can't build a MSI for them?

Besides Dietrich's suggestions, there might be a further option:

In case they also have a v12 64-bit installation available, they could also use that to create a v12 ODBC client MSI with the help of the Deployment Wizard - in general a v12 client should work with a v10 server as well as a v10 client.

permanent link

answered 10 Jul '13, 03:48

Volker%20Barth's gravatar image

Volker Barth
30.8k308456665
accept rate: 32%

If the customer has licenses for SQL Anywhere 12, they could also use the Client installer. See http://www.sybase.com/detail?id=1087327

(10 Jul '13, 06:02) Dietrich
Replies hidden

Yes, though as discussed in the following FAQ, that is a "heavy setup" when only the ODBC client is required:

(10 Jul '13, 06:50) Volker Barth

Thank you for the great feedback this issue. It's wonderful when feedback on a technical issue is both informative and entertaining. I decided to create an odbc client msi with my 64 bit SQLA 12. I zipped-up the msi and sent it to our customer. Thanks again!

permanent link

answered 11 Jul '13, 11:36

dejstone's gravatar image

dejstone
959395069
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

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:

×125
×114
×26
×24

question asked: 09 Jul '13, 19:28

question was seen: 1,202 times

last updated: 29 Jul '16, 17:03