#12 SybaseConnection _fromDatabase is broken

closed-accepted
nobody
None
5
2005-02-21
2005-01-17
No

The column query code in SybaseConnection is totally
broken; it appears to be lifted from another DB adaptor
without actually having been modified in order to work.
Attached patch queries INFORMATION_SCHEMA.COLUMNS
instead of syscolumns as per the suggestion in
http://msdn.microsoft.com/msdnmag/issues/04/11/DataPoints/default.aspx
(and because I couldn't figure out what to query using
syscolumns); it also adds a forceDBName argument to the
individual column creation if tables are to be taken
from the database, as I immediately got bitten by it
not being set due to a "foo-bar" column name in a
table. (it's a vendor provided DB schema)

With attached patch it appears to work, judging from
some quick tests.

Discussion

  • Ian Bicking
    Ian Bicking
    2005-02-21

    • status: open --> closed-accepted