Our corporate standard OS is 32 bit Windows Vista.
The Sybase driver list at
sourceforge.net is only for Windows XP which will not work.
I searched internet and it looks like the only good sybase driver is one that has to be purchased.
There is also one with source which has to be built but that needs the Sybase SDK which is very expensive.
Anyway, we have an ODBC driver installed and working on our Vista machine.
So can we simply change dal.py to use odbc here?
i.e. will it work if we make this change?:
class SybaseAdapter(MSSQLAdapter):
driver = globals().get('Sybase',None)
to
driver = globals().get('pyodbc',None) <---------------------------------------------
Another temporary option is to take the 30 day trial driver from here:
Also note that we are using port forwarding and our database machine is very remote.
It is NOT the case that we have sybase installed locally on our laptop.
I also looked at the open source driver here
but even if we could somehow build it with the sybase SDK, I think it assumes sybase is installed locally.
Not sure if it can handle accessing a remote server.
Please advise.
Thanks.