SQLite connector doesn't see current database
Status: Beta
Brought to you by:
hawkmoon
Menu
▾
▴
#30 SQLite connector doesn't see current database
When connecting to a SQLite database via the PD ODBC connector, the current database name does not appear to be reported back through the driver. This appears to be a bug in the driver, not ODBCkit.
However, this means that the Tool assumes that there is no active DB on connection, so the schema display is not updated. We might want a little custom code in there for this case.
Discussion
Fixed. Two issues here, one is that the code I was using to return the database name was "to new", and SQLite didn't implement it. "Down converting" to the 1.x ODBC interface it understood fixed this, and other drivers continued to work as well.
This did have other interesting side effects. It *appears* that the SQLite driver indicates that the data type of the table name field is different than what the other drivers report. After getting back through ODBCRecordset the data is an NSString instead of an NSData, which required some patch up in SchemaDataSource. This problem may exist in other places too, but it would be rare - it's a difference in the way that the two systems return their META data, but the question is why any of them would return a type that gets converted to NSData...