• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6240
  • Last Modified:

SQL Anywhere 10 ODBC driver install

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
thefumbler
Asked:
thefumbler
  • 4
  • 3
1 Solution
 
thefumblerAuthor Commented:
0
 
Brook BraswellApplication Development ManagerCommented:
SQL Anywhere has a deployment msi you can use to install just the driver..

It is named SQLAnyDeploy.MSI

0
 
thefumblerAuthor Commented:
brook, I can't find this in the sybase downloads for SQLAnywhere.  Do you have a  link?
0
Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

 
Brook BraswellApplication Development ManagerCommented:
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
 
thefumblerAuthor Commented:
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
 
Brook BraswellApplication Development ManagerCommented:
Try just creating the driver - then add the driver to your 64bit ODBC Administrator manually.
WOW64
0
 
thefumblerAuthor Commented:
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now