Sybase ODBC Driver for Mac

Classic Servoy
1

I’m trying to find an odbc driver for the Sybase DB I have servoy running under that works on Mac OS X. The closest thing I’ve found is this thing at Actual Technologies http://www.actualtechnologies.com/ but that costs money and I’m not sure if it would work. Does anybody know of a free ODBC Driver for Sybase for Mac?

Thanks.

2

What would you want to use ODBC for?

3

I’m trying to do a kind of mail merge with the data from the Sybase DB I have with my servoy application. What I’m looking to do is let the users kind of create their own custom looking reports based on different Queries and Views I’ve set up through like SQL Anywhere. And I know you can Merge the data into Word (at least on windows you can) via an ODBC Connection, so i’m trying to figure out if there’s an ODBC Driver for the Sybase DB that works on Mac.

I hope that makes sense, thanks in advance for the help.

4

Sql studio for mac comes with ODBC drivers, the only thing I don’t know is if they are available to applications like word on mac. There are also a few other options you can contemplate:

  • Merging within servoy itself
  • getting the data to word using text/html/xls: see reportmaker for some great examples. You can get reportmaker at www.clickware.com for free.
5

SQL Anywhere Studio for Mac OSX offers two forms of ODBC drivers (dylib and bundle). The bundle should work for GUI applications once you setup environment.plist and our ODBC Administration. You should find the environment.plist in $HOME/.MacOSX and ODBC.INI in $HOME/Library/odbc.ini. I have attached a sample environment plist and sample odbc.ini which you will need to tweek.

Sample: environment.plist

Again this file is located in $HOME/.MacOSX/environment.plist

<?xml version="1.0" encoding="UTF-8"?> ODBCINI /Users/demo/Library/ODBC/odbc.ini

DYLD_LIBRARY_PATH
/Users/demo/asa/lib:/Users/demo/asa/lib

DYLD_BIND_AT_LAUNCH
1

CLASSPATH
/Users/demo/asa/java/jodbc.jar:/Users/demo/shared/jConnect-5_5/classes/jconn2.jar

ASANY9
/Users/demo/asa

ASANYSH9
/Users/demo/shared

PATH
/bin:/sbin:/usr/bin:/usr/sbin:/Users/demo/asa/bin

Sample :ODBC.INI

[ODBC Data Sources]
ASA = ASA 9.0 Driver

[ASA]
Driver = /Users/demo/asa/lib/dbodbc9_r.bundle
uid = dba
pwd = sql
start = dbeng9
dbf = /Users/demo/asa/asademo.db
ThreadManager = on

[ODBC]
Trace = 1
TraceAutoStop = 0
TraceFile = /Users/demo/sql.log
TraceDLL =