Solved

SQL Anywhere 10 ODBC driver install

Posted on 2011-09-20
7
5,131 Views
Last Modified: 2012-05-12
I am told by SAP I need to install an ODBC driver on a Windows 2008 64 bit server that will function as a Crystal Report server that will access an SQLAnywhere 10 db on another server.   Other windows clients are using version 10.0.1.3807 of the driver to access that database.   We have a license to install it but the version I found to download as SQLanywhere sql1001win3264 is the whole database which I do not want to install because there are already 2 other databases on this system.  If I deselect everything except "network database client" is that going to install just the ODBC drivers?  Or what should I select or download?
0
Comment
Question by:thefumbler
  • 4
  • 3
7 Comments
 
LVL 1

Author Comment

by:thefumbler
ID: 36571276
0
 
LVL 14

Expert Comment

by:Brook Braswell
ID: 36574459
SQL Anywhere has a deployment msi you can use to install just the driver..

It is named SQLAnyDeploy.MSI

0
 
LVL 1

Author Comment

by:thefumbler
ID: 36575271
brook, I can't find this in the sybase downloads for SQLAnywhere.  Do you have a  link?
0
ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 
LVL 14

Accepted Solution

by:
Brook Braswell earned 500 total points
ID: 36576263
If you have anywhere installed already on a computer then as I understand it you use the deployment wizard to create the MSI.  It has been over 4 years since I went that route but here is some information on the subject.

http://dcx.sybase.com/1101/en/dbprogramming_en11/deploy-s-4228164.html
0
 
LVL 1

Author Comment

by:thefumbler
ID: 36576939
Brook, the article states that "Deployment Wizard does not include support for creating deployments of the 64-bit software components"   which unfortunately is exactly what I need.    
0
 
LVL 14

Expert Comment

by:Brook Braswell
ID: 36580183
Try just creating the driver - then add the driver to your 64bit ODBC Administrator manually.
WOW64
0
 
LVL 1

Author Comment

by:thefumbler
ID: 36718712
Apparently I didn't have the full install, but the Deployment wizards is an option when you do an install of SQL Anywhere.  Once I did the install on another system I was able to run the Deployment Wizard and generate an install file as mentioned (SQLAnyDeploy.MSI) with either /both the 32 bit /64 bit ODBC drivers.   Running the .msi file on the server finally got me to the final destination.  

thanks
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

SEO can be a real minefield to navigate, but there are three simple ways to up your SEO game just be re-assessing your content output.
Data breaches are on the rise, and companies are preparing by boosting their cybersecurity budgets. According to the Cybersecurity Market Report (http://www.cybersecurityventures.com/cybersecurity-market-report), worldwide spending on cybersecurity …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question