UltraLite has a ODBC driver UltraLite17. There is no DSN available to use it. ODBC Data Source Manager (x64) allows you to create a DSN, but it is not useful as there is no provider information. Is this driver just for administration of server?
I believe that driver is only for use with SQL Central, dbisql and limited remote access from the database server. If you try to create a DSN using any version of that from (12, 16 or 17, possibly earlier) you will get a popup stating
"DSN support is not available. The driver is limited to SQL Anywhere UltraLite administration utilities only."
It probably was never available as a generic ODBC driver. In fact I believe support for an UL ODBC API was (otherwise) removed from supported (more classic) Static ODBC UltraLite {see UltraLite ODBC API no longer supported}
By no provider information, I suspect you are finding the call to SQLGetInfo( ) and the like return nothing useful. If so that would be due it's limited use (above).
That is odd ... must be due to the build you are running with on the 32bit side being different than the one I am running ... I get it with both Driver Managers.
That should not be the case. Both bitness should report the same message "DSN support is not available. This driver is limited to SQL Anywhere UltraLite administration tools only." if you attempt to access or create a DSN using the UltraLite driver. If it does not, it is not behaving correctly.
As Nick has already communicated, UltraLite does not have an ODBC interface. It must be accessed via one of its supported APIs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.