I would like to use a SA 11.0.1 database as a datasource for Excel 2010 or InfoPath 2010 When I use the data connection wizard of Excel or InfoPath I can choose the Sybase ODBC DSN, connection test succeeds but after that a message appears reading: The Data Connection Wizard cannot obtain a list of databases from the specificed data source Any recommendations? |
A workaround is using Microsoft Query instead of direct ODBC connection. But this works only with Excel not with InfoPath (this seems to be a limitation by design of Microsoft) |
I've had this issue with InfoPath 2007, as it doesn't seem to like anything except SQL Server based sources. This is with SA 10.0.1, however, and I haven't tried Excel.
After a quick web search it seems, that for people using mySQL it is possible to do it that way