The ASE 64-bit ODBC driver is hard (impossible?) to get for the developers edition of ASE 15.7 C:\Sybase\DataAccess\ODBC\dll\sybdrvodb64.dll The 32-bit MobiLink 12.0.1 server will not run on 64-bit windows, and the 64-bit MobiLink 12.0.1 server throws an "architectural mismatch" error when the ASE 32-bit ODBC driver is used C:\Sybase\DataAccess\ODBC\dll\sybdrvodb.dll Everything else works fine (32-bit SQL Anywhere 12.0.1 with 32-bit ODBC proxy tables on ASE 15.7, 32-bit Sybase Central, etc), it's just the MobiLink 12.0.1 server that has this limiitation. |
Answer: You can't. Workaround: Switch back to using SQL Anywhere and MobiLink Version 11 which does let you use the 32-bit ODBC driver for ASE 15.7 on a 64-bit Windows computer... see the comments above. Alternative:
64-bit ODBC Data Source Administrator: %windir%\system32\odbcad32.exe Add... ODBC Driver Name: Adaptive Server Enterprise Finish see "Adaptive Server Enterprise" Data Source Name: ddd Server Name: sss Server Port: 5000 Database Name: ddd Login Id: sa Password: Test Connection OK |
Temporary workaround: Falling back to MobiLink 11.0.1 where there is no limitation on running the 32-bit version of mlsrv11.exe on 64-bit Windows.
FWIW, at least for v16, ASE 15.7 seems to be an officially not supported version (and for v12, we both are aware that the official document is not currently available online...) - from the Recommended ODBC Drivers for 16.0 MobiLink page:
Ah, the situation is different for v12.0.1, as Jose Ramos tells on a comment from that page:
An even better alternative would be to use SQL Anywhere 16 as the consolidated database instead of ASE 15.7, but alas...
The workaround appears to be ok, but it did require all the Version 12 ml_objects to be dropped from ASE 15.7 and replaced with Version 11 ml_objects before mlsrv11.exe would function properly.
For the record, here's part 1 of the DROP order that works in the face of RI constraints...
Here's part 2...