Have installed UniData Personal Edition 6.0 and UniDK with UniData ODBC driver. Have modified uci.config per documentation to point to UniData demo database and added ODBC data source.
In MS SQL Server, invoked DTS Import/Export Wizard to try to import data, entered UniData data source for Source DB, SQL Server as Target. It gets to the "Specify Table Copy or Query" window with "Copy Tables..." clicked on. Chose Next and got "Error Description: Unspecified error [Ardent][UniData ODBC Driver][IBM][SQL Client][UNIDATA]You have no privilege on file SQLTables" and "Context: Error calling GetRowset to get DBSCHEMA_TABLES schema info. Your provider does not support all the schema rowsets required by DTS."
I think I've done everything specified in UniData doc to set the db up. My user login is part of Administrators group in XP Professional. UDT works fine as does UniSQL.
Anyone had success doing this? Thanks
In MS SQL Server, invoked DTS Import/Export Wizard to try to import data, entered UniData data source for Source DB, SQL Server as Target. It gets to the "Specify Table Copy or Query" window with "Copy Tables..." clicked on. Chose Next and got "Error Description: Unspecified error [Ardent][UniData ODBC Driver][IBM][SQL Client][UNIDATA]You have no privilege on file SQLTables" and "Context: Error calling GetRowset to get DBSCHEMA_TABLES schema info. Your provider does not support all the schema rowsets required by DTS."
I think I've done everything specified in UniData doc to set the db up. My user login is part of Administrators group in XP Professional. UDT works fine as does UniSQL.
Anyone had success doing this? Thanks