mysql - COMException using ODBC while trying to list "Views" in Codesmith -
i have established odbc connection mysql server (odbc driver version 5.1 oracle). connection test succeeds! if click show tables of database succeeds well. trying show views , following error:
das objekt oder der provider kann den angeforderten vorgang nicht ausführen. (translated: object or provider not capable of performing requested operation.) error of type "comexception" occurred while attempting populate schema information. please check data source settings , try again. ----------------------------------- system.runtime.interopservices.comexception (0x800a0cb3): das objekt oder der provider kann den angeforderten vorgang nicht ausführen (translated: object or provider not capable of performing requested operation.) @ adox.views.get_count() @ schemaexplorer.adoxschemaprovider.getviews(string connectionstring, databaseschema database) @ schemaexplorer.cachedschemaproviderproxy.getviews(string connectionstring, databaseschema database) @ schemaexplorer.databaseschema.#ege() @ #uhd.#vjd.#xhd() @ #uhd.#5hd.#4hd()
a similar error occures when trying list table columns,keys or index:
at (adox.tables.get_item(object item) @ schemaexplorer.adoxschemaprovider.gettableindexes(string connectionstring, tableschema table) @ schemaexplorer.tableschema.#she() @ #uhd.#zid.#xhd() @ #uhd.#5hd.#4hd()
aditional information: windows 7, 64 bits mysql odbc 5.1 driver
i tried include codesmith directory windows path environment var without success. ideas? need more information?
you need use mysqlschemaprovider instead of adoxschemaprovider. mysqlschemaprovider ships generator.
Comments
Post a Comment